20 Questions
Which shortcut is used to move one screen to the right on a Mac?
Alt + PgDn
What is the shortcut to go to cell A1 in Excel 2016 on Windows?
Ctrl + Home
How can you select a cell range in Excel 2016 on a Mac?
⌘ + 1
What is the shortcut for opening the Format Cells dialog in Excel 2016 on Windows?
⌘ + 1
How can you enable Ctrl+Arrows by disabling Mission Control settings?
Go to System Preferences > Keyboard and click off 'Move left a space' and 'Move right a space' under Mission Control settings.
Which setting needs to be chosen under Calculation options in Excel settings/preferences?
Enable iterative calculation
How can you disable Autocomplete for cell values in Excel settings/preferences on Windows?
Turn off 'Enable AutoComplete for cell values' under Options > Advanced > Editing Options.
What needs to be done to use function keys as standard function keys on a Mac system?
Check 'Use all F1, F2, etc. keys as standard function keys' in Excel settings/preferences.
How can you extend the selection down a screen in Excel?
PgDn
Which shortcut is used to apply the Percent format in Excel?
Ctrl + ⌱ + %
What is the shortcut to fill down from the cell above in Excel?
Ctrl + D
How can you decrease the font size in Excel?
Alt + H FK
Which shortcut is used to insert/edit a comment in Excel?
Ctrl + F2
What is the shortcut to remove a border around cells in Excel?
Ctrl + ⇱ + -
How can you fit to a specific row height in Excel?
Alt + H O I
Which option is used in Excel to recalculate all worksheets?
F9
What is the shortcut to jump to the beginning of a cell in Excel?
^ Home
How can you open the Insert Formula dialog in Excel?
^ F4
Which shortcut is used to get inside a drop-down list in Excel?
Opt + ↑ or ↓
How can you activate a control in Excel?
Underlined Letter
Test your knowledge of Excel 2016 keyboard shortcuts with this quiz. From basic editing functions to navigating around a worksheet, this quiz covers a variety of helpful shortcuts for both Windows and Mac users.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free