Basic Excel Keyboard Shortcuts

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Learn about Our Editorial Process
| By Grahamw
G
Grahamw
Community Contributor
Quizzes Created: 1 | Total Attempts: 2,948
Questions: 12 | Attempts: 2,957

SettingsSettingsSettings
Basic Excel Keyboard Shortcuts - Quiz


Questions and Answers
  • 1. 

    What keys close workbook?

    • A.

      Ctrl+F4

    • B.

      Ctrl+T

    • C.

      F11

    • D.

      Ctrl+Spacebar

    Correct Answer
    A. Ctrl+F4
    Explanation
    Ctrl+F4 is the correct answer because it is a keyboard shortcut used to close the active workbook in many applications, including Microsoft Excel. This shortcut is commonly used to quickly close a workbook without having to use the mouse or navigate through menus. By pressing Ctrl+F4, the user can efficiently close the current workbook and move on to other tasks.

    Rate this question:

  • 2. 

    How do you create a table?

    • A.

      Ctrl+O

    • B.

      Ctrl+T

    • C.

      Ctrl+B

    • D.

      Ctrl+L

    Correct Answer
    B. Ctrl+T
    Explanation
    To create a table, you can use the shortcut Ctrl+T. This shortcut is commonly used in various software applications, including spreadsheet programs and database management systems. By pressing Ctrl+T, you can quickly create a table structure and start entering data into it. This shortcut saves time and provides a convenient way to create tables without having to navigate through menus or use other methods.

    Rate this question:

  • 3. 

    How do you insert a worksheet?

    • A.

      Shift+F11

    • B.

      Ctrl+-

    • C.

      Ctrl++

    • D.

      F1

    Correct Answer
    A. Shift+F11
    Explanation
    To insert a worksheet in Microsoft Excel, you can use the keyboard shortcut Shift+F11. This shortcut will create a new worksheet and insert it before the current worksheet. It is a quick and convenient way to add a new worksheet to your Excel workbook without having to navigate through the menus or use the mouse.

    Rate this question:

  • 4. 

    Open Workbook

    • A.

      Ctrl+O

    • B.

      Ctrl+F2

    • C.

      O

    • D.

      Ctrl+Shift+;+O

    Correct Answer
    A. Ctrl+O
    Explanation
    The correct answer is Ctrl+O. This keyboard shortcut is commonly used to open a workbook in various software applications, including Microsoft Excel. By pressing Ctrl+O, users can quickly access the "Open" dialog box, where they can select and open the desired workbook file. This shortcut is efficient and saves time compared to manually navigating through menus to find the "Open" option.

    Rate this question:

  • 5. 

    Print Preview

    • A.

      Ctrl+F2

    • B.

      Ctrl+Shift

    • C.

      F11

    • D.

      F2

    Correct Answer
    A. Ctrl+F2
    Explanation
    Ctrl+F2 is the correct answer because it is a keyboard shortcut that is commonly used to open the Print Preview window in many applications. This shortcut allows users to quickly preview how a document or webpage will appear when printed, without actually printing it. By pressing Ctrl+F2, users can easily check for any formatting or layout issues before printing, saving time and resources.

    Rate this question:

  • 6. 

    SUM Function

    • A.

      Ctrl + Shift

    • B.

      F11

    • C.

      Alt + =

    • D.

      Ctrl + Shift ;

    Correct Answer
    C. Alt + =
    Explanation
    Alt + = is the correct answer because it is the keyboard shortcut for the SUM function in Microsoft Excel. This shortcut allows users to quickly sum a range of cells by automatically inserting the SUM formula. By selecting a range of cells and then pressing Alt + =, Excel will insert the SUM function and calculate the total of the selected cells. This shortcut can save time and make it easier to perform calculations in Excel.

    Rate this question:

  • 7. 

    Total Row

    • A.

      Ctrl +F2

    • B.

      F11

    • C.

      Ctrl + Shift +T

    • D.

      Ctrl F4

    Correct Answer
    C. Ctrl + Shift +T
    Explanation
    Pressing Ctrl + Shift + T is the correct answer because it is the keyboard shortcut to create a new row in a spreadsheet program. This shortcut is commonly used in programs like Microsoft Excel or Google Sheets to quickly insert a new row above the selected row. By using this shortcut, users can efficiently add new data or adjust the layout of their spreadsheet without the need for manual insertion or copy-pasting.

    Rate this question:

  • 8. 

    Edit Cells

    • A.

      F11

    • B.

      F4

    • C.

      F2

    • D.

      F7

    Correct Answer
    C. F2
    Explanation
    The correct answer is F2. F2 is the keyboard shortcut used to edit the contents of a cell in Excel. By pressing F2, the cell becomes active and you can make changes to the text or formulas within the cell. This is a commonly used shortcut in Excel for quickly editing cell contents without using the mouse.

    Rate this question:

  • 9. 

    Select an entire row

    • A.

      Shift + F11

    • B.

      Shift + Spacebar

    • C.

      Option 3

    • D.

      Option 4

    Correct Answer
    B. Shift + Spacebar
    Explanation
    To select an entire row in most applications, you can use the Shift + Spacebar keyboard shortcut. This combination will highlight the entire row that is currently selected or the row where the cursor is located. It is a quick and efficient way to select a row without having to manually click and drag over each cell.

    Rate this question:

  • 10. 

    Insert Blank Cells

    • A.

      Ctrl + A

    • B.

      Ctrl + 11

    • C.

      Ctrl + B

    • D.

      Ctrl + Shift ++

    Correct Answer
    D. Ctrl + Shift ++
    Explanation
    Ctrl + Shift ++ is the correct answer because it is the shortcut key to insert blank cells in Excel. By pressing this combination, you can easily insert blank cells into a selected range or column in your worksheet. This can be useful when you want to add space or create gaps within your data without having to manually shift and adjust the cells.

    Rate this question:

  • 11. 

    Insert Current Date

    • A.

      Ctrl + :

    • B.

      Ctrl + ?

    • C.

      Ctrl + ;

    • D.

      Ctrl + D

    Correct Answer
    C. Ctrl + ;
    Explanation
    Ctrl + ; is the correct answer because it is the keyboard shortcut to insert the current date in various applications such as Microsoft Excel, Word, and PowerPoint. This shortcut allows users to quickly add the current date to their documents or spreadsheets without manually typing it. It is a time-saving feature that improves productivity and accuracy when working with date-related data or documents.

    Rate this question:

  • 12. 

    Create A Chart

    • A.

      F2

    • B.

      F12

    • C.

      F9

    • D.

      F11

    Correct Answer
    D. F11
    Explanation
    F11 is the correct answer because it is a keyboard shortcut used to create a chart in various software applications, including Microsoft Excel and Google Sheets. By pressing the F11 key, users can quickly generate a chart based on the selected data in the spreadsheet. This shortcut saves time and allows for efficient data visualization and analysis.

    Rate this question:

Quiz Review Timeline +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • May 06, 2024
    Quiz Edited by
    ProProfs Editorial Team
  • Dec 17, 2015
    Quiz Created by
    Grahamw
Back to Top Back to top
Advertisement