Excel Shortcuts Quiz
10 Questions
0 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 keyboard shortcut is used to close the current workbook in Excel?

  • Ctrl + Q
  • Ctrl + E
  • Ctrl + W (correct)
  • Ctrl + F4
  • What is the shortcut to create a new workbook in Excel?

  • Ctrl + R
  • Ctrl + M
  • Ctrl + N (correct)
  • Ctrl + A
  • Which shortcut will help you save a workbook in Excel?

  • Ctrl + C
  • Ctrl + S (correct)
  • Ctrl + D
  • Ctrl + P
  • To move to the next sheet in an Excel workbook, which shortcut should you use?

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

    Which key combination would you use to open an existing workbook in Excel?

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

    Which shortcut is used to add a comment to a cell?

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

    What is the shortcut for centering the alignment of cell contents?

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

    Which shortcut would you use to remove an outline border from a cell?

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

    What is the function of the shortcut Ctrl + H in Excel?

    <p>To display find and replace</p> Signup and view all the answers

    What action does the shortcut Ctrl + Shift + Down Arrow perform?

    <p>Select the column from selected cell to the end of the table</p> Signup and view all the answers

    Study Notes

    Excel Shortcuts

    • Excel supports a variety of keyboard shortcuts to boost efficiency and productivity.
    • These shortcuts can help save time and reduce the need to use the mouse.
    • While memorizing all shortcuts can be useful, focusing on common ones is a good starting point.
    • With regular use, you’ll naturally remember more shortcuts.

    Workbook Shortcut Keys

    • Ctrl + N: Creates a new workbook
    • Ctrl + O: Opens an existing workbook
    • Ctrl + S: Saves a workbook or spreadsheet
    • Ctrl + W: Closes the current workbook
    • Ctrl + F4: Closes Excel application
    • Ctrl + PageDown: Navigates to the next sheet
    • Ctrl + PageUp: Navigates to the previous sheet
    • Alt + A: Accesses the Data tab
    • Alt + W: Accesses the View tab
    • Alt + M: Accesses the Formula tab

    Cell Formatting Shortcut Keys

    • F2: Edits a cell.
    • Ctrl + C, Ctrl + V: Copies and pastes cells.
    • Ctrl + I, Ctrl + B: Italicizes and bolds text in a cell.
    • Alt + H + A + C: Centers content within a cell.
    • Alt + H + H: Fills a cell with color.
    • Alt + H + B: Adds a border to a cell.
    • Ctrl + Shift + _: Removes outline border.
    • Ctrl + Shift + &: Adds an outline to selected cells.
    • Tab: Moves to the next cell.
    • Shift + Tab: Moves to the previous cell.
    • Ctrl + Shift + Right arrow: Selects all cells to the right.
    • Ctrl + Shift + Left Arrow: Selects all cells to the left.
    • Ctrl + Shift + Down Arrow: Selects all cells below the selected cell.
    • Ctrl + Shift + Up Arrow: Selects all cells above the selected cell.

    Advanced Cell Formatting Shortcuts

    • Shift + F2: Adds a comment to a cell.
    • Shift + F10 + D: Deletes a cell comment.
    • Ctrl + H: Opens the Find and Replace dialog box.
    • Ctrl + Shift + L: Activates the filter for a selected area.
    • Ctrl + K: Inserts a hyperlink to a cell.
    • Ctrl + 1: Opens the Format Cells dialog box.

    Data Manipulation Shortcuts

    • Ctrl + Shift + ~: Toggles formula viewing for selected cells.
    • Ctrl + 1: Formats the selected cell(s).
    • Ctrl + Spacebar: Selects the entire column of the active cell.
    • Shift + Spacebar: Selects the entire row of the active cell.
    • Ctrl + A: Selects the entire worksheet.
    • F4: Repeats the last action, useful for repetitive formatting.
    • Alt + Enter: Inserts a line break within a cell.
    • F1: Opens Excel Help.

    Editing Shortcuts

    • Ctrl + Z: Undoes the last action.
    • Ctrl + Y: Redoes the last action.
    • Ctrl + X: Cuts selected cells or text.
    • Ctrl + D: Fills down the selected cell.
    • Ctrl + R: Fills right the selected cell.
    • Ctrl + Enter: Inserts a line break within a cell.
    • Delete: Clears the content of a selected cell.

    Formulas and Functions Shortcuts

    • F2: Edits the cell containing the formula.
    • Alt + =: Inserts the SUM function on the selected cell range.
    • Ctrl + `: Toggles between formula view and result view.
    • Alt + Enter: Inserts a line break within a cell.

    Miscellaneous

    • Ctrl + ~: Converts a cell to a different format.
    • Ctrl + P: Prints selected cells or worksheet.
    • Shift + F10: Shows a context menu for the selected area.
    • Alt + H: Opens the Home tab.

    Studying That Suits You

    Use AI to generate personalized quizzes and flashcards to suit your learning preferences.

    Quiz Team

    Description

    Test your knowledge on essential Excel shortcuts that enhance productivity and efficiency while using spreadsheets. This quiz covers common shortcut keys for workbooks and cell formatting, helping you navigate Excel like a pro.

    More Like This

    Excel Shortcuts and Functions Quiz
    5 questions
    Microsoft Excel Shortcuts
    42 questions
    Excel Keyboard Shortcuts Quiz
    13 questions
    Use Quizgecko on...
    Browser
    Browser