Wall Street Prep Excel Crash Course Exam 2026 Verified
Version Actual Exam 2026/2027 | Complete Exam-Style
Questions with Detailed Rationales | 100% Verified | Pass
Guaranteed – A+ Graded
Core Navigation and Workbook Fundamentals
Q1: What is the default file extension for a macro-enabled workbook in modern Excel?
A. .xlsx
B. .xls
C. .xlsm [CORRECT]
D. .xltm
Correct Answer: C
Rationale: This choice is correct because .xlsm is the standard extension for Excel files that
contain VBA macros, distinguishing them from standard .xlsx files.
Q2: A financial analyst needs to keep the top row and first two columns visible while
scrolling through a massive dataset. Which tool should they use?
A. Split Window
B. Freeze Panes [CORRECT]
C. Group Columns
D. Hide Rows
Correct Answer: B
Rationale: The best answer is Freeze Panes, as it locks specific rows and columns in place so
they remain visible as you navigate the rest of the worksheet.
Q3: You want to quickly apply the exact same formatting from cell A1 to cells B1 through E1.
What is the most efficient tool for this?
A. Copy and Paste Special Values
B. Conditional Formatting
C. Format Painter [CORRECT]
D. Cell Styles
Correct Answer: C
Rationale: This aligns with using Format Painter, which copies only the visual formatting of a
selected cell and applies it to any other cells you click or drag across.
Q4: When grouping multiple worksheets to enter the same data across all of them
simultaneously, how do you know you are in "Group" mode?
A. The sheet tabs turn blue.
B. The word [Group] appears in the title bar next to the file name. [CORRECT]
C. A thick border appears around the active worksheet.
D. The ribbon turns gray.
Correct Answer: B
, Rationale: This matches the principle that Excel displays [Group] in the title bar to warn you
that any changes made will apply to all selected sheets.
Q5: Which view in Excel is best suited for adding headers, footers, and adjusting page
margins before printing a financial report?
A. Normal View
B. Page Layout View [CORRECT]
C. Page Break Preview
D. Full Screen View
Correct Answer: B
Rationale: The best answer is Page Layout View because it shows the document exactly as it
will appear on the printed page, including rulers, margins, and headers.
Q6: If you accidentally close a workbook without saving it, where is the most likely place to
recover an autosaved version?
A. The Recycle Bin
B. The Info tab under Manage Workbook [CORRECT]
C. The Options menu under Add-ins
D. The View tab under Window
Correct Answer: B
Rationale: This choice is correct because the Manage Workbook menu in the Info tab stores
unsaved or autorecovered versions of your current file.
Q7: A junior analyst is struggling to see the gridlines on their spreadsheet. Where can they
toggle the visibility of gridlines without changing cell borders?
A. Home tab > Font group
B. Page Layout tab > Sheet Options [CORRECT]
C. Insert tab > Illustrations
D. Data tab > Outline
Correct Answer: B
Rationale: This aligns with the Sheet Options group on the Page Layout tab, which contains a
simple checkbox to show or hide gridlines globally for that worksheet.
Q8: What happens when you press the F2 key while a cell is selected?
A. It deletes the cell contents.
B. It opens the Format Cells dialog box.
C. It places the cell in edit mode. [CORRECT]
D. It calculates all open workbooks.
Correct Answer: C
Rationale: This matches the principle that F2 is the universal shortcut to enter edit mode,
placing your cursor directly inside the selected cell's formula or text.
Q9: You notice a small green triangle in the top-left corner of several cells in your
depreciation schedule. What does this indicate?
A. The cell contains a formula error or inconsistency. [CORRECT]
B. The cell is linked to an external workbook.
C. The cell contains a comment or note.
Version Actual Exam 2026/2027 | Complete Exam-Style
Questions with Detailed Rationales | 100% Verified | Pass
Guaranteed – A+ Graded
Core Navigation and Workbook Fundamentals
Q1: What is the default file extension for a macro-enabled workbook in modern Excel?
A. .xlsx
B. .xls
C. .xlsm [CORRECT]
D. .xltm
Correct Answer: C
Rationale: This choice is correct because .xlsm is the standard extension for Excel files that
contain VBA macros, distinguishing them from standard .xlsx files.
Q2: A financial analyst needs to keep the top row and first two columns visible while
scrolling through a massive dataset. Which tool should they use?
A. Split Window
B. Freeze Panes [CORRECT]
C. Group Columns
D. Hide Rows
Correct Answer: B
Rationale: The best answer is Freeze Panes, as it locks specific rows and columns in place so
they remain visible as you navigate the rest of the worksheet.
Q3: You want to quickly apply the exact same formatting from cell A1 to cells B1 through E1.
What is the most efficient tool for this?
A. Copy and Paste Special Values
B. Conditional Formatting
C. Format Painter [CORRECT]
D. Cell Styles
Correct Answer: C
Rationale: This aligns with using Format Painter, which copies only the visual formatting of a
selected cell and applies it to any other cells you click or drag across.
Q4: When grouping multiple worksheets to enter the same data across all of them
simultaneously, how do you know you are in "Group" mode?
A. The sheet tabs turn blue.
B. The word [Group] appears in the title bar next to the file name. [CORRECT]
C. A thick border appears around the active worksheet.
D. The ribbon turns gray.
Correct Answer: B
, Rationale: This matches the principle that Excel displays [Group] in the title bar to warn you
that any changes made will apply to all selected sheets.
Q5: Which view in Excel is best suited for adding headers, footers, and adjusting page
margins before printing a financial report?
A. Normal View
B. Page Layout View [CORRECT]
C. Page Break Preview
D. Full Screen View
Correct Answer: B
Rationale: The best answer is Page Layout View because it shows the document exactly as it
will appear on the printed page, including rulers, margins, and headers.
Q6: If you accidentally close a workbook without saving it, where is the most likely place to
recover an autosaved version?
A. The Recycle Bin
B. The Info tab under Manage Workbook [CORRECT]
C. The Options menu under Add-ins
D. The View tab under Window
Correct Answer: B
Rationale: This choice is correct because the Manage Workbook menu in the Info tab stores
unsaved or autorecovered versions of your current file.
Q7: A junior analyst is struggling to see the gridlines on their spreadsheet. Where can they
toggle the visibility of gridlines without changing cell borders?
A. Home tab > Font group
B. Page Layout tab > Sheet Options [CORRECT]
C. Insert tab > Illustrations
D. Data tab > Outline
Correct Answer: B
Rationale: This aligns with the Sheet Options group on the Page Layout tab, which contains a
simple checkbox to show or hide gridlines globally for that worksheet.
Q8: What happens when you press the F2 key while a cell is selected?
A. It deletes the cell contents.
B. It opens the Format Cells dialog box.
C. It places the cell in edit mode. [CORRECT]
D. It calculates all open workbooks.
Correct Answer: C
Rationale: This matches the principle that F2 is the universal shortcut to enter edit mode,
placing your cursor directly inside the selected cell's formula or text.
Q9: You notice a small green triangle in the top-left corner of several cells in your
depreciation schedule. What does this indicate?
A. The cell contains a formula error or inconsistency. [CORRECT]
B. The cell is linked to an external workbook.
C. The cell contains a comment or note.
