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

Grahamw

Community Contributor

Quizzes Created: 1 | Total Attempts: 3,501

| Attempts: 3,517

Questions

Feedback

During the Quiz End of Quiz

Difficulty

Easy First Hard First Sequential

Share on Facebook Share on Twitter Share on Whatsapp Share on Pinterest Share on Email Copy to Clipboard Embed on your website

1/12 Questions

What keys close workbook?
- Ctrl+F4
- Ctrl+T
- F11
- Ctrl+Spacebar

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.

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:

2
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:

2
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:

1
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:

1
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:

1
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:

1
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:

3
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:

2
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:

2

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

Basic Excel Keyboard Shortcuts

What keys close workbook?

Quiz Preview

How do you create a table?

How do you insert a worksheet?

Open Workbook

Print Preview

SUM Function

Total Row

Edit Cells

Select an entire row

Insert Blank Cells

Insert Current Date

Create A Chart