Excel Crash Course Exam 2025/2026 | Latest
Version from Wall Street Prep (WSP) |
Questions and 100% Correct Answers | Brand
New!! | A+ Graded
Section 1: Introduction
This document contains the latest and verified version of the Excel Crash Course Exam from
Wall Street Prep (WSP), updated for the 2025/2026 academic cycle. It includes 100% correct
answers to key topics such as financial modeling functions, shortcuts, data analysis,
formatting, IF/VLOOKUP/XLOOKUP logic, pivot tables, sensitivity tables, and keyboard-
based navigation. Perfect for finance, investment banking, and business students or
professionals, this brand-new A+ graded exam guide prepares users to master Excel
efficiently and pass with distinction.
Section 2: Exam Questions and Answers
Format: Multiple-choice and formula-based questions
Typically four answer choices per question (A–D)
Correct answer highlighted in green
Coverage includes keyboard skills, Excel logic, cell referencing, financial formulas, and
time-saving tools
1. Which keyboard shortcut selects the entire column in Excel?
A) Ctrl + Space
B) Alt + Space
C) Shift + Space
D) Ctrl + Shift + Arrow Down
A) Ctrl + Space
(Rationale: Ctrl + Space selects the entire column instantly.)
2. What function returns the current date in Excel?
A) TODAY()
B) NOW()
C) DATE()
D) CURRENT()
A) TODAY()
(Rationale: TODAY() updates to the current date.)
3. Which formula checks if a cell value is greater than 100 and returns "Yes" or
"No"?
A) =IF(A1>100, "Yes", "No")
B) =IF(A1>100, Yes, No)
C) =CHECK(A1>100, "Yes", "No")
D) =IF(A1>100)
A) =IF(A1>100, "Yes", "No")
(Rationale: IF function evaluates conditions and returns text.)
4. What is the purpose of the VLOOKUP function?
A) Sums a range of cells
, B) Looks up a value in a vertical table
C) Creates a pivot table
D) Formats cells
B) Looks up a value in a vertical table
(Rationale: VLOOKUP searches for data in the first column.)
5. Which shortcut copies the value from the cell above?
A) Ctrl + D
B) Ctrl + C
C) Alt + E + S
D) Ctrl + V
A) Ctrl + D
(Rationale: Ctrl + D duplicates the cell above.)
6. What does a sensitivity table in Excel do?
A) Formats data automatically
B) Analyzes how input changes affect outputs
C) Sorts data alphabetically
D) Creates charts
B) Analyzes how input changes affect outputs
(Rationale: Sensitivity tables test variable impacts.)
7. Which function sums a range of cells?
A) SUM()
B) ADD()
C) TOTAL()
D) COUNT()
A) SUM()
(Rationale: SUM() adds numbers in a range.)
8. What is the correct syntax for XLOOKUP?
A) =XLOOKUP(lookup_value, lookup_array, return_array)
B) =XLOOKUP(lookup_array, return_array, lookup_value)
C) =XLOOKUP(return_array, lookup_value, lookup_array)
D) =XLOOKUP(lookup_value, return_array, lookup_array)
A) =XLOOKUP(lookup_value, lookup_array, return_array)
(Rationale: XLOOKUP requires lookup value, array, and return array.)
9. Which key combination opens the Format Cells dialog box?
A) Ctrl + 1
B) Alt + F
C) Ctrl + F1
D) Shift + F1
A) Ctrl + 1
(Rationale: Ctrl + 1 accesses formatting options.)
10. What does a pivot table allow you to do?
A) Create formulas
B) Summarize and analyze data
C) Draw charts
D) Sort by color
B) Summarize and analyze data
(Rationale: Pivot tables aggregate data efficiently.)
11. Which formula calculates the present value of future cash flows?
A) =PV(rate, nper, pmt, [fv], [type])
B) =FV(rate, nper, pmt, [pv], [type])
Version from Wall Street Prep (WSP) |
Questions and 100% Correct Answers | Brand
New!! | A+ Graded
Section 1: Introduction
This document contains the latest and verified version of the Excel Crash Course Exam from
Wall Street Prep (WSP), updated for the 2025/2026 academic cycle. It includes 100% correct
answers to key topics such as financial modeling functions, shortcuts, data analysis,
formatting, IF/VLOOKUP/XLOOKUP logic, pivot tables, sensitivity tables, and keyboard-
based navigation. Perfect for finance, investment banking, and business students or
professionals, this brand-new A+ graded exam guide prepares users to master Excel
efficiently and pass with distinction.
Section 2: Exam Questions and Answers
Format: Multiple-choice and formula-based questions
Typically four answer choices per question (A–D)
Correct answer highlighted in green
Coverage includes keyboard skills, Excel logic, cell referencing, financial formulas, and
time-saving tools
1. Which keyboard shortcut selects the entire column in Excel?
A) Ctrl + Space
B) Alt + Space
C) Shift + Space
D) Ctrl + Shift + Arrow Down
A) Ctrl + Space
(Rationale: Ctrl + Space selects the entire column instantly.)
2. What function returns the current date in Excel?
A) TODAY()
B) NOW()
C) DATE()
D) CURRENT()
A) TODAY()
(Rationale: TODAY() updates to the current date.)
3. Which formula checks if a cell value is greater than 100 and returns "Yes" or
"No"?
A) =IF(A1>100, "Yes", "No")
B) =IF(A1>100, Yes, No)
C) =CHECK(A1>100, "Yes", "No")
D) =IF(A1>100)
A) =IF(A1>100, "Yes", "No")
(Rationale: IF function evaluates conditions and returns text.)
4. What is the purpose of the VLOOKUP function?
A) Sums a range of cells
, B) Looks up a value in a vertical table
C) Creates a pivot table
D) Formats cells
B) Looks up a value in a vertical table
(Rationale: VLOOKUP searches for data in the first column.)
5. Which shortcut copies the value from the cell above?
A) Ctrl + D
B) Ctrl + C
C) Alt + E + S
D) Ctrl + V
A) Ctrl + D
(Rationale: Ctrl + D duplicates the cell above.)
6. What does a sensitivity table in Excel do?
A) Formats data automatically
B) Analyzes how input changes affect outputs
C) Sorts data alphabetically
D) Creates charts
B) Analyzes how input changes affect outputs
(Rationale: Sensitivity tables test variable impacts.)
7. Which function sums a range of cells?
A) SUM()
B) ADD()
C) TOTAL()
D) COUNT()
A) SUM()
(Rationale: SUM() adds numbers in a range.)
8. What is the correct syntax for XLOOKUP?
A) =XLOOKUP(lookup_value, lookup_array, return_array)
B) =XLOOKUP(lookup_array, return_array, lookup_value)
C) =XLOOKUP(return_array, lookup_value, lookup_array)
D) =XLOOKUP(lookup_value, return_array, lookup_array)
A) =XLOOKUP(lookup_value, lookup_array, return_array)
(Rationale: XLOOKUP requires lookup value, array, and return array.)
9. Which key combination opens the Format Cells dialog box?
A) Ctrl + 1
B) Alt + F
C) Ctrl + F1
D) Shift + F1
A) Ctrl + 1
(Rationale: Ctrl + 1 accesses formatting options.)
10. What does a pivot table allow you to do?
A) Create formulas
B) Summarize and analyze data
C) Draw charts
D) Sort by color
B) Summarize and analyze data
(Rationale: Pivot tables aggregate data efficiently.)
11. Which formula calculates the present value of future cash flows?
A) =PV(rate, nper, pmt, [fv], [type])
B) =FV(rate, nper, pmt, [pv], [type])
