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
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
