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

Grahamw

Community Contributor

Quizzes Created: 1 | Total Attempts: 2,667

Questions: 12 | Attempts: 2,671 | Updated: Mar 21, 2023

Questions

Settings

Create your own Quiz

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

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:

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

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

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

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

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

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

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

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

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

1
0

Quiz Review Timeline +

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

Current Version
Mar 21, 2023

Quiz Edited by
ProProfs Editorial Team
Dec 17, 2015

Quiz Created by
Grahamw

Basic Excel Keyboard Shortcuts

What keys close workbook?

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