WGU D465 - DATA APPLICATIONS EXAM.

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