Wall Street Prep Excel Crash Course Exam Actual Exam 2026/2027 – 100% Verified | Detailed Rationales – Pass Guaranteed – A+ Graded

Wall Street Prep Excel Crash Course Exam
Actual Exam 2026/2027 – 100% Verified |
Detailed Rationales – Pass Guaranteed –
Graded A+| INSTANT DOWNLOAD



Section 1: Keyboard Shortcuts & Navigation (Questions 1-10)
Q1. What is the keyboard shortcut to open the "Format Cells" dialog box?

 A) Ctrl + F
 B) Ctrl + 1
 C) Alt + Enter
 D) Ctrl + Shift + F

Answer: B) Ctrl + 1
Rationale: Ctrl + 1 is the universal shortcut to open the Format Cells dialog box. Ctrl + F
opens the Find dialog, Alt + Enter inserts a line break within a cell, and Ctrl + Shift + F
opens the Font tab of the Format Cells dialog (but not the full dialog).




Q2. Which shortcut allows you to move to the next worksheet in a workbook?

 A) Ctrl + Tab
 B) Ctrl + PageDown
 C) Alt + Tab
 D) Shift + F11

Answer: B) Ctrl + PageDown
Rationale: Ctrl + PageDown moves to the next worksheet to the right. Ctrl + PageUp
moves to the previous worksheet. Ctrl + Tab switches between open workbooks. Shift +
F11 inserts a new worksheet.

, Q3. To paste only the values from a copied cell (without formatting or formulas),
which sequence of shortcuts is most efficient?

 A) Ctrl + V, then Ctrl + Z
 B) Alt + E + S + V, then Enter
 C) Ctrl + C, then Ctrl + V
 D) Ctrl + Alt + V

Answer: B) Alt + E + S + V, then Enter
Rationale: This is the legacy shortcut sequence that opens the Paste Special dialog and
selects "Values." The modern ribbon equivalent is Alt + H + V + V, but Alt + E + S + V
remains a widely used and efficient method among finance professionals.




Q4. What is the shortcut to auto-fit the width of a selected column?

 A) Alt + H + O + I
 B) Ctrl + Shift + +
 C) Alt + Enter
 D) Ctrl + W

Answer: A) Alt + H + O + I
Rationale: This ribbon shortcut auto-fits the column width based on the longest entry.
Ctrl + Shift + + inserts cells, Alt + Enter inserts a line break, and Ctrl + W closes the
current workbook.




Q5. How do you select an entire column using the keyboard?

 A) Ctrl + A
 B) Ctrl + Spacebar
 C) Shift + Spacebar
 D) Ctrl + Shift + Spacebar

, Answer: B) Ctrl + Spacebar
Rationale: Ctrl + Spacebar selects the entire column of the active cell. Shift + Spacebar
selects the entire row. Ctrl + A selects the entire worksheet (or current region), and Ctrl
+ Shift + Spacebar also selects the entire worksheet.




Q6. Which shortcut opens the "Go To" dialog box?

 A) Ctrl + G
 B) Ctrl + F
 C) F5
 D) Both A and C

Answer: D) Both A and C
Rationale: Both Ctrl + G and F5 open the "Go To" dialog, which allows you to navigate to
a specific cell or named range.




Q7. To edit the active cell directly, which key do you press?

 A) Enter
 B) F2
 C) F4
 D) Spacebar

Answer: B) F2
Rationale: F2 places the cursor at the end of the cell's content, allowing you to edit it
directly. Enter confirms the entry, F4 repeats the last action or toggles absolute/relative
references, and Spacebar enters a space.




Q8. What is the shortcut to insert a new worksheet?

 A) Ctrl + N
 B) Shift + F11

,  C) Ctrl + Shift + N
 D) Alt + I + W

Answer: B) Shift + F11
Rationale: Shift + F11 inserts a new worksheet. Ctrl + N creates a new workbook. Alt + I
+ W is a legacy menu shortcut but is less efficient.




Q9. How do you switch between open Excel workbooks?

 A) Ctrl + Tab
 B) Alt + Tab
 C) Ctrl + F6
 D) Both A and C

Answer: D) Both A and C
Rationale: Both Ctrl + Tab and Ctrl + F6 cycle through open workbooks. Alt + Tab
switches between all open applications, not just Excel.




Q10. Which shortcut opens the "Find and Replace" dialog box with the "Find" tab
active?

 A) Ctrl + F
 B) Ctrl + H
 C) F5
 D) Ctrl + Shift + F

Answer: A) Ctrl + F
Rationale: Ctrl + F opens the Find tab of the Find and Replace dialog. Ctrl + H opens the
Replace tab. F5 opens Go To. Ctrl + Shift + F opens the Font tab of Format Cells.




Section 2: Cell Referencing & Formulas (Questions 11-20)