Excel Basics (Windows) Exam – Wall Street Prep 2026 | Full Exam Solution

1|Page



Wall Street Prep Excel Basics (Windows)
Exam 2026




2026 2027 GRADED A+

, 2|Page


Section I — Navigation & Shortcuts (1–10)
1. What is the keyboard shortcut to copy a selection?
A. Ctrl + X
B. Ctrl + C
C. Ctrl + V
D. Ctrl + Z
Answer: B

2. To paste values only using the keyboard, you would press:
A. Ctrl + V
B. Alt + E, S, V
C. Ctrl + Alt + V
D. Shift + Ctrl + V
Answer: B

3. What is the shortcut to undo the last action?
A. Ctrl + Z
B. Ctrl + Y
C. Ctrl + U
D. Alt + Z
Answer: A

4. To select an entire column, you can press:
A. Ctrl + Space
B. Shift + Space
C. Ctrl + Shift + Space
D. Alt + Space
Answer: A

5. To select a row, the shortcut is:
A. Shift + Space
B. Ctrl + Space
C. Alt + Space
D. Ctrl + Alt + Space
Answer: A

6. The shortcut to open the Format Cells dialog is:
A. Ctrl + 1
B. Alt + 1
C. Ctrl + F
D. Shift + F1
Answer: A

7. To enter the current date in a cell, press:
A. Ctrl + ;


2026 2027 GRADED A+