WALL STREET PREPARATION
EXCEL CRASH COURSE EXAM
2026/2027
Official Practice Exam . 2026/2027 Edition
Questions Minutes Passing Score Recertification
50 90 80% Annual
EXCEL CRASH COURSE EXAM 2026/2027 LATEST VERSION
FROM WALL STREET QUESTIONS AND 100% CORRECT ANSWERS (BRAND NEW!!)
WSP EXCEL CRASH COURSE **2026/2027**
TABLE OF CONTENTS
Section 1: Excel Fundamentals & Navigation ... Questions 1-10
Section 2: Formulas & Functions ... Questions 11-22
Section 3: Data Management & Analysis ... Questions 23-32 Section 4: Financial Modeling & Advanced Functions ... Questions 33-42
Section 5: Charts, Visualization & Reporting ... Questions 43-50
Instructions
This practice exam contains 50 multiple-choice questions divided into 5 sections. You have 90 minutes to complete the
entire exam. Each question has exactly four answer choices, and you must select the one best answer. There is no
penalty for guessing, so you should answer every question. A score of 80% or higher (at least 40 correct answers out of
50) is required to pass. Read each scenario carefully before selecting your answer. The correct answer and a detailed
rationale are provided immediately after each question for your review and study.
Section Overview
Section 1: Excel Fundamentals & Navigation -- 10 Questions (1-10)
Section 2: Formulas & Functions -- 12 Questions (11-22)
Section 3: Data Management & Analysis -- 10 Questions (23-32)
Section 4: Financial Modeling & Advanced Functions -- 10 Questions (33-42)
Section 5: Charts, Visualization & Reporting -- 8 Questions (43-50)
Good luck on your exam!
2026/2027 Edition -- All rights reserved.
EXCEL CRASH COURSE EXAM 2026/2027 -- 2026/2027 | Passing Score: 80% | Page 1
, Section 1: Excel Fundamentals & Navigation | Questions 1-10 | 2026/2027
Q1 Question 1 of 50
A junior analyst at a private equity firm opens a large workbook and struggles to move quickly
between distant sheets. She wants a method that jumps directly to the last worksheet tab without
scrolling through the tab bar one by one.
A. Press Ctrl+Page Down repeatedly until the last tab is reached
B. Right-click the sheet navigation arrows and select the last sheet from the pop-up list
C. Hold Ctrl+Shift and press the Right Arrow key to jump to the final tab
D. Use the Go To dialog (Ctrl+G) and type the sheet name to navigate
Correct Answer: B
Rationale:
Right-clicking the small sheet navigation arrows at the bottom-left opens a pop-up list of all sheets, allowing
instant jumps to any sheet. Option A is inefficient for many sheets. Ctrl+Shift+Right Arrow selects cells, not
sheets. Ctrl+Go To requires knowing the exact sheet name and does not list sheets.
Q2 Question 2 of 50
A consultant receives a 200,000-row dataset and needs to freeze the top header row and the first two
columns so that row 1 and columns A-B remain visible while scrolling through the rest of the data.
A. Select cell C2, then click View > Freeze Panes > Freeze Panes
B. Select cell A1, then click View > Freeze Panes > Freeze Top Row, and repeat for columns
C. Select the entire first row and first two columns, then choose Freeze Panes
D. Click View > Freeze Panes > Freeze Panes with any cell selected before the desired split point
Correct Answer: A
Rationale:
Freeze Panes freezes rows above and columns to the left of the active cell. Selecting C2 freezes rows 1 and
columns A-B. Option B only freezes the top row and cannot simultaneously freeze columns. Option C is not
how Freeze Panes works. Option D is vague and does not specify the correct cell.
EXCEL CRASH COURSE EXAM 2026/2027 -- 2026/2027 | Passing Score: 80% | Page 1
, Q3 Question 3 of 50
An investment banking intern is formatting a financial model and wants to apply the Accounting
Number Format to several cells so that currency symbols align and zero values display as dashes.
A. Apply the Currency format from the Number group on the Home tab
B. Use the Format Cells dialog and choose the Custom category to build the format manually
C. Select the cells and press Ctrl+Shift+$ to apply Accounting Number Format
D. Select the cells and press Ctrl+Shift+! to apply the Number format with two decimals
Correct Answer: C
Rationale:
Ctrl+Shift+$ applies Accounting Number Format, which aligns currency symbols and shows zeros as dashes.
Currency format (Option A) does not align symbols or display zeros as dashes. Custom formatting (Option B)
is unnecessarily complex. Ctrl+Shift+! (Option D) applies a plain Number format without currency.
Q4 Question 4 of 50
A financial analyst is building a three-statement model and wants to switch between normal view,
page break preview, and page layout view to check how the model will print. She needs the fastest
method to toggle among these views.
A. Use the View tab on the Ribbon and click the desired view button each time
B. Press Ctrl+F2 to cycle through the three workbook views automatically
C. Use the keyboard shortcut Alt+W+L for page layout and Alt+W+G for page break preview
D. Click the three small view icons in the bottom-right corner of the Excel status bar
Correct Answer: D
Rationale:
The three view icons on the status bar provide one-click switching among Normal, Page Break Preview, and
Page Layout views. Option A works but requires more clicks. Ctrl+F2 opens Print Preview, not a view toggle.
Option D shortcuts exist for some views but are slower than the status bar icons.
EXCEL CRASH COURSE EXAM 2026/2027 -- 2026/2027 | Passing Score: 80% | Page 2
EXCEL CRASH COURSE EXAM
2026/2027
Official Practice Exam . 2026/2027 Edition
Questions Minutes Passing Score Recertification
50 90 80% Annual
EXCEL CRASH COURSE EXAM 2026/2027 LATEST VERSION
FROM WALL STREET QUESTIONS AND 100% CORRECT ANSWERS (BRAND NEW!!)
WSP EXCEL CRASH COURSE **2026/2027**
TABLE OF CONTENTS
Section 1: Excel Fundamentals & Navigation ... Questions 1-10
Section 2: Formulas & Functions ... Questions 11-22
Section 3: Data Management & Analysis ... Questions 23-32 Section 4: Financial Modeling & Advanced Functions ... Questions 33-42
Section 5: Charts, Visualization & Reporting ... Questions 43-50
Instructions
This practice exam contains 50 multiple-choice questions divided into 5 sections. You have 90 minutes to complete the
entire exam. Each question has exactly four answer choices, and you must select the one best answer. There is no
penalty for guessing, so you should answer every question. A score of 80% or higher (at least 40 correct answers out of
50) is required to pass. Read each scenario carefully before selecting your answer. The correct answer and a detailed
rationale are provided immediately after each question for your review and study.
Section Overview
Section 1: Excel Fundamentals & Navigation -- 10 Questions (1-10)
Section 2: Formulas & Functions -- 12 Questions (11-22)
Section 3: Data Management & Analysis -- 10 Questions (23-32)
Section 4: Financial Modeling & Advanced Functions -- 10 Questions (33-42)
Section 5: Charts, Visualization & Reporting -- 8 Questions (43-50)
Good luck on your exam!
2026/2027 Edition -- All rights reserved.
EXCEL CRASH COURSE EXAM 2026/2027 -- 2026/2027 | Passing Score: 80% | Page 1
, Section 1: Excel Fundamentals & Navigation | Questions 1-10 | 2026/2027
Q1 Question 1 of 50
A junior analyst at a private equity firm opens a large workbook and struggles to move quickly
between distant sheets. She wants a method that jumps directly to the last worksheet tab without
scrolling through the tab bar one by one.
A. Press Ctrl+Page Down repeatedly until the last tab is reached
B. Right-click the sheet navigation arrows and select the last sheet from the pop-up list
C. Hold Ctrl+Shift and press the Right Arrow key to jump to the final tab
D. Use the Go To dialog (Ctrl+G) and type the sheet name to navigate
Correct Answer: B
Rationale:
Right-clicking the small sheet navigation arrows at the bottom-left opens a pop-up list of all sheets, allowing
instant jumps to any sheet. Option A is inefficient for many sheets. Ctrl+Shift+Right Arrow selects cells, not
sheets. Ctrl+Go To requires knowing the exact sheet name and does not list sheets.
Q2 Question 2 of 50
A consultant receives a 200,000-row dataset and needs to freeze the top header row and the first two
columns so that row 1 and columns A-B remain visible while scrolling through the rest of the data.
A. Select cell C2, then click View > Freeze Panes > Freeze Panes
B. Select cell A1, then click View > Freeze Panes > Freeze Top Row, and repeat for columns
C. Select the entire first row and first two columns, then choose Freeze Panes
D. Click View > Freeze Panes > Freeze Panes with any cell selected before the desired split point
Correct Answer: A
Rationale:
Freeze Panes freezes rows above and columns to the left of the active cell. Selecting C2 freezes rows 1 and
columns A-B. Option B only freezes the top row and cannot simultaneously freeze columns. Option C is not
how Freeze Panes works. Option D is vague and does not specify the correct cell.
EXCEL CRASH COURSE EXAM 2026/2027 -- 2026/2027 | Passing Score: 80% | Page 1
, Q3 Question 3 of 50
An investment banking intern is formatting a financial model and wants to apply the Accounting
Number Format to several cells so that currency symbols align and zero values display as dashes.
A. Apply the Currency format from the Number group on the Home tab
B. Use the Format Cells dialog and choose the Custom category to build the format manually
C. Select the cells and press Ctrl+Shift+$ to apply Accounting Number Format
D. Select the cells and press Ctrl+Shift+! to apply the Number format with two decimals
Correct Answer: C
Rationale:
Ctrl+Shift+$ applies Accounting Number Format, which aligns currency symbols and shows zeros as dashes.
Currency format (Option A) does not align symbols or display zeros as dashes. Custom formatting (Option B)
is unnecessarily complex. Ctrl+Shift+! (Option D) applies a plain Number format without currency.
Q4 Question 4 of 50
A financial analyst is building a three-statement model and wants to switch between normal view,
page break preview, and page layout view to check how the model will print. She needs the fastest
method to toggle among these views.
A. Use the View tab on the Ribbon and click the desired view button each time
B. Press Ctrl+F2 to cycle through the three workbook views automatically
C. Use the keyboard shortcut Alt+W+L for page layout and Alt+W+G for page break preview
D. Click the three small view icons in the bottom-right corner of the Excel status bar
Correct Answer: D
Rationale:
The three view icons on the status bar provide one-click switching among Normal, Page Break Preview, and
Page Layout views. Option A works but requires more clicks. Ctrl+F2 opens Print Preview, not a view toggle.
Option D shortcuts exist for some views but are slower than the status bar icons.
EXCEL CRASH COURSE EXAM 2026/2027 -- 2026/2027 | Passing Score: 80% | Page 2
