[WGU D216 SPREADSHEETS EXAM 2026] – EXAM-STYLE QUESTIONS AND
ANSWERS | VERIFIED AND WELL DETAILED ANSWERS | PLUS RATIONALES |
GUARANTEED PASS | 2026/27 LATEST UPDATE | EXAM PREP | STUDY GUIDE |
PRACTICE TEST
1. What is the primary purpose of a named range in a spreadsheet?
A. To apply a specific formatting style to a set of cells.
B. To create a dynamic drop-down list for data validation.
C. To assign a descriptive identifier to a single cell or a group of cells for easier
reference.
D. To password-protect sensitive data from unauthorized users.
Correct Answer: C. To assign a descriptive identifier to a single cell or a group of
cells for easier reference.
Rationale: A named range provides a meaningful label for a cell or a range of cells,
which simplifies formula creation and navigation. While named ranges can be used
in data validation and formatting, their core function is to provide a human-
readable reference. Options A, B, and D describe other distinct spreadsheet features,
not the primary function of a named range.
2. Which logical function should be used to test multiple conditions and return
a value only if all conditions are true?
A. =OR()
B. =IF()
C. =AND()
D. =NOT()
,Correct Answer: C. =AND()
Rationale: The =AND() function is designed to test multiple conditions and returns
TRUE only if every condition evaluates to TRUE; it returns FALSE if any condition is
false. The =OR() function returns TRUE if at least one condition is true. =IF() is a
conditional function that can incorporate AND or OR but is not itself the function
for testing multiple conditions. =NOT() simply reverses the logical value of its
argument.
3. An analyst is tracking the number of units sold each month. To identify the
top-selling product across a range of cells in column B, which function is most
effective?
A. =MAX(B:B)
B. =LARGE(B:B, 1)
C. =VLOOKUP(1, B:B, 1, FALSE)
D. =INDEX(MATCH(MAX(B:B), B:B, 0))
Correct Answer: B. =LARGE(B:B, 1)
Rationale: The =LARGE(array, k) function returns the k-th largest value in a dataset,
making =LARGE(B:B, 1) a correct and straightforward way to find the maximum
value. =MAX(B:B) will also return the same numerical value. However, =LARGE(B:B,
1) is specifically designed for returning the top values, which is the direct intent of
the question. Option D is a more complex way to retrieve the associated value from
the same row, but is not necessary just to find the number. Option C is incorrect as
it is a lookup function, not a statistical function.
,4. Which of the following data types is most appropriate for storing a date,
such as "January 15, 2026", in a cell?
A. Text
B. Number
C. Date
D. Time
Correct Answer: C. Date
Rationale: Spreadsheet applications offer specific data types for different kinds of
information. The Date data type is specifically designed to store and allow for
calculations with dates. While dates can be stored as text, this prevents date-based
calculations. They are actually stored as serial numbers, but the chosen display
format is 'Date', making C the most appropriate option. The Number data type is
too broad, and Time is only for time values without dates.
5. A project manager needs to combine the text from cell A1 ("Invoice #") with
the number from cell B1 (2026). Which function will accomplish this?
A. =SUM(A1, B1)
B. =A1 + B1
C. =CONCATENATE(A1, B1)
D. =A1 & B1
Correct Answer: D. =A1 & B1
Rationale: The ampersand (&) is the standard concatenation operator in most
spreadsheet applications, used to join text strings. =CONCATENATE(A1, B1) also
performs this function, however, the ampersand is the more efficient and commonly
, used method. Options A and B are arithmetic functions and would attempt to add
the values, resulting in an error.
6. What is the default cell reference type when a formula is copied down a
column?
A. Absolute
B. Mixed
C. Relative
D. Structured
Correct Answer: C. Relative
Rationale: When a formula is copied, relative references adjust automatically based
on the new location. For example, a formula =A1 copied down one row becomes
=A2. This behavior is the default. Absolute references ($A$1) remain fixed, and
mixed references have one component fixed and one relative.
7. An accountant uses a spreadsheet to manage payroll. To ensure that the total
gross pay is always a positive number, which function should they use?
A. =MAX()
B. =MIN()
C. =ABS()
D. =ROUND()
Correct Answer: C. =ABS()
ANSWERS | VERIFIED AND WELL DETAILED ANSWERS | PLUS RATIONALES |
GUARANTEED PASS | 2026/27 LATEST UPDATE | EXAM PREP | STUDY GUIDE |
PRACTICE TEST
1. What is the primary purpose of a named range in a spreadsheet?
A. To apply a specific formatting style to a set of cells.
B. To create a dynamic drop-down list for data validation.
C. To assign a descriptive identifier to a single cell or a group of cells for easier
reference.
D. To password-protect sensitive data from unauthorized users.
Correct Answer: C. To assign a descriptive identifier to a single cell or a group of
cells for easier reference.
Rationale: A named range provides a meaningful label for a cell or a range of cells,
which simplifies formula creation and navigation. While named ranges can be used
in data validation and formatting, their core function is to provide a human-
readable reference. Options A, B, and D describe other distinct spreadsheet features,
not the primary function of a named range.
2. Which logical function should be used to test multiple conditions and return
a value only if all conditions are true?
A. =OR()
B. =IF()
C. =AND()
D. =NOT()
,Correct Answer: C. =AND()
Rationale: The =AND() function is designed to test multiple conditions and returns
TRUE only if every condition evaluates to TRUE; it returns FALSE if any condition is
false. The =OR() function returns TRUE if at least one condition is true. =IF() is a
conditional function that can incorporate AND or OR but is not itself the function
for testing multiple conditions. =NOT() simply reverses the logical value of its
argument.
3. An analyst is tracking the number of units sold each month. To identify the
top-selling product across a range of cells in column B, which function is most
effective?
A. =MAX(B:B)
B. =LARGE(B:B, 1)
C. =VLOOKUP(1, B:B, 1, FALSE)
D. =INDEX(MATCH(MAX(B:B), B:B, 0))
Correct Answer: B. =LARGE(B:B, 1)
Rationale: The =LARGE(array, k) function returns the k-th largest value in a dataset,
making =LARGE(B:B, 1) a correct and straightforward way to find the maximum
value. =MAX(B:B) will also return the same numerical value. However, =LARGE(B:B,
1) is specifically designed for returning the top values, which is the direct intent of
the question. Option D is a more complex way to retrieve the associated value from
the same row, but is not necessary just to find the number. Option C is incorrect as
it is a lookup function, not a statistical function.
,4. Which of the following data types is most appropriate for storing a date,
such as "January 15, 2026", in a cell?
A. Text
B. Number
C. Date
D. Time
Correct Answer: C. Date
Rationale: Spreadsheet applications offer specific data types for different kinds of
information. The Date data type is specifically designed to store and allow for
calculations with dates. While dates can be stored as text, this prevents date-based
calculations. They are actually stored as serial numbers, but the chosen display
format is 'Date', making C the most appropriate option. The Number data type is
too broad, and Time is only for time values without dates.
5. A project manager needs to combine the text from cell A1 ("Invoice #") with
the number from cell B1 (2026). Which function will accomplish this?
A. =SUM(A1, B1)
B. =A1 + B1
C. =CONCATENATE(A1, B1)
D. =A1 & B1
Correct Answer: D. =A1 & B1
Rationale: The ampersand (&) is the standard concatenation operator in most
spreadsheet applications, used to join text strings. =CONCATENATE(A1, B1) also
performs this function, however, the ampersand is the more efficient and commonly
, used method. Options A and B are arithmetic functions and would attempt to add
the values, resulting in an error.
6. What is the default cell reference type when a formula is copied down a
column?
A. Absolute
B. Mixed
C. Relative
D. Structured
Correct Answer: C. Relative
Rationale: When a formula is copied, relative references adjust automatically based
on the new location. For example, a formula =A1 copied down one row becomes
=A2. This behavior is the default. Absolute references ($A$1) remain fixed, and
mixed references have one component fixed and one relative.
7. An accountant uses a spreadsheet to manage payroll. To ensure that the total
gross pay is always a positive number, which function should they use?
A. =MAX()
B. =MIN()
C. =ABS()
D. =ROUND()
Correct Answer: C. =ABS()
