FINANCIAL MODELING · OBJECTIVE ASSESSMENT A+ VERIFIED
EXCEL CRASH COURSE EXAM 2026/2027
LATEST VERSION FROM WALL STREET — Complete
Official Exam
60 Questions Full Rationales Verified Answers Latest Version
A+ 5 100%
QUESTIONS SECTIONS RATIONALES
Complete coverage Core exam domains Every answer explained
WHAT THIS COVERS
01 Excel Fundamentals & Formatting
02 Keyboard Shortcuts & Navigation
03 Formulas & Functions
04 Data Analysis & Lookup Functions
05 Charts, Printing & Model Building Best Practices
ABOUT THIS ASSESSMENT
Build mastery in Excel for finance — from fundamentals, formatting, and keyboard shortcuts to formulas, functions, data analysis, lookup
functions, charts, printing, and financial model-building best practices. This original study bank targets application and analysis skills for the
Wall Street Prep Excel Crash Course certification exam, with full rationales for every answer. For review use only; not an institutional proctored
assessment.
PASSING SCORE LEVEL FORMAT
80% Intermediate (Professional Certification) Application / Analysis
STUVIA ACTUAL EXAM Page 1
, SECTION 1: EXCEL FUNDAMENTALS & FORMATTING
Q1. A junior analyst at a bulge-bracket bank opens a new workbook and needs to apply a consistent number format to a column of
projected free cash flows that will later feed into a DCF. The values must display as currency with no decimal places and a thousands
separator. After selecting the range, which sequence correctly applies this format using the Format Cells dialog?
A. Press Ctrl+1, select Currency category, set Decimal places to 2, choose $ symbol, then click OK
B. Press Ctrl+1, select Number category, set Decimal places to 0, check Use 1000 Separator, then click OK
C. Right-click the range, choose Format Cells, select Accounting, set Decimal places to 0, then click OK
D. Press Ctrl+Shift+$, which automatically applies Currency with zero decimals and a thousands separator
Correct Answer: B
Rationale: Ctrl+1 opens the Format Cells dialog. Selecting the Number category (not Currency or Accounting) and setting Decimal places to 0 with
the 1000 Separator checked produces clean whole-dollar values with commas. Currency and Accounting formats force two decimals by default, and
Ctrl+Shift+$ applies a different preset.
Q2. While building a three-statement model, an associate notices that several input cells contain hard-coded growth rates that must be
visually distinguished from formulas. The modeling standard requires a blue font for all inputs. Which action correctly applies this convention
to a selected range without changing any other cell attributes?
A. Press Ctrl+1, go to the Font tab, set Color to blue, and leave all other settings unchanged
B. Open the Font Color dropdown on the Home ribbon and select a standard blue
C. Apply the 'Input' cell style from the Cell Styles gallery, which automatically sets blue font
D. Use the Format Painter after first formatting a single cell with blue font and bold
Correct Answer: A
Rationale: Ctrl+1 opens Format Cells; the Font tab allows changing only the color while preserving number format, alignment, and borders. The
ribbon Font Color works but is less precise when other attributes might already be set. Cell Styles and Format Painter risk overwriting additional
formatting that may already exist.
Q3. A financial model contains a large block of historical data that must be protected from accidental edits while still allowing users to
select and copy the cells. After selecting the range, the analyst opens Format Cells and clears the 'Locked' checkbox. What must still be
done for the protection to take effect?
A. Nothing further is required; unlocking the cells immediately protects the sheet
B. The workbook must be saved as a macro-enabled file (.xlsm) for protection to activate
C. The worksheet must be protected via Review > Protect Sheet (or Protect Workbook)
D. Data Validation must be applied to the same range to enforce the lock status
Correct Answer: C
Rationale: Cell-level Locked/Unlocked status only becomes active after the worksheet itself is protected. Unlocking cells first is the correct preparatory
step so that those cells remain editable once Protect Sheet is turned on. File type and Data Validation are unrelated to this protection mechanism.
Q4. An investment-banking analyst needs to freeze the top two rows and the leftmost column of a valuation summary so that headers and
row labels remain visible while scrolling. Which sequence achieves this freeze panes configuration?
A. Select cell A3, then go to View > Freeze Panes > Freeze Top Row, then freeze the first column separately
B. Select cell B2, then go to View > Freeze Panes > Freeze Panes
C. Select the entire row 3 and column B, then choose Freeze Panes from the context menu
D. Select cell B3, then go to View > Freeze Panes > Freeze Panes
Correct Answer: D
Rationale: Freeze Panes freezes everything above and to the left of the active cell. Selecting B3 therefore freezes rows 1-2 and column A. Selecting
B2 would freeze only the first row and column A; other combinations do not produce the required two-row-plus-one-column freeze.
STUVIA ACTUAL EXAM · Page 2
, SECTION 1: EXCEL FUNDAMENTALS & FORMATTING
Q5. A model contains a column of dates stored as text in the format 'MM/DD/YYYY'. The analyst needs to convert them into true Excel
date serial numbers so that they can be used in YEARFRAC and other date functions. Which method reliably performs the conversion for a
selected range?
A. Apply the DATEVALUE function in an adjacent column and then Paste Special > Values
B. Use Text to Columns with the Date format option set to MDY
C. Change the number format of the cells to Date via Format Cells
D. Multiply the entire range by 1 using Paste Special > Multiply
Correct Answer: B
Rationale: Text to Columns with the Date (MDY) option is the most robust way to convert text that looks like dates into real date serial numbers.
DATEVALUE also works but requires an extra column and handling of regional settings. Simply changing the number format does nothing if the
underlying value is still text. Multiplying by 1 fails for pure text dates.
Q6. While reviewing a peer's model, an analyst notices that several columns are set to a custom column width of 12.5 characters, but the
headers are truncated. The analyst wants to auto-fit all columns in the used range so that every header is fully visible. Which keyboard
sequence performs this action most efficiently?
A. Select the used range, then press Alt+H+O+I
B. Select the entire sheet with Ctrl+A, then double-click any column boundary
C. Press Ctrl+Shift+Right Arrow to select columns, then press Alt+O+C+A
D. Select any cell and press Ctrl+0 to auto-fit the active column only
Correct Answer: A
Rationale: Alt+H+O+I is the ribbon key sequence for Home > Format > AutoFit Column Width and works on any selected range. Double-clicking a
boundary only affects one column. Ctrl+0 hides columns rather than auto-fitting them. The older Alt+O sequence is less reliable in modern Excel.
Q7. A three-statement model uses a consistent light-gray fill for all calculation cells and no fill for input cells. An analyst wants to apply this
fill to a large contiguous block of formulas without affecting number formats or fonts. Which approach is both precise and efficient?
A. Select the range and click the Fill Color bucket on the Home ribbon
B. Create a custom cell style named 'Calc' that contains only the fill color, then apply the style
C. Select the range, open Format Cells (Ctrl+1), go to the Fill tab, choose the gray color, and click OK
D. Use Conditional Formatting with a formula that tests whether the cell contains a formula
Correct Answer: C
Rationale: Format Cells > Fill changes only the background color and leaves number formats, fonts, and borders untouched. The ribbon Fill Color
does the same but Format Cells is more explicit for documentation. A custom style is useful for reuse but is overkill for a one-time application.
Conditional Formatting is dynamic and unnecessary for static model convention.
STUVIA ACTUAL EXAM · Page 3
EXCEL CRASH COURSE EXAM 2026/2027
LATEST VERSION FROM WALL STREET — Complete
Official Exam
60 Questions Full Rationales Verified Answers Latest Version
A+ 5 100%
QUESTIONS SECTIONS RATIONALES
Complete coverage Core exam domains Every answer explained
WHAT THIS COVERS
01 Excel Fundamentals & Formatting
02 Keyboard Shortcuts & Navigation
03 Formulas & Functions
04 Data Analysis & Lookup Functions
05 Charts, Printing & Model Building Best Practices
ABOUT THIS ASSESSMENT
Build mastery in Excel for finance — from fundamentals, formatting, and keyboard shortcuts to formulas, functions, data analysis, lookup
functions, charts, printing, and financial model-building best practices. This original study bank targets application and analysis skills for the
Wall Street Prep Excel Crash Course certification exam, with full rationales for every answer. For review use only; not an institutional proctored
assessment.
PASSING SCORE LEVEL FORMAT
80% Intermediate (Professional Certification) Application / Analysis
STUVIA ACTUAL EXAM Page 1
, SECTION 1: EXCEL FUNDAMENTALS & FORMATTING
Q1. A junior analyst at a bulge-bracket bank opens a new workbook and needs to apply a consistent number format to a column of
projected free cash flows that will later feed into a DCF. The values must display as currency with no decimal places and a thousands
separator. After selecting the range, which sequence correctly applies this format using the Format Cells dialog?
A. Press Ctrl+1, select Currency category, set Decimal places to 2, choose $ symbol, then click OK
B. Press Ctrl+1, select Number category, set Decimal places to 0, check Use 1000 Separator, then click OK
C. Right-click the range, choose Format Cells, select Accounting, set Decimal places to 0, then click OK
D. Press Ctrl+Shift+$, which automatically applies Currency with zero decimals and a thousands separator
Correct Answer: B
Rationale: Ctrl+1 opens the Format Cells dialog. Selecting the Number category (not Currency or Accounting) and setting Decimal places to 0 with
the 1000 Separator checked produces clean whole-dollar values with commas. Currency and Accounting formats force two decimals by default, and
Ctrl+Shift+$ applies a different preset.
Q2. While building a three-statement model, an associate notices that several input cells contain hard-coded growth rates that must be
visually distinguished from formulas. The modeling standard requires a blue font for all inputs. Which action correctly applies this convention
to a selected range without changing any other cell attributes?
A. Press Ctrl+1, go to the Font tab, set Color to blue, and leave all other settings unchanged
B. Open the Font Color dropdown on the Home ribbon and select a standard blue
C. Apply the 'Input' cell style from the Cell Styles gallery, which automatically sets blue font
D. Use the Format Painter after first formatting a single cell with blue font and bold
Correct Answer: A
Rationale: Ctrl+1 opens Format Cells; the Font tab allows changing only the color while preserving number format, alignment, and borders. The
ribbon Font Color works but is less precise when other attributes might already be set. Cell Styles and Format Painter risk overwriting additional
formatting that may already exist.
Q3. A financial model contains a large block of historical data that must be protected from accidental edits while still allowing users to
select and copy the cells. After selecting the range, the analyst opens Format Cells and clears the 'Locked' checkbox. What must still be
done for the protection to take effect?
A. Nothing further is required; unlocking the cells immediately protects the sheet
B. The workbook must be saved as a macro-enabled file (.xlsm) for protection to activate
C. The worksheet must be protected via Review > Protect Sheet (or Protect Workbook)
D. Data Validation must be applied to the same range to enforce the lock status
Correct Answer: C
Rationale: Cell-level Locked/Unlocked status only becomes active after the worksheet itself is protected. Unlocking cells first is the correct preparatory
step so that those cells remain editable once Protect Sheet is turned on. File type and Data Validation are unrelated to this protection mechanism.
Q4. An investment-banking analyst needs to freeze the top two rows and the leftmost column of a valuation summary so that headers and
row labels remain visible while scrolling. Which sequence achieves this freeze panes configuration?
A. Select cell A3, then go to View > Freeze Panes > Freeze Top Row, then freeze the first column separately
B. Select cell B2, then go to View > Freeze Panes > Freeze Panes
C. Select the entire row 3 and column B, then choose Freeze Panes from the context menu
D. Select cell B3, then go to View > Freeze Panes > Freeze Panes
Correct Answer: D
Rationale: Freeze Panes freezes everything above and to the left of the active cell. Selecting B3 therefore freezes rows 1-2 and column A. Selecting
B2 would freeze only the first row and column A; other combinations do not produce the required two-row-plus-one-column freeze.
STUVIA ACTUAL EXAM · Page 2
, SECTION 1: EXCEL FUNDAMENTALS & FORMATTING
Q5. A model contains a column of dates stored as text in the format 'MM/DD/YYYY'. The analyst needs to convert them into true Excel
date serial numbers so that they can be used in YEARFRAC and other date functions. Which method reliably performs the conversion for a
selected range?
A. Apply the DATEVALUE function in an adjacent column and then Paste Special > Values
B. Use Text to Columns with the Date format option set to MDY
C. Change the number format of the cells to Date via Format Cells
D. Multiply the entire range by 1 using Paste Special > Multiply
Correct Answer: B
Rationale: Text to Columns with the Date (MDY) option is the most robust way to convert text that looks like dates into real date serial numbers.
DATEVALUE also works but requires an extra column and handling of regional settings. Simply changing the number format does nothing if the
underlying value is still text. Multiplying by 1 fails for pure text dates.
Q6. While reviewing a peer's model, an analyst notices that several columns are set to a custom column width of 12.5 characters, but the
headers are truncated. The analyst wants to auto-fit all columns in the used range so that every header is fully visible. Which keyboard
sequence performs this action most efficiently?
A. Select the used range, then press Alt+H+O+I
B. Select the entire sheet with Ctrl+A, then double-click any column boundary
C. Press Ctrl+Shift+Right Arrow to select columns, then press Alt+O+C+A
D. Select any cell and press Ctrl+0 to auto-fit the active column only
Correct Answer: A
Rationale: Alt+H+O+I is the ribbon key sequence for Home > Format > AutoFit Column Width and works on any selected range. Double-clicking a
boundary only affects one column. Ctrl+0 hides columns rather than auto-fitting them. The older Alt+O sequence is less reliable in modern Excel.
Q7. A three-statement model uses a consistent light-gray fill for all calculation cells and no fill for input cells. An analyst wants to apply this
fill to a large contiguous block of formulas without affecting number formats or fonts. Which approach is both precise and efficient?
A. Select the range and click the Fill Color bucket on the Home ribbon
B. Create a custom cell style named 'Calc' that contains only the fill color, then apply the style
C. Select the range, open Format Cells (Ctrl+1), go to the Fill tab, choose the gray color, and click OK
D. Use Conditional Formatting with a formula that tests whether the cell contains a formula
Correct Answer: C
Rationale: Format Cells > Fill changes only the background color and leaves number formats, fonts, and borders untouched. The ribbon Fill Color
does the same but Format Cells is more explicit for documentation. A custom style is useful for reuse but is overkill for a one-time application.
Conditional Formatting is dynamic and unnecessary for static model convention.
STUVIA ACTUAL EXAM · Page 3
