Wall Street Prep Excel Basics (Windows)
Exam – Comprehensive Study Guide and
Practice Questions
Excel Interface and Navigation (Q1-Q4)
Q1: You are working in a large financial model with multiple worksheets. You need to quickly
navigate from the current worksheet to the next worksheet to the right. Which action should
you take?
A. Press Ctrl + Page Down
B. Press Alt + Right Arrow
C. Press Ctrl + Tab
D. Press Shift + Page Down
Correct Answer: A
Rationale: Ctrl + Page Down moves to the next worksheet to the right in the workbook, while
Ctrl + Page Up moves to the previous worksheet to the left. This is essential for efficient
navigation in multi-sheet financial models where you need to move between assumptions,
income statement, balance sheet, and cash flow worksheets.
Q2: While reviewing a colleague's Excel model, you notice that when you scroll down through
a large dataset, the header row scrolls out of view, making it difficult to identify columns.
Which feature should you use to keep the header row visible at all times?
A. Split Window from the View tab
B. New Window from the View tab
C. Freeze Panes from the View tab
D. Hide Rows from the Home tab
Correct Answer: C
Rationale: Freeze Panes locks specific rows or columns in place so they remain visible while
scrolling through the rest of the worksheet. To freeze the top row, select View → Freeze Panes
→ Freeze Top Row. In financial models, this is crucial for keeping column headers visible when
working with multi-year projections or large datasets.
,Q3: You need to select all cells in the current worksheet that contain data, including blank
cells interspersed within the data range. What is the most efficient method to select the
entire used range?
A. Press Ctrl + A once
B. Press Ctrl + Shift + End
C. Click the corner between row 1 and column A
D. Press Ctrl + Shift + * (asterisk)
Correct Answer: A
Rationale: Pressing Ctrl + A once selects the current region (contiguous data range). If pressed
again, it selects the entire worksheet. Ctrl + Shift + End selects from the active cell to the last
used cell, but this may miss data above or to the left of the active cell.
Q4: You have a worksheet with data spanning thousands of rows. You need to quickly jump to
cell A1 from anywhere in the worksheet. Which keyboard shortcut accomplishes this?
A. Press Home
B. Press Ctrl + Home
C. Press Alt + Home
D. Press Shift + Home
Correct Answer: B
Rationale: Ctrl + Home always navigates to cell A1 regardless of your current position in the
worksheet. The Home key alone moves to the beginning of the current row (column A), while
Ctrl + End jumps to the last used cell. This shortcut is essential for quick navigation in large
financial models.
Keyboard Shortcuts (Q5-Q9)
Q5: SHORTCUT QUESTION
You are building a financial model and need to apply the same formula to all cells in a column
below the active cell. What shortcut fills the formula down through the selected range?
Shortcut: Ctrl + D [CORRECT]
A. Ctrl + R
, B. Ctrl + F
C. Ctrl + V
D. Alt + =
Rationale: Ctrl + D (Fill Down) copies the contents and formatting of the topmost cell in a
selected range down through all selected cells below. Ctrl + R fills right instead. In financial
modeling, this is faster than using the fill handle when you have already selected the target
range.
Q6: SHORTCUT QUESTION
You have just completed formatting a cell with bold text, blue font color, and a bottom border.
You want to apply the exact same formatting to three other non-adjacent cells. What is the
most efficient keyboard shortcut approach?
Shortcut: Double-click Format Painter (or Ctrl + Shift + C, then Ctrl + Shift + V) [CORRECT]
A. Ctrl + B on each cell individually
B. Ctrl + 1 and manually reapply each format
C. F4 on each cell after selecting it
D. Ctrl + Shift + F on each cell
Rationale: Double-clicking the Format Painter button allows you to apply the same formatting
to multiple non-adjacent cells by clicking each one sequentially. Press Esc to deactivate when
done. Alternatively, in newer Excel versions, Ctrl + Shift + C copies formatting and Ctrl + Shift + V
pastes formatting.
Q7: SHORTCUT QUESTION
While working in a formula, you realize you need to change a cell reference from relative (A1)
to absolute ($A$1). What keyboard shortcut toggles through the reference types while editing
the formula?
Shortcut: F4 [CORRECT]
A. F2
B. Ctrl + Shift + $
C. Alt + R
D. Ctrl + F4
Rationale: Pressing F4 while the cursor is on or adjacent to a cell reference in edit mode cycles
through the four reference types: A1 → $A$1 → A1 →A1 → back to A1. This is essential in
Exam – Comprehensive Study Guide and
Practice Questions
Excel Interface and Navigation (Q1-Q4)
Q1: You are working in a large financial model with multiple worksheets. You need to quickly
navigate from the current worksheet to the next worksheet to the right. Which action should
you take?
A. Press Ctrl + Page Down
B. Press Alt + Right Arrow
C. Press Ctrl + Tab
D. Press Shift + Page Down
Correct Answer: A
Rationale: Ctrl + Page Down moves to the next worksheet to the right in the workbook, while
Ctrl + Page Up moves to the previous worksheet to the left. This is essential for efficient
navigation in multi-sheet financial models where you need to move between assumptions,
income statement, balance sheet, and cash flow worksheets.
Q2: While reviewing a colleague's Excel model, you notice that when you scroll down through
a large dataset, the header row scrolls out of view, making it difficult to identify columns.
Which feature should you use to keep the header row visible at all times?
A. Split Window from the View tab
B. New Window from the View tab
C. Freeze Panes from the View tab
D. Hide Rows from the Home tab
Correct Answer: C
Rationale: Freeze Panes locks specific rows or columns in place so they remain visible while
scrolling through the rest of the worksheet. To freeze the top row, select View → Freeze Panes
→ Freeze Top Row. In financial models, this is crucial for keeping column headers visible when
working with multi-year projections or large datasets.
,Q3: You need to select all cells in the current worksheet that contain data, including blank
cells interspersed within the data range. What is the most efficient method to select the
entire used range?
A. Press Ctrl + A once
B. Press Ctrl + Shift + End
C. Click the corner between row 1 and column A
D. Press Ctrl + Shift + * (asterisk)
Correct Answer: A
Rationale: Pressing Ctrl + A once selects the current region (contiguous data range). If pressed
again, it selects the entire worksheet. Ctrl + Shift + End selects from the active cell to the last
used cell, but this may miss data above or to the left of the active cell.
Q4: You have a worksheet with data spanning thousands of rows. You need to quickly jump to
cell A1 from anywhere in the worksheet. Which keyboard shortcut accomplishes this?
A. Press Home
B. Press Ctrl + Home
C. Press Alt + Home
D. Press Shift + Home
Correct Answer: B
Rationale: Ctrl + Home always navigates to cell A1 regardless of your current position in the
worksheet. The Home key alone moves to the beginning of the current row (column A), while
Ctrl + End jumps to the last used cell. This shortcut is essential for quick navigation in large
financial models.
Keyboard Shortcuts (Q5-Q9)
Q5: SHORTCUT QUESTION
You are building a financial model and need to apply the same formula to all cells in a column
below the active cell. What shortcut fills the formula down through the selected range?
Shortcut: Ctrl + D [CORRECT]
A. Ctrl + R
, B. Ctrl + F
C. Ctrl + V
D. Alt + =
Rationale: Ctrl + D (Fill Down) copies the contents and formatting of the topmost cell in a
selected range down through all selected cells below. Ctrl + R fills right instead. In financial
modeling, this is faster than using the fill handle when you have already selected the target
range.
Q6: SHORTCUT QUESTION
You have just completed formatting a cell with bold text, blue font color, and a bottom border.
You want to apply the exact same formatting to three other non-adjacent cells. What is the
most efficient keyboard shortcut approach?
Shortcut: Double-click Format Painter (or Ctrl + Shift + C, then Ctrl + Shift + V) [CORRECT]
A. Ctrl + B on each cell individually
B. Ctrl + 1 and manually reapply each format
C. F4 on each cell after selecting it
D. Ctrl + Shift + F on each cell
Rationale: Double-clicking the Format Painter button allows you to apply the same formatting
to multiple non-adjacent cells by clicking each one sequentially. Press Esc to deactivate when
done. Alternatively, in newer Excel versions, Ctrl + Shift + C copies formatting and Ctrl + Shift + V
pastes formatting.
Q7: SHORTCUT QUESTION
While working in a formula, you realize you need to change a cell reference from relative (A1)
to absolute ($A$1). What keyboard shortcut toggles through the reference types while editing
the formula?
Shortcut: F4 [CORRECT]
A. F2
B. Ctrl + Shift + $
C. Alt + R
D. Ctrl + F4
Rationale: Pressing F4 while the cursor is on or adjacent to a cell reference in edit mode cycles
through the four reference types: A1 → $A$1 → A1 →A1 → back to A1. This is essential in
