Microsoft Excel Shortcuts
42 Questions
1 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

What happens when you press CTRL+A in Excel?

  • Selects the entire row
  • Selects the current region and its summary rows
  • Selects the entire worksheet (correct)
  • Deletes the current row

    • What is the function of CTRL+SHIFT+L in Excel?

  • Applies or removes underlining
  • Applies or removes bold formatting
  • Applies or removes italic formatting
  • Applies or removes filter (correct)

    • What is the shortcut to copy the contents and format of the topmost cell of a selected range into the cells below?

  • CTRL+D (correct)
  • CTRL+B
  • CTRL+C
  • CTRL+V

    • What is the function of CTRL+; in Excel?

    <p>Enters the current date</p> Signup and view all the answers

    What is the function of CTRL+~ in Excel?

    <p>Alternates between displaying cell values and displaying formulas</p> Signup and view all the answers

    What is the function of CTRL+1 in Excel?

    <p>Displays the Format Cells dialog box</p> Signup and view all the answers

    What is the function of CTRL+6 in Excel?

    <p>Alternates between hiding objects, displaying objects, and displaying placeholders for objects</p> Signup and view all the answers

    What is the function of CTRL+C followed by another CTRL+C in Excel?

    <p>Displays the Clipboard</p> Signup and view all the answers

    What does pressing F6 do in Excel?

    <p>Switches between the worksheet, Ribbon, task pane, and Zoom controls</p> Signup and view all the answers

    What does pressing SHIFT+F6 do in Excel?

    <p>Switches between the worksheet, Ribbon, task pane, and Zoom controls</p> Signup and view all the answers

    What does pressing CTRL+F6 do in Excel?

    <p>Switches to the next workbook window when more than one workbook window is open</p> Signup and view all the answers

    What does pressing F7 do in Excel?

    <p>Displays the Spelling dialog box to check spelling</p> Signup and view all the answers

    What does pressing CTRL+F7 do in Excel?

    <p>Performs the Move command on the workbook window</p> Signup and view all the answers

    What does pressing F8 do in Excel?

    <p>Turns extend mode on or off</p> Signup and view all the answers

    What does pressing SHIFT+F8 do in Excel?

    <p>Enables adding nonadjacent cells or ranges to a selection</p> Signup and view all the answers

    What does pressing F9 do in Excel?

    <p>Calculates all worksheets in all open workbooks</p> Signup and view all the answers

    What is the shortcut to access the Visual Basic Window?

    <p>ALT+L+V</p> Signup and view all the answers

    Which shortcut is used to record a macro in Excel?

    <p>ALT+L+R</p> Signup and view all the answers

    What is the shortcut to access the 'More Controls' option within Active X Controls?

    <p>ALT+L+I+M</p> Signup and view all the answers

    Which shortcut is used to enter Design Mode in Excel?

    <p>ALT+L+D+M</p> Signup and view all the answers

    What is the shortcut to access the 'Properties' window in Excel?

    <p>ALT+L+L</p> Signup and view all the answers

    Which shortcut is used to view the source code of a selected object in Excel?

    <p>ALT+L+X</p> Signup and view all the answers

    What is the shortcut to access the 'Run Dialog' in Excel?

    <p>ALT+L+N</p> Signup and view all the answers

    Which shortcut allows you to move to the next cell in a worksheet?

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

    What does the shortcut ALT+SHIFT+F10 do?

    <p>Displays the menu for a smart tag</p> Signup and view all the answers

    Which shortcut would you use to create a chart of the current data range?

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

    What is the function of the shortcut ALT+I+C?

    <p>Insert a column</p> Signup and view all the answers

    What does pressing ALT+F+O+K do?

    <p>Opens a file from OneDrive</p> Signup and view all the answers

    Which shortcut is used to increase font size quickly?

    <p>ALT+H+F+G</p> Signup and view all the answers

    To access the Visual Basic Editor, which shortcut should you use?

    <p>ALT+F11</p> Signup and view all the answers

    What does ALT+N+V enable the user to do?

    <p>Create a pivot table</p> Signup and view all the answers

    Which shortcut will toggle between showing all or limited properties?

    <p>ALT+F+I+Q+P</p> Signup and view all the answers

    Which shortcut is utilized for Autosum?

    <p>ALT+H+U</p> Signup and view all the answers

    What does ALT+F+E+C+D+A accomplish?

    <p>Save as another file type</p> Signup and view all the answers

    What does the CTRL+PAGE DOWN shortcut do?

    <p>Moves to the next sheet in a workbook.</p> Signup and view all the answers

    Which shortcut selects the entire row in a worksheet?

    <p>SHIFT+SPACEBAR</p> Signup and view all the answers

    What action does pressing the SPACEBAR in a dialog box perform?

    <p>Performs the action for the selected button.</p> Signup and view all the answers

    When is CTRL+SHIFT+SPACEBAR used to select the entire worksheet?

    <p>When pressed three times.</p> Signup and view all the answers

    Which shortcut moves one screen up in a worksheet?

    <p>PAGE UP</p> Signup and view all the answers

    What does the SHIFT+TAB shortcut do?

    <p>Moves to the previous cell in a worksheet.</p> Signup and view all the answers

    Which of the following shortcuts selects the current and next sheets in a workbook?

    <p>CTRL+SHIFT+PAGE DOWN</p> Signup and view all the answers

    What does the ALT+SPACEBAR shortcut display?

    <p>Control menu for the Excel window.</p> Signup and view all the answers

    Study Notes

    Excel Shortcuts

    • Delete rows/columns: If entire row(s) / column(s) is selected, it deletes them.
    • Filtering: CTRL+SHIFT+L applies/removes filter.
    • Date entry: CTRL+; enters the current date.
    • Formula display: CTRL+~ alternates between displaying cell values and displaying formulas in the worksheet.
    • Copy formula: CTRL+' copies a formula from the cell above the active cell into the cell or the Formula Bar.

    Formatting

    • Format cells: CTRL+1 displays the Format Cells dialog box.
    • Bold formatting: CTRL+2 applies or removes bold formatting.
    • Italic formatting: CTRL+3 applies or removes italic formatting.
    • Underlining: CTRL+4 applies or removes underlining.
    • Strikethrough: CTRL+5 applies or removes strikethrough.

    Object manipulation

    • Object display: CTRL+6 alternates between hiding objects, displaying objects, and displaying placeholders for objects.
    • Outline symbols: CTRL+8 displays or hides the outline symbols.
    • Row/Column hiding: CTRL+9 hides the selected rows, CTRL+0 hides the selected columns.

    Worksheet selection

    • Select entire worksheet: CTRL+A selects the entire worksheet.
    • Select current region: When the worksheet contains data, CTRL+A selects the current region.
    • Select summary rows: Pressing CTRL+A a second time selects the current region and its summary rows.
    • Select entire worksheet (again): Pressing CTRL+A a third time selects the entire worksheet.

    Function arguments

    • Function Arguments dialog box: When the insertion point is to the right of a function name in a formula, displays the Function Arguments dialog box.
    • Argument names and parentheses: CTRL+SHIFT+A inserts the argument names and parentheses when the insertion point is to the right of a function name in a formula.

    Copy, Fill, and Clipboard

    • Copy cells: CTRL+C copies the selected cells.
    • Clipboard display: CTRL+C followed by another CTRL+C displays the Clipboard.
    • Fill Down command: CTRL+D uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below.
    • Refresh links: CTRL+ALT+F5 refreshes all links.
    • Switch between panes: F6 switches between the worksheet, Ribbon, task pane, and Zoom controls.
    • Split panes: In a worksheet that has been split, F6 includes the split panes when switching between panes and the Ribbon area.
    • Next workbook window: CTRL+F6 switches to the next workbook window when more than one workbook window is open.
    • Spelling dialog box: F7 displays the Spelling dialog box to check spelling in the active worksheet or selected range.
    • Move command: F7 performs the Move command on the workbook window when it is not maximized.
    • Extend mode: F8 turns extend mode on or off.
    • Nonadjacent cell selection: SHIFT+F8 enables you to add a nonadjacent cell or range to a selection of cells by using the arrow keys.
    • Macro dialog box: ALT+F8 displays the Macro dialog box to create, run, edit, or delete a macro.

    Calculation and recalculation

    • Calculate all worksheets: F9 calculates all worksheets in all open workbooks.
    • Calculate active worksheet: SHIFT+F9 calculates the active worksheet.
    • Calculate all worksheets (regardless of changes): CTRL+ALT+F9 calculates all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.
    • Recheck dependent formulas and calculate: CTRL+ALT+SHIFT+F9 rechecks dependent formulas, and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated.

    Miscellaneous

    • Minimize workbook window: F9 minimizes a workbook window to an icon.
    • Key tips: F10 turns key tips on or off.
    • Shortcut menu: SHIFT+F10 displays the shortcut menu for a selected item.Here are the study notes for the text:
    • ALT Keys for Excel*
    • File Tab ALT Keys
      • ALT+F: Displays Backstage view
      • ALT+F+N: Creates a new workbook
      • ALT+F+O: Opens an existing workbook
      • ALT+F+S: Saves the workbook
      • ALT+F+P: Prints the workbook
      • ... (more options)
    • Home Tab ALT Keys
      • ALT+H: Goes to Home tab
      • ALT+H+X: Cuts
      • ALT+H+C: Copies
      • ALT+H+F+P: Format Painter
      • ... (more options)
    • Insert Tab ALT Keys
      • ALT+N: Inserts a### Switch Windows
    • ALT+W+M+V: View Macros
    • ALT+W+M+R: Record Macros
    • ALT+W+M+U: Use Relative References

    Developer Tab Shortcuts

    • ALT+L+V: Visual Basic Window
    • ALT+L+P+M: Macros Window
    • ALT+L+R: Record Macro
    • ALT+L+U: Use Relative Reference
    • ALT+L+A+S: Macro Security
    • ALT+L+H: Add-ins
    • ALT+L+J: COM Add-ins

    Form Controls and Active X Controls

    • ALT+L+I+B: Form Controls > Button
    • ALT+L+I+C: Form Controls > Combo Box
    • ALT+L+I+H: Form Controls > Check Box
    • ALT+L+I+S: Form Controls > Spin Button
    • ALT+L+I+I: Form Controls > List Box
    • ALT+L+I+P: Form Controls > Option Button
    • ALT+L+I+G: Form Controls > Group Box
    • ALT+L+I+L: Form Controls > Label
    • ALT+L+I+S: Form Controls > Scroll Bar
    • ALT+L+I+B: Active X Controls > Button
    • ALT+L+I+L: Active X Controls > List Box
    • ALT+L+I+T: Active X Controls > Text Box
    • ALT+L+I+S: Active X Controls > Scroll Bar
    • ALT+L+I+N: Active X Controls > Spin Button
    • ALT+L+I+O: Active X Controls > Option Button
    • ALT+L+I+A: Active X Controls > Label
    • ALT+L+I+I: Active X Controls > Image
    • ALT+L+I+G: Active X Controls > Toggle Buttons
    • ALT+L+I+M: Active X Controls > More Controls

    Other Shortcuts

    • ARROW: Move one cell up, down, left, or right in a worksheet
    • PAGE DOWN: Moves one screen down in a worksheet
    • ALT+PAGE DOWN: Moves one screen to the right in a worksheet
    • CTRL+PAGE DOWN: Moves to the next sheet in a workbook
    • CTRL+SHIFT+PAGE DOWN: Selects the current and next sheet in a workbook
    • PAGE UP: Moves one screen up in a worksheet
    • ALT+PAGE UP: Moves one screen to the left in a worksheet
    • CTRL+PAGE UP: Moves to the previous sheet in a workbook
    • CTRL+SHIFT+PAGE UP: Selects the current and previous sheet in a workbook
    • SPACEBAR: In a dialog box, performs the action for the selected button, or selects or clears a check box
    • CTRL+SPACEBAR: Selects an entire column in a worksheet
    • SHIFT+SPACEBAR: Selects an entire row in a worksheet
    • CTRL+SHIFT+SPACEBAR: Selects the entire worksheet
    • ALT+SPACEBAR: Displays the Control menu for the Microsoft Office Excel window
    • TAB: Moves one cell to the right in a worksheet
    • SHIFT+TAB: Moves to the previous cell in a worksheet or the previous option in a dialog box
    • CTRL+TAB: Switches to the next tab in dialog box
    • CTRL+SHIFT+TAB: Switches to the previous tab in a dialog box

    Studying That Suits You

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

    Quiz Team

    Related Documents

    Excel.pdf

    Description

    This quiz covers essential shortcuts in Microsoft Excel, improving productivity and efficiency in worksheet management. Learn Ctrl+ shortcuts for deleting rows, applying filters, and formatting cells.

    More Like This

    Use Quizgecko on...
    Browser
    Open
    Browser
    Browser