Excel Crash Course Exam – Wall Street Prep (125+ Q&A with Rationales)

1|Page


EXCEL CRASH COURSE EXAM – WALL STREET
PREP | COMPLETE QUESTIONS AND A+
ANSWERS


# Section 1: Keyboard Shortcuts & Navigation (1–25)


**1.** What is the keyboard shortcut to open a file?
A) Ctrl + N
B) Ctrl + O
C) Ctrl + F12
D) Ctrl + Shift + O


**Answer:** B
**Rationale:** Ctrl + O is the universal shortcut for the "Open File"
dialog box in Excel. Ctrl + N opens a new workbook; Ctrl + F12 also
opens a file but less common.


---


**2.** All of the following are keyboard shortcuts that allow the user to
add more sheets to a workbook EXCEPT:
A) Shift + F11
B) Alt + H + I + S

,2|Page


C) Alt + H + I + W
D) Alt + Shift + F1


**Answer:** C
**Rationale:** Alt + H + I + W inserts a worksheet? Actually, Alt + H +
I + W inserts a **new worksheet**? Let's verify: Alt + H (Home tab), I
(Insert), S (Sheet) or W? Standard insert sheet is Alt + H + I + S. Alt + H
+ I + W inserts a **worksheet** as well? The question specifies
EXCEPT. According to WSP materials, Alt + H + I + W is NOT a valid
shortcut. The correct insert sheet shortcuts are Shift + F11, Alt + Shift +
F1, and Alt + H + I + S.


---


**3.** What is the keyboard shortcut to switch between worksheets?
A) Ctrl + Tab
B) Ctrl + Page Up / Ctrl + Page Down
C) Alt + Tab
D) Ctrl + F6


**Answer:** B
**Rationale:** Ctrl + Page Up moves to the previous worksheet; Ctrl +
Page Down moves to the next worksheet. Ctrl + Tab switches between
open workbooks, not worksheets.

,3|Page




---


**4.** What is the keyboard shortcut to open the Format Cells dialog
box?
A) Ctrl + F
B) Ctrl + 1
C) Alt + F1
D) Ctrl + Shift + F


**Answer:** B
**Rationale:** Ctrl + 1 is the shortcut for Format Cells. This dialog box
contains Number, Alignment, Font, Border, Fill, and Protection tabs .


---


**5.** What is the keyboard shortcut for auto-fitting a column?
A) Alt + H + O + I
B) Alt + O + C + A
C) Ctrl + Shift + F
D) Alt + H + O + W


**Answer:** A

, 4|Page


**Rationale:** After selecting a column (Ctrl + Spacebar), Alt + H + O
+ I auto-fits the column width based on the longest cell content. Alt + H
+ O + W allows manual width designation.


---


**6.** What is the keyboard sequence to **group** highlighted
columns (but not hide the group)?
A) Alt + Shift + Left Arrow
B) Alt + Shift + Right Arrow
C) Ctrl + Shift + Right Arrow
D) Alt + A + H


**Answer:** B
**Rationale:** Alt + Shift + Right Arrow groups selected columns or
rows. Alt + A + H hides the group, and Alt + A + J shows the group .


---


**7.** What is the keyboard sequence to **hide** a grouped section
(showing a + sign above the column)?
A) Alt + A + J
B) Alt + A + H