Excel 2016 Keyboard Shortcuts Quiz
20 Questions
2 Views

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to Lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

Which shortcut is used to move one screen to the right on a Mac?

  • Alt + PgDn (correct)
  • Ctrl + Tab
  • Fn + Opt + ↓
  • Fn + Opt + ↑

What is the shortcut to go to cell A1 in Excel 2016 on Windows?

  • Ctrl + Tab
  • Fn + Ctrl + ←
  • Ctrl + Home (correct)
  • Fn + Opt + ↑

How can you select a cell range in Excel 2016 on a Mac?

  • ⌘ + ~
  • ⌘ + 1 (correct)
  • Ctrl + B
  • Ctrl + 1

What is the shortcut for opening the Format Cells dialog in Excel 2016 on Windows?

<p>⌘ + 1 (A)</p> Signup and view all the answers

How can you enable Ctrl+Arrows by disabling Mission Control settings?

<p>Go to System Preferences &gt; Keyboard and click off 'Move left a space' and 'Move right a space' under Mission Control settings. (C)</p> Signup and view all the answers

Which setting needs to be chosen under Calculation options in Excel settings/preferences?

<p>Enable iterative calculation (A)</p> Signup and view all the answers

How can you disable Autocomplete for cell values in Excel settings/preferences on Windows?

<p>Turn off 'Enable AutoComplete for cell values' under Options &gt; Advanced &gt; Editing Options. (D)</p> Signup and view all the answers

What needs to be done to use function keys as standard function keys on a Mac system?

<p>Check 'Use all F1, F2, etc. keys as standard function keys' in Excel settings/preferences. (D)</p> Signup and view all the answers

How can you extend the selection down a screen in Excel?

<p>PgDn (A)</p> Signup and view all the answers

Which shortcut is used to apply the Percent format in Excel?

<p>Ctrl + ⌱ + % (A)</p> Signup and view all the answers

What is the shortcut to fill down from the cell above in Excel?

<p>Ctrl + D (B)</p> Signup and view all the answers

How can you decrease the font size in Excel?

<p>Alt + H FK (D)</p> Signup and view all the answers

Which shortcut is used to insert/edit a comment in Excel?

<p>Ctrl + F2 (C)</p> Signup and view all the answers

What is the shortcut to remove a border around cells in Excel?

<p>Ctrl + ⇱ + - (C)</p> Signup and view all the answers

How can you fit to a specific row height in Excel?

<p>Alt + H O I (C)</p> Signup and view all the answers

Which option is used in Excel to recalculate all worksheets?

<p>F9 (A)</p> Signup and view all the answers

What is the shortcut to jump to the beginning of a cell in Excel?

<p>^ Home (D)</p> Signup and view all the answers

How can you open the Insert Formula dialog in Excel?

<p>^ F4 (B)</p> Signup and view all the answers

Which shortcut is used to get inside a drop-down list in Excel?

<p>Opt + ↑ or ↓ (A)</p> Signup and view all the answers

How can you activate a control in Excel?

<p>Underlined Letter (B)</p> Signup and view all the answers

More Like This

Use Quizgecko on...
Browser
Browser