Wall Street Prep Excel Crash Course Retake Exam Comprehensive Study Guide and Practice Review 2026/2027 Edition for Financial Modeling Mastery

2026/2027



Wall Street Prep Excel Crash Course
Retake Exam Study Guide 2026/2027:
Comprehensive Practice Questions,
Test Bank Reviews, and Advanced
Excel Skills Preparation
Question 1

Which of the following keyboard shortcuts is NOT used to add a new worksheet in
Excel?

A. Alt + H + I + W
B. Ctrl + Shift + N
C. Shift + F11
D. Alt + Shift + F1

Correct Answer: B. Ctrl + Shift + N

Rationale: Excel provides multiple built-in shortcuts for inserting new worksheets,
such as Shift + F11 or Alt + Shift + F1 depending on the version. However, Ctrl +
Shift + N is not a recognized Excel shortcut for worksheet insertion. Understanding
valid shortcuts is essential for efficient workbook navigation and management.


Question 2

What is the correct keyboard shortcut to open an existing file in Excel?

A. Ctrl + P
B. Ctrl + O
C. Ctrl + N
D. Ctrl + S

Correct Answer: B. Ctrl + O

Rationale: Ctrl + O opens the file dialog box, allowing users to open existing Excel
workbooks. Ctrl + N creates a new workbook, Ctrl + S saves a file, and Ctrl + P opens
the print menu. Recognizing these shortcuts improves workflow efficiency.


Question 3

,2026/2027

What is the recommended Excel workbook calculation setting for most financial
models?

A. Manual calculation only
B. Automatic except for data tables
C. Automatic only for formulas
D. Manual except for charts

Correct Answer: B. Automatic except for data tables

Rationale: This setting ensures formulas update automatically while preventing
unnecessary recalculations of large data tables, improving performance in complex
models. Manual settings may lead to outdated results if not updated properly.


Question 4

Which steps correctly insert a worksheet reference into an existing formula using the
keyboard?

A. Press Enter, then select worksheet
B. Use Ctrl + PageUp/PageDown in formula edit mode
C. Use Alt + Tab only
D. Use Shift + arrow keys only

Correct Answer: B. Use Ctrl + PageUp/PageDown in formula edit mode

Rationale: Ctrl + PageUp/PageDown allows navigation between worksheets while
editing formulas, ensuring accurate cell referencing across sheets. Other options do
not allow direct worksheet switching within formula editing.


Question 5

What does the Excel shortcut Alt + H + O + I perform?

A. Identical column widths
B. Exact column width
C. Insert row
D. Delete column

Correct Answer: B. Exact column width

Rationale: This shortcut opens the column width dialog, allowing users to set a
precise width value for selected columns. It differs from auto-fit or uniform
formatting options.


Question 6

, 2026/2027

What does Alt + H + O + W do in Excel?

A. Adjust row height
B. Set identical column widths
C. Merge cells
D. Insert worksheet

Correct Answer: B. Set identical column widths

Rationale: This shortcut standardizes column widths across selected columns,
ensuring uniform formatting. It is useful for maintaining structured spreadsheet
layouts.


Question 7

What does Ctrl + Spacebar do in Excel?

A. Select entire row
B. Select entire column
C. Delete column
D. Insert row

Correct Answer: B. Select entire column

Rationale: Ctrl + Spacebar selects the entire column of the active cell, enabling
formatting or structural changes to that column efficiently.


Question 8

What does Shift + Spacebar select?

A. Entire column
B. Entire worksheet
C. Entire row
D. Active cell only

Correct Answer: C. Entire row

Rationale: Shift + Spacebar selects the entire row, allowing formatting or editing of
all cells within that row.


Question 9

What is the shortcut for bold formatting in Excel on Mac systems?

A. Command + B
B. Ctrl + B