Basic Excel Keyboard Shortcuts

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Grahamw
G
Grahamw
Community Contributor
Quizzes Created: 1 | Total Attempts: 3,501
| Attempts: 3,594
SettingsSettings
Please wait...
  • 1/12 Questions

    What keys close workbook?

    • Ctrl+F4
    • Ctrl+T
    • F11
    • Ctrl+Spacebar
Please wait...
About This Quiz

This quiz focuses on basic Excel keyboard shortcuts, essential for enhancing productivity and efficiency in spreadsheet management. It covers key functions like closing workbooks, creating tables, inserting worksheets, and more, providing a practical learning tool for users aiming to improve their Excel skills.

Basic Excel Keyboard Shortcuts - Quiz

Quiz Preview

  • 2. 

    How do you create a table?

    • Ctrl+O

    • Ctrl+T

    • Ctrl+B

    • Ctrl+L

    Correct Answer
    A. 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?

    • Shift+F11

    • Ctrl+-

    • Ctrl++

    • 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

    • Ctrl+O

    • Ctrl+F2

    • O

    • 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

    • Ctrl+F2

    • Ctrl+Shift

    • F11

    • 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

    • Ctrl + Shift

    • F11

    • Alt + =

    • Ctrl + Shift ;

    Correct Answer
    A. 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

    • Ctrl +F2

    • F11

    • Ctrl + Shift +T

    • Ctrl F4

    Correct Answer
    A. 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

    • F11

    • F4

    • F2

    • F7

    Correct Answer
    A. 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

    • Shift + F11

    • Shift + Spacebar

    • Option 3

    • Option 4

    Correct Answer
    A. 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

    • Ctrl + A

    • Ctrl + 11

    • Ctrl + B

    • Ctrl + Shift ++

    Correct Answer
    A. 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

    • Ctrl + :

    • Ctrl + ?

    • Ctrl + ;

    • Ctrl + D

    Correct Answer
    A. 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

    • F2

    • F12

    • F9

    • F11

    Correct Answer
    A. 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 (Updated): May 6, 2024 +

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

Recent Quizzes

Charts in MS Excel Charts in MS Excel
Excel Basics Quiz (Level1) Excel Basics Quiz (Level1)
The Ultimate Microsoft Excel Trivia Knowledge! Quiz The Ultimate Microsoft Excel Trivia Knowledge! Quiz
Microsoft Excel Trivia Quiz Questions! Microsoft Excel Trivia Quiz Questions!
Advanced Excel Online Test Advanced Excel Online Test
Financial and excel modelling quiz Financial and excel modelling quiz
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.