WGU D465 - DATA APPLICATIONS EXAM
Objective Assessment (OA) | 150 Questions with Verified Answers
2026 Update | Graded A+ | Complete Practice Test Bank
EXAM DETAILS
| Attribute | Information |
|--|-|
| Institution | Western Governors University (WGU) |
| Course Code | D465 |
| Course Title | Data Applications |
| Exam Type | Objective Assessment (OA) / Pre-Assessment (PA) |
| Total Questions | 150 |
| Question Type | Multiple Choice |
| Format | Question + Correct Answer + Detailed Rationale |
| Academic Year | 2025/2026 |
SECTION 1: SPREADSHEET FUNCTIONS & FORMULAS
Questions 1–30
Question 1
A data analyst needs to calculate the average of values in cells B2 through B50. Which
spreadsheet formula should they use?
A) =SUM(B2:B50)
B) =AVG(B2:B50)
C) =AVERAGE(B2:B50)
D) =AVERAGE(B2,B50)
Correct answer: C
Rationale: The AVERAGE function calculates the arithmetic mean of a range of cells. SUM only
adds values, AVG is not a valid Excel function, and AVERAGE(B2,B50) only averages two cells,
not the entire range .
,Question 2
Which spreadsheet function returns the number of cells within a range that match a specified
condition?
A) COUNT()
B) COUNTA()
C) COUNTIF()
D) COUNTBLANK()
Correct answer: C
Rationale: COUNTIF counts cells that satisfy a given criterion (e.g., COUNTIF(A1:A10, ">5")).
COUNT counts numeric cells, COUNTA counts non-empty cells, and COUNTBLANK counts
empty cells .
Question 3
A data analyst writes the formula =SUMIF(K20:K70, ">=50", L20:L70). What does this formula
return?
A) Sum of all values in K20:K70 that are ≥50
B) Sum of values in L20:L70 where corresponding cells in K20:K70 are ≥50
C) Count of cells in K20:K70 with values ≥50
D) Average of cells L20:L70
Correct answer: B
Rationale: The SUMIF function sums values in the sum_range (L20:L70) only when the
corresponding cells in the range (K20:K70) meet the specified condition (≥50) .
Question 4
A data analyst needs to find the smallest numeric value in a cell range. Which function should
they use?
A) MIN()
B) SMALL()
C) LOWEST()
,D) LEAST()
Correct answer: A
Rationale: The MIN function returns the smallest numeric value in a specified range of cells.
SMALL can return the nth smallest value but requires two arguments .
Question 5
A data analyst needs to find the smallest numeric value in a range, but only for cells meeting a
specific condition. Which function should they use?
A) MINIFS
B) SMALL
C) MIN
D) AGGREGATE
Correct answer: A
Rationale: MINIFS returns the minimum value among cells specified by a given set of
conditions, e.g., MINIFS(B2:B100, A2:A100, ">100"). MIN alone ignores conditions .
Question 6
Which function would a data analyst use to calculate the sum of the products of corresponding
items in two arrays (e.g., for weighted averages)?
A) =PRODUCT()
B) =SUMPRODUCT()
C) =MULTIPLY()
D) =SUMX2MY2()
Correct answer: B
Rationale: SUMPRODUCT multiplies corresponding components in the given arrays and returns
the sum of those products, often used for weighted averages .
Question 7
, A data analyst wants to convert a decimal value in cell D5 (e.g., 0.74) to a percentage in Excel.
Which formula should they use?
A) =D5%
B) =D5,100
C) =D5(100)
D) =D5100
Correct answer: D
Rationale: Multiplying a decimal by 100 converts it to a percentage value (e.g., 0.74 × 100 = 74).
The number can then be formatted as a percentage or displayed with the % symbol .
Question 8
Which function would a data analyst use to calculate the number of days, months, or years
between two dates?
A) DATE()
B) DATEDIF()
C) DAYS()
D) NOW()
Correct answer: B
Rationale: DATEDIF calculates the difference between two dates in days, months, or years. It is
a hidden function in Excel that is extremely useful for date calculations .
Question 9
Which of the following functions counts the number of cells within a range that meet a specific
condition?
A) COUNT()
B) COUNTA()
C) COUNTIF()
D) COUNTBLANK()
Correct answer: C
Objective Assessment (OA) | 150 Questions with Verified Answers
2026 Update | Graded A+ | Complete Practice Test Bank
EXAM DETAILS
| Attribute | Information |
|--|-|
| Institution | Western Governors University (WGU) |
| Course Code | D465 |
| Course Title | Data Applications |
| Exam Type | Objective Assessment (OA) / Pre-Assessment (PA) |
| Total Questions | 150 |
| Question Type | Multiple Choice |
| Format | Question + Correct Answer + Detailed Rationale |
| Academic Year | 2025/2026 |
SECTION 1: SPREADSHEET FUNCTIONS & FORMULAS
Questions 1–30
Question 1
A data analyst needs to calculate the average of values in cells B2 through B50. Which
spreadsheet formula should they use?
A) =SUM(B2:B50)
B) =AVG(B2:B50)
C) =AVERAGE(B2:B50)
D) =AVERAGE(B2,B50)
Correct answer: C
Rationale: The AVERAGE function calculates the arithmetic mean of a range of cells. SUM only
adds values, AVG is not a valid Excel function, and AVERAGE(B2,B50) only averages two cells,
not the entire range .
,Question 2
Which spreadsheet function returns the number of cells within a range that match a specified
condition?
A) COUNT()
B) COUNTA()
C) COUNTIF()
D) COUNTBLANK()
Correct answer: C
Rationale: COUNTIF counts cells that satisfy a given criterion (e.g., COUNTIF(A1:A10, ">5")).
COUNT counts numeric cells, COUNTA counts non-empty cells, and COUNTBLANK counts
empty cells .
Question 3
A data analyst writes the formula =SUMIF(K20:K70, ">=50", L20:L70). What does this formula
return?
A) Sum of all values in K20:K70 that are ≥50
B) Sum of values in L20:L70 where corresponding cells in K20:K70 are ≥50
C) Count of cells in K20:K70 with values ≥50
D) Average of cells L20:L70
Correct answer: B
Rationale: The SUMIF function sums values in the sum_range (L20:L70) only when the
corresponding cells in the range (K20:K70) meet the specified condition (≥50) .
Question 4
A data analyst needs to find the smallest numeric value in a cell range. Which function should
they use?
A) MIN()
B) SMALL()
C) LOWEST()
,D) LEAST()
Correct answer: A
Rationale: The MIN function returns the smallest numeric value in a specified range of cells.
SMALL can return the nth smallest value but requires two arguments .
Question 5
A data analyst needs to find the smallest numeric value in a range, but only for cells meeting a
specific condition. Which function should they use?
A) MINIFS
B) SMALL
C) MIN
D) AGGREGATE
Correct answer: A
Rationale: MINIFS returns the minimum value among cells specified by a given set of
conditions, e.g., MINIFS(B2:B100, A2:A100, ">100"). MIN alone ignores conditions .
Question 6
Which function would a data analyst use to calculate the sum of the products of corresponding
items in two arrays (e.g., for weighted averages)?
A) =PRODUCT()
B) =SUMPRODUCT()
C) =MULTIPLY()
D) =SUMX2MY2()
Correct answer: B
Rationale: SUMPRODUCT multiplies corresponding components in the given arrays and returns
the sum of those products, often used for weighted averages .
Question 7
, A data analyst wants to convert a decimal value in cell D5 (e.g., 0.74) to a percentage in Excel.
Which formula should they use?
A) =D5%
B) =D5,100
C) =D5(100)
D) =D5100
Correct answer: D
Rationale: Multiplying a decimal by 100 converts it to a percentage value (e.g., 0.74 × 100 = 74).
The number can then be formatted as a percentage or displayed with the % symbol .
Question 8
Which function would a data analyst use to calculate the number of days, months, or years
between two dates?
A) DATE()
B) DATEDIF()
C) DAYS()
D) NOW()
Correct answer: B
Rationale: DATEDIF calculates the difference between two dates in days, months, or years. It is
a hidden function in Excel that is extremely useful for date calculations .
Question 9
Which of the following functions counts the number of cells within a range that meet a specific
condition?
A) COUNT()
B) COUNTA()
C) COUNTIF()
D) COUNTBLANK()
Correct answer: C
