Excel Hotkeys Flashcards
What is the hotkey to enter the menu?
ALT
Which key combination is used to delete cell contents?
FN + Backspace
How do you create an AutoSum in a cell?
OPT =
What is the shortcut for selecting all columns?
CTL SPACE
How do you move between tabs without using the mouse?
CTL PAGE UP and PAGE DOWN
Fill in the blank: The formula to calculate the quarter is _______.
”= “Q” & ROUNDUP(E7/3,0)”
What key combination allows you to jump back to a cell reference?
CTL [
What does FN+F9 do?
Preview calculation answers in formula
Which key combination opens the list of data validation?
ALT and Down Arrow
How do you group data in Excel using keyboard shortcuts?
ALT + Shift + Right Arrow
What is the shortcut to select all rows?
ALT + Space Bar
What is the shortcut for the Paste Special function?
OPT ALT V
How do you autofill a formula to the right?
CTL R
How do you select all rows and two additional columns?
CTL SPACE plus two columns
