Excel 2016 Keyboard Shortcuts Quiz

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to Lesson

Podcast

Play an AI-generated podcast conversation about this lesson
Download our mobile app to listen on the go
Get App

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

Flashcards are hidden until you start studying

More Like This

Use Quizgecko on...
Browser
Browser