WGU D278 — Objective Assessment (OA) | Financial Applications of Excel 2026 Update | 70 Questions | 100 pts
WGU D278 OBJECTIVE ASSESSMENT
70 QUESTIONS AND ANSWERS | 2026 UPDATE | 100% CORRECT
Western Governors University • Financial Applications of Excel & Data Analysis (D278)
Aligned with 2026 | 2027 academic standards • Formulas · Financial Functions · What-If · PivotTables · AI
Questions 70 multiple-choice (4 sections) Time (suggested) 120 minutes
Points 100 (~1.43 pts per question) Passing ≥ 70 (Competent)
Cognitive Mix 30% recall · 50% application · 20% analysis Format 75% scenario / 25% direct
Examination Instructions
This Objective Assessment mirrors the structure, difficulty, and scenario-based application style of the actual
WGU D278 Financial Applications of Excel assessment. Each question presents four options (A–D) with
exactly one correct answer. Rationales include step-by-step Excel syntax, argument order, and financial
calculation logic—demonstrating exactly how to build the formula or use the tool. Distractors represent the
exact results of common student errors (e.g., forgetting to lock cell references with absolute referencing, using
the wrong sign convention in financial functions, selecting SUMIF instead of SUMIFS, misinterpreting Data
Table output, or reversing VLOOKUP arguments). Section 4 integrates 2026|2027 modern Excel
advancements: dynamic array functions (FILTER/SORT/UNIQUE), Excel Copilot, Python in Excel, and
automated insights.
Section 1: Excel Fundamentals, Formulas, & Lookup Functions (Q1–Q18)
Cell referencing (relative, absolute, mixed); logical functions (IF, IFS); statistical/conditional aggregation (SUMIF,
SUMIFS, COUNTIF, AVERAGEIF); lookup functions (VLOOKUP, HLOOKUP, XLOOKUP, INDEX/MATCH);
two-way lookups; wildcards.
Q1. A formula in cell B5 reads =A1+B1. When copied to cell C5, the formula becomes:
A. =B1+C1 [CORRECT]
B. =A1+B1
C. =A2+B2
D. =$A$1+$B$1
Correct Answer: A — =B1+C1
Rationale: Relative references adjust by the same row/column offset. From B5 to C5 is one column right, so A1→B1
and B1→C1: =B1+C1. B would require absolute references; C uses wrong row offset; D uses absolute (no change).
Q2. Which reference keeps the column fixed but allows the row to change when copied?
A. Mixed reference $A1 [CORRECT]
B. Absolute reference $A$1
C. Relative reference A1
D. Named range only
Correct Answer: A — Mixed reference $A1
Rationale: $A1 locks the column (A) but lets the row change—this is a mixed reference. $A$1 locks both (absolute);
A1 locks neither (relative).
Q3. To keep cell B2 fixed when a formula is copied to any other cell, use:
A. $B$2 [CORRECT]
Western Governors University • Confidential OA Study Tool Page 1
,WGU D278 — Objective Assessment (OA) | Financial Applications of Excel 2026 Update | 70 Questions | 100 pts
B. B2
C. $B2
D. B$2
Correct Answer: A — $B$2
Rationale: $B$2 (absolute reference) locks both column and row. $B2/B$2 are mixed (lock only one axis); B2 is
relative (no lock).
Q4. The IF function syntax =IF(A1>=90,"Pass","Fail") returns "Fail" when A1 contains:
A. 85 [CORRECT]
B. 95
C. 90
D. 100
Correct Answer: A — 85
Rationale: The test A1>=90 is FALSE only when A1 < 90. 85 is < 90, so it returns "Fail". 95/90/100 all return "Pass".
Q5. Which function tests multiple conditions and returns a value for the FIRST true condition?
A. IFS [CORRECT]
B. IF
C. SUMIF
D. COUNTIF
Correct Answer: A — IFS
Rationale: IFS evaluates multiple conditions in order and returns the value for the first true one. IF tests a single
condition; SUMIF/COUNTIF aggregate based on a condition.
Q6. To sum values in B2:B100 only when corresponding cells in A2:A100 equal "North", use:
A. =SUMIF(A2:A100,"North",B2:B100) [CORRECT]
B. =SUMIF(B2:B100,"North",A2:A100)
C. =SUMIFS(A2:A100,"North",B2:B100)
D. =IF(A2:A100="North",SUM(B2:B100),0)
Correct Answer: A — =SUMIF(A2:A100,"North",B2:B100)
Rationale: SUMIF(range, criteria, [sum_range]): range = A2:A100 (criteria column), criteria = "North", sum_range =
B2:B100. B reverses range/sum_range; C misuses SUMIFS syntax; D is invalid array logic.
Q7. To count cells in A2:A50 that contain numbers greater than 100, use:
A. =COUNTIF(A2:A50,">100") [CORRECT]
B. =COUNT(A2:A50,>100)
C. =COUNTIF(A2:A50,100)
D. =COUNTIFS(A2:A50,>100)
Correct Answer: A — =COUNTIF(A2:A50,">100")
Rationale: COUNTIF(range, criteria): =COUNTIF(A2:A50,">100"). B uses wrong syntax; C counts only 100; D omits
required quotes around criteria.
Q8. VLOOKUP's fourth argument (range_lookup) should be FALSE when:
A. You need an exact match
B. You need an approximate match
C. The table is unsorted
D. Both A and C [CORRECT]
Western Governors University • Confidential OA Study Tool Page 2
, WGU D278 — Objective Assessment (OA) | Financial Applications of Excel 2026 Update | 70 Questions | 100 pts
Correct Answer: D — Both A and C
Rationale: FALSE forces an exact match and does not require the table to be sorted. Both A and C are correct
reasons to use FALSE.
Q9. VLOOKUP searches for a lookup value in which column of the table_array?
A. The first (leftmost) column [CORRECT]
B. The last column
C. Any column specified
D. The middle column
Correct Answer: A — The first (leftmost) column
Rationale: VLOOKUP always searches the first (leftmost) column of table_array. This is a key limitation that
INDEX/MATCH or XLOOKUP overcomes.
Q10. A limitation of VLOOKUP is that it:
A. Can only return values to the right of the lookup column [CORRECT]
B. Cannot return numeric values
C. Cannot use exact matches
D. Requires unsorted data
Correct Answer: A — Can only return values to the right of the lookup column
Rationale: VLOOKUP can only return values from columns to the right of the lookup column. INDEX/MATCH or
XLOOKUP can look left. B/C/D are false limitations.
Q11. Which function can look up a value in any direction (left, right, up, down)?
A. XLOOKUP [CORRECT]
B. VLOOKUP
C. HLOOKUP
D. LOOKUP (vector) only
Correct Answer: A — XLOOKUP
Rationale: XLOOKUP can search in any direction and return from any column. VLOOKUP/HLOOKUP are directional;
the vector LOOKUP has limitations XLOOKUP resolves.
Q12. The INDEX function returns:
A. A value at a specified row/column position in a range [CORRECT]
B. The position of a value
C. A lookup to the right only
D. A count of cells
Correct Answer: A — A value at a specified row/column position in a range
Rationale: INDEX(array, row_num, [col_num]) returns the value at a specified position. MATCH returns the
position; INDEX/MATCH combines them for flexible lookups.
Q13. The MATCH function returns:
A. The relative position of a lookup value within a range [CORRECT]
B. The value at a position
C. A count of matches
D. An exact match only
Correct Answer: A — The relative position of a lookup value within a range
Rationale: MATCH(lookup_value, lookup_array, [match_type]) returns the relative position of the lookup value.
INDEX returns the value; combined they enable two-way lookups.
Western Governors University • Confidential OA Study Tool Page 3
WGU D278 OBJECTIVE ASSESSMENT
70 QUESTIONS AND ANSWERS | 2026 UPDATE | 100% CORRECT
Western Governors University • Financial Applications of Excel & Data Analysis (D278)
Aligned with 2026 | 2027 academic standards • Formulas · Financial Functions · What-If · PivotTables · AI
Questions 70 multiple-choice (4 sections) Time (suggested) 120 minutes
Points 100 (~1.43 pts per question) Passing ≥ 70 (Competent)
Cognitive Mix 30% recall · 50% application · 20% analysis Format 75% scenario / 25% direct
Examination Instructions
This Objective Assessment mirrors the structure, difficulty, and scenario-based application style of the actual
WGU D278 Financial Applications of Excel assessment. Each question presents four options (A–D) with
exactly one correct answer. Rationales include step-by-step Excel syntax, argument order, and financial
calculation logic—demonstrating exactly how to build the formula or use the tool. Distractors represent the
exact results of common student errors (e.g., forgetting to lock cell references with absolute referencing, using
the wrong sign convention in financial functions, selecting SUMIF instead of SUMIFS, misinterpreting Data
Table output, or reversing VLOOKUP arguments). Section 4 integrates 2026|2027 modern Excel
advancements: dynamic array functions (FILTER/SORT/UNIQUE), Excel Copilot, Python in Excel, and
automated insights.
Section 1: Excel Fundamentals, Formulas, & Lookup Functions (Q1–Q18)
Cell referencing (relative, absolute, mixed); logical functions (IF, IFS); statistical/conditional aggregation (SUMIF,
SUMIFS, COUNTIF, AVERAGEIF); lookup functions (VLOOKUP, HLOOKUP, XLOOKUP, INDEX/MATCH);
two-way lookups; wildcards.
Q1. A formula in cell B5 reads =A1+B1. When copied to cell C5, the formula becomes:
A. =B1+C1 [CORRECT]
B. =A1+B1
C. =A2+B2
D. =$A$1+$B$1
Correct Answer: A — =B1+C1
Rationale: Relative references adjust by the same row/column offset. From B5 to C5 is one column right, so A1→B1
and B1→C1: =B1+C1. B would require absolute references; C uses wrong row offset; D uses absolute (no change).
Q2. Which reference keeps the column fixed but allows the row to change when copied?
A. Mixed reference $A1 [CORRECT]
B. Absolute reference $A$1
C. Relative reference A1
D. Named range only
Correct Answer: A — Mixed reference $A1
Rationale: $A1 locks the column (A) but lets the row change—this is a mixed reference. $A$1 locks both (absolute);
A1 locks neither (relative).
Q3. To keep cell B2 fixed when a formula is copied to any other cell, use:
A. $B$2 [CORRECT]
Western Governors University • Confidential OA Study Tool Page 1
,WGU D278 — Objective Assessment (OA) | Financial Applications of Excel 2026 Update | 70 Questions | 100 pts
B. B2
C. $B2
D. B$2
Correct Answer: A — $B$2
Rationale: $B$2 (absolute reference) locks both column and row. $B2/B$2 are mixed (lock only one axis); B2 is
relative (no lock).
Q4. The IF function syntax =IF(A1>=90,"Pass","Fail") returns "Fail" when A1 contains:
A. 85 [CORRECT]
B. 95
C. 90
D. 100
Correct Answer: A — 85
Rationale: The test A1>=90 is FALSE only when A1 < 90. 85 is < 90, so it returns "Fail". 95/90/100 all return "Pass".
Q5. Which function tests multiple conditions and returns a value for the FIRST true condition?
A. IFS [CORRECT]
B. IF
C. SUMIF
D. COUNTIF
Correct Answer: A — IFS
Rationale: IFS evaluates multiple conditions in order and returns the value for the first true one. IF tests a single
condition; SUMIF/COUNTIF aggregate based on a condition.
Q6. To sum values in B2:B100 only when corresponding cells in A2:A100 equal "North", use:
A. =SUMIF(A2:A100,"North",B2:B100) [CORRECT]
B. =SUMIF(B2:B100,"North",A2:A100)
C. =SUMIFS(A2:A100,"North",B2:B100)
D. =IF(A2:A100="North",SUM(B2:B100),0)
Correct Answer: A — =SUMIF(A2:A100,"North",B2:B100)
Rationale: SUMIF(range, criteria, [sum_range]): range = A2:A100 (criteria column), criteria = "North", sum_range =
B2:B100. B reverses range/sum_range; C misuses SUMIFS syntax; D is invalid array logic.
Q7. To count cells in A2:A50 that contain numbers greater than 100, use:
A. =COUNTIF(A2:A50,">100") [CORRECT]
B. =COUNT(A2:A50,>100)
C. =COUNTIF(A2:A50,100)
D. =COUNTIFS(A2:A50,>100)
Correct Answer: A — =COUNTIF(A2:A50,">100")
Rationale: COUNTIF(range, criteria): =COUNTIF(A2:A50,">100"). B uses wrong syntax; C counts only 100; D omits
required quotes around criteria.
Q8. VLOOKUP's fourth argument (range_lookup) should be FALSE when:
A. You need an exact match
B. You need an approximate match
C. The table is unsorted
D. Both A and C [CORRECT]
Western Governors University • Confidential OA Study Tool Page 2
, WGU D278 — Objective Assessment (OA) | Financial Applications of Excel 2026 Update | 70 Questions | 100 pts
Correct Answer: D — Both A and C
Rationale: FALSE forces an exact match and does not require the table to be sorted. Both A and C are correct
reasons to use FALSE.
Q9. VLOOKUP searches for a lookup value in which column of the table_array?
A. The first (leftmost) column [CORRECT]
B. The last column
C. Any column specified
D. The middle column
Correct Answer: A — The first (leftmost) column
Rationale: VLOOKUP always searches the first (leftmost) column of table_array. This is a key limitation that
INDEX/MATCH or XLOOKUP overcomes.
Q10. A limitation of VLOOKUP is that it:
A. Can only return values to the right of the lookup column [CORRECT]
B. Cannot return numeric values
C. Cannot use exact matches
D. Requires unsorted data
Correct Answer: A — Can only return values to the right of the lookup column
Rationale: VLOOKUP can only return values from columns to the right of the lookup column. INDEX/MATCH or
XLOOKUP can look left. B/C/D are false limitations.
Q11. Which function can look up a value in any direction (left, right, up, down)?
A. XLOOKUP [CORRECT]
B. VLOOKUP
C. HLOOKUP
D. LOOKUP (vector) only
Correct Answer: A — XLOOKUP
Rationale: XLOOKUP can search in any direction and return from any column. VLOOKUP/HLOOKUP are directional;
the vector LOOKUP has limitations XLOOKUP resolves.
Q12. The INDEX function returns:
A. A value at a specified row/column position in a range [CORRECT]
B. The position of a value
C. A lookup to the right only
D. A count of cells
Correct Answer: A — A value at a specified row/column position in a range
Rationale: INDEX(array, row_num, [col_num]) returns the value at a specified position. MATCH returns the
position; INDEX/MATCH combines them for flexible lookups.
Q13. The MATCH function returns:
A. The relative position of a lookup value within a range [CORRECT]
B. The value at a position
C. A count of matches
D. An exact match only
Correct Answer: A — The relative position of a lookup value within a range
Rationale: MATCH(lookup_value, lookup_array, [match_type]) returns the relative position of the lookup value.
INDEX returns the value; combined they enable two-way lookups.
Western Governors University • Confidential OA Study Tool Page 3
