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</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.</p> Signup and view all the answers

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

    <p>Enable iterative calculation</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.</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.</p> Signup and view all the answers

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

    <p>PgDn</p> Signup and view all the answers

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

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

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

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

    How can you decrease the font size in Excel?

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

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

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

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

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

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

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

    Which option is used in Excel to recalculate all worksheets?

    <p>F9</p> Signup and view all the answers

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

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

    How can you open the Insert Formula dialog in Excel?

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

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

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

    How can you activate a control in Excel?

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

    More Like This

    Use Quizgecko on...
    Browser
    Open
    Browser
    Browser