WSP Wall Street Prep Excel Crash Course Exam 2026/2027 – Questions and Answers | 100% Verified | Detailed Rationales – Pass Guaranteed – A+ Graded

MICROSOFT EXCEL PROFICIENCY




EXCEL CRASH COURSE EXAM 2026/2027 LATEST VERSION FROM WALL STREET
QUESTIONS AND 100% CORRECT ANSWERS (BRAND NEW!!) | WSP EXCEL CRASH
COURSE


A+

Complete Domain Coverage




A+ 5 100%
QUESTIONS VERIFIED CORE DOMAINS COVERED RATIONALES INCLUDED




CATEGORIES

Section 1: Formulas, Functions & Cell References


Section 2: Lookup, Logic & Conditional Analysis


Section 3: Data Tools, Tables & PivotTables


Section 4: Formatting, Charts & Presentation


Section 5: Keyboard Shortcuts, Efficiency & Best Practices




STUVIAACTUALEXAM

, EXCEL CRASH COURSE EXAM 2026/2027 LATEST VERSION FROM WALL STREET QUESTIONS AND 100% CORRECT ANSWERS (BRAND NEW!!) |
WSP EXCEL CRASH COURSE
Each question is worth 1 mark. Total: 50 marks. Passing score: 80% (40 correct). Select the single best answer.


SECTION 1: Formulas, Functions & Cell References


Q1
Q1. An analyst builds a model in which formula inputs sit in column B and all calculations should update when inputs change. A formula in
C10 was typed as =B10*1.05 but needs to be copied across a row while always reading the growth rate from cell $B$1. Which reference
style should be used for the growth rate?
A. Relative reference B1
B. Absolute reference $B$1
C. Mixed reference B$1 only with relative column
D. Text string "B1"
Correct Answer: B

Rationale: Absolute references ($B$1) lock both column and row so the growth rate does not shift when the formula is copied.


Q2
Q2. A worksheet contains revenue in A2:A13. The analyst needs the arithmetic mean. Which formula is correct?
A. =ADD(A2:A13)
B. =AVERAGE(A2:A13)
C. =MEAN(A2:A13)
D. =TOTAL(A2:A13)/12
Correct Answer: B

Rationale: AVERAGE returns the mean of numeric values in the specified range.


Q3
Q3. Cell D5 holds the formula =A5+B5. The analyst inserts a new column before column A. What typically happens to the formula
references?
A. They break permanently and show #REF! always
B. Excel adjusts relative references to the new locations
C. The formula converts to values automatically
D. The workbook closes without saving
Correct Answer: B

Rationale: Excel updates relative and most structured references when rows or columns are inserted so formulas continue to point to the intended cells.


Q4
Q4. An analyst needs to combine the text in A2 ("North") and B2 ("Region") with a space between them. Which formula works?
A. =A2 AND B2
B. =A2&" "&B2 or =CONCAT(A2," ",B2)
C. =SUM(A2,B2)
D. =A2+B2
Correct Answer: B

Rationale: The ampersand operator or CONCAT joins text strings; a literal space must be included as a separate argument or string.


Q5
Q5. A finance schedule uses =EOMONTH(B2,0) where B2 is 15-Mar-2026. What does the function return?
A. The first day of March 2026
B. The last day of March 2026
C. 15-Apr-2026
D. A #VALUE! error always
Correct Answer: B

Rationale: EOMONTH returns the last day of the month that is the indicated number of months before or after the start date; 0 keeps the same month.


Q6
Q6. In a column of mixed numbers and text, an analyst wants to count only numeric entries in A2:A100. Which function is appropriate?
A. =COUNTA(A2:A100)
B. =COUNT(A2:A100)
C. =COUNTBLANK(A2:A100)
D. =LEN(A2:A100)
Correct Answer: B

Rationale: COUNT tallies numeric values only; COUNTA counts all nonblank cells including text.