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 Preparation Manual
2026/2027 Edition with Structured
Practice Questions and Model
Solutions
Question 1:

An Excel user needs to open an existing workbook from the file system quickly
without navigating menus. Which keyboard shortcut should be used?

A. Ctrl + N
B. Ctrl + O
C. Ctrl + S
D. Alt + F4

Correct Answer: B. Ctrl + O

Rationale: Ctrl + O is the standard shortcut used in Microsoft Excel and other Office
applications to open an existing file dialog. Ctrl + N creates a new workbook, while
Ctrl + S saves the current file. Alt + F4 closes the application, making them incorrect
for file opening tasks.


Question 2:

A nurse educator is teaching students how to modify Excel workbook calculation
settings. Which setting is recommended for most financial and clinical spreadsheet
models?

A. Manual calculation only
B. Automatic calculation except for data tables
C. Automatic calculation always disabled
D. Semi-automatic recalculation every hour

Correct Answer: B. Automatic calculation except for data tables

Rationale: The recommended setting ensures formulas update automatically,
improving accuracy and efficiency, while excluding data tables to avoid performance
issues. Manual or fully disabled calculation increases risk of outdated or incorrect
results.

,2026/2027


Question 3:

Which Excel shortcut is NOT used for inserting or adding sheets within a workbook?

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

Correct Answer: A. Alt + H + I + W

Rationale: Alt + H + I + W is not a valid Excel shortcut for inserting worksheets. Shift
+ F11 and Alt + Shift + F1 are commonly used to insert new worksheets. Ctrl + Shift
+ N is not standard for Excel sheet insertion, but Alt + H + I + W is specifically
incorrect in this context.


Question 4:

A student wants to insert a formula referencing a cell from another worksheet using
only the keyboard. What is the correct sequence?

A. Type formula → Ctrl + PageUp → Enter
B. Press F2 → navigate worksheets using Ctrl + PageUp/PageDown → select cell →
Enter
C. Press Ctrl + Tab → select cell → Esc
D. Press Alt + Enter → type sheet name manually

Correct Answer: B. Press F2 → navigate worksheets using Ctrl +
PageUp/PageDown → select cell → Enter

Rationale: F2 activates edit mode, and Ctrl + PageUp/PageDown allows navigation
between worksheets. This method ensures accurate cross-sheet referencing. The other
options either use incorrect navigation or do not properly activate formula editing
mode.


Question 5:

What is the correct shortcut to open the Format Cells dialog box in Excel?

A. Ctrl + 1
B. Ctrl + F
C. Alt + F1
D. Ctrl + Shift + F

Correct Answer: A. Ctrl + 1

,2026/2027

Rationale: Ctrl + 1 opens the Format Cells dialog box, allowing users to modify
number formatting, alignment, borders, and more. The other options either perform
unrelated functions or do not open formatting settings.


Question 6:

A student wants to autofit multiple columns using the keyboard. Which sequence is
correct?

A. Ctrl + A → Alt + H + O + I
B. Ctrl + Space → Alt + H + O + I
C. Shift + Space → Ctrl + O + I
D. Alt + Tab → Ctrl + F

Correct Answer: B. Ctrl + Space → Alt + H + O + I

Rationale: Ctrl + Space selects the column, and Alt + H + O + I triggers autofit
column width. This ensures the column adjusts to content size. The other options
involve incorrect selection methods or unrelated shortcuts.


Question 7:

Within the Format Cells dialog box, which key allows navigation between tabs such
as Number, Alignment, and Font?

A. Ctrl + Tab
B. Alt + Tab
C. Shift + Tab
D. F6

Correct Answer: A. Ctrl + Tab

Rationale: Ctrl + Tab moves between tabs in dialog boxes. Shift + Tab moves
backward across form fields, while Alt + Tab switches between applications. F6 is
used for pane navigation, not dialog tabs.


Question 8:

A nurse is preparing a workbook and wants all worksheets to display identical column
widths and a shared title. What is the correct first step?

A. Copy each worksheet individually
B. Group worksheets using Ctrl + Shift + PageUp/PageDown
C. Use Ctrl + Alt + Delete
D. Save each sheet separately

Correct Answer: B. Group worksheets using Ctrl + Shift + PageUp/PageDown

, 2026/2027

Rationale: Grouping worksheets ensures that formatting and entries apply across all
selected sheets simultaneously. The other options do not create linked sheet
formatting.


Question 9:

Which shortcut sequence is used to group selected columns in Excel?

A. Ctrl + Shift + G
B. Shift + Alt + Right Arrow
C. Alt + Ctrl + G
D. Shift + Ctrl + Right Arrow

Correct Answer: B. Shift + Alt + Right Arrow

Rationale: Shift + Alt + Right Arrow groups selected columns. This allows data
organization and collapsible structure creation. Other options are either invalid or
unrelated to grouping.


Question 10:

What is the correct shortcut to open the Paste Special dialog box?

A. Ctrl + Alt + V
B. Alt + E + S or Alt + H + V + S
C. Ctrl + Shift + V only
D. Alt + P + S

Correct Answer: B. Alt + E + S or Alt + H + V + S

Rationale: These sequences open Paste Special depending on Excel version. They
allow advanced paste options such as values, formulas, or formats. Other options are
incorrect or incomplete.


Question 11:

Which shortcut is NOT used for tracing precedent cells in Excel?

A. Ctrl + [
B. Alt + M + P
C. Ctrl + Shift + {
D. Ctrl + Alt + [

Correct Answer: D. Ctrl + Alt + [