Excel - Ch. 14: Shortcuts list
Text-only quiz: Ch. 14: Shortcuts list
Want to study this quiz?
Copy it to your free Gradiuz library and make it your own.
Question 1
Which keyboard shortcut is used to open an existing worksheet?
- Ctrl + N
- Ctrl + O
- Ctrl + S
- F12
Question 2
To display the Save As dialog box, which key should be pressed?
- Ctrl + S
- Ctrl + P
- F12
- Ctrl + F
Question 3
Pressing Ctrl + A will select all of the cells in the current worksheet.
- True
- False
Question 4
To expand or collapse the formula bar, which keyboard shortcut should be used?
- Ctrl + Tab
- Ctrl + Shift + U
- Ctrl + F1
- Alt + Enter
Question 5
Which shortcut moves the active cell to the beginning of the worksheet?
- Home
- Ctrl + Home
- Ctrl + End
- F5
Question 6
Which keyboard shortcut can be used to open the Go To dialog box?
- Ctrl + F
- Ctrl + H
- F5
- Ctrl + K
Question 7
To begin a new line within the same cell, press _____
Fill in the blank
Question 8
The Ideas feature in Excel displays only pivot tables as suggestions for data visualization.
- True
- False
Question 9
To remove blanks from a worksheet, after highlighting the data and navigating to the Find and Select option from the Home menu, you should use the "________" button.
Fill in the blank
Question 10
Microsoft Excel is primarily a tool for word processing and document creation.
- True
- False
Question 11
To open the Save As dialog box in Excel, you should use the ________ key.
Fill in the blank
Question 12
Pressing Ctrl and I simultaneously will apply or remove bold formatting in Excel.
- True
- False
Question 13
The formula bar can be expanded or collapsed by pressing Ctrl + Shift + ______.
Fill in the blank
Question 14
Which shortcut allows you to go to the next worksheet?
- Ctrl and Tab
- Ctrl and Shift
- Alt and Tab
- Ctrl and Page Down
Question 15
Which shortcut allows you to go to the previous worksheet?
- Ctrl + Shift + Tab
- Ctrl + Tab
- Alt + Shift + Tab
- Ctrl + Page Up
Question 16
To move one cell to the right, which key should you use?
- tab key
- arrow key
- Enter key
- Shift key
Question 17
What key combination moves one cell to the left?
- Tab and Shift
- Ctrl and Tab
- Alt and Shift
- Ctrl and Left Arrow
Question 18
What is the shortcut for moving to the beginning of the worksheet?
- Ctrl + Home
- Home
- Ctrl + Up Arrow
- Alt + Home
Question 19
To move to the last cell in the worksheet that contains data, which keys should be pressed simultaneously?
- Ctrl key and the End key
- Ctrl key and the Home key
- Shift key and the End key
- Alt key and the End key
Question 20
Which key opens the Go To dialog box?
- F5
- F2
- F7
- F9
Made with Gradiuz
Turn any PDF into quizzes, flashcards and summaries - free.