WGU C268 SpreadSheetS aCtUal exam – WeStern GovernorS UniverSity – 2026/2027 aCademiC year – verified QUeStionS and anSWerS || JUSt releaSed.

WGU C268 SpreadSheetS aCtUal exam – WeStern GovernorS
UniverSity – 2026/2027 aCademiC year – verified QUeStionS and
anSWerS || JUSt releaSed.




The following 100 questions are evenly distributed across four primary content domains aligned
with the official WGU C268 Introduction to Spreadsheets course objectives. Each question
includes four answer choices, the correct answer, and a detailed rationale reinforcing core
spreadsheet and analytical competencies.



Domain 1: Spreadsheet Functions and Formulas (Questions 1–25)



Question 1: A business analyst needs to look up the exact unit price of a product from an
inventory table. The product ID is in cell A2, and the inventory table is located in range
$F$2:$H$100, where the product ID is in column F and the unit price is in column H. Which Excel
formula is most appropriate to retrieve the exact unit price?

• A) =VLOOKUP($F$2:$H$100, A2, 3, FALSE)

• B) =VLOOKUP(A2, $F$2:$H$100, 3, TRUE)

• C) =VLOOKUP(A2, $F$2:$H$100, 3, FALSE)

• D) =VLOOKUP(A2, $F$2:$H$100, 8, FALSE)

CorreCt anSWer: C

rationale: To perform an exact match lookup with VLOOKUP, the fourth argument
(range_lookup) must be set to FALSE (or 0). The lookup value is cell A2, the table array is the
absolute range $F$2:$H$100, and the column index is 3 (column H is the third column of the
range F, G, H). Option B would perform an approximate match, which is incorrect for exact
product lookups.



Question 2: An analyst needs to find the position of a specific customer name within a list.
Which function should be used to return the relative position of an item in a range?

• A) VLOOKUP

, • B) INDEX

• C) MATCH

• D) FIND

CorreCt anSWer: C

rationale: The MATCH function returns the relative position of a specified value within a
range. VLOOKUP returns a value from a different column, INDEX returns a value at a specific
position, and FIND is used for text string location within a cell.



Question 3: Which formula correctly combines the INDEX and MATCH functions to retrieve a
value from column C where the value in column A equals "Product X"?

• A) =INDEX(C:C, MATCH("Product X", A:A, 1))

• B) =INDEX(C:C, MATCH("Product X", A:A, 0))

• C) =MATCH(INDEX(C:C, "Product X", A:A, 0))

• D) =INDEX(MATCH("Product X", A:A, 0), C:C)

CorreCt anSWer: B

rationale: The correct syntax is INDEX(return_range, MATCH(lookup_value, lookup_range,
match_type)). Match_type 0 specifies an exact match. Option A uses 1 (approximate match), and
options C and D have incorrect syntax.



Question 4: A user needs to sum all values in column B where the corresponding value in
column A equals "Q1". Which formula should be used?

• A) =SUMIF(A:A, "Q1", B:B)

• B) =SUMIF(B:B, "Q1", A:A)

• C) =SUMIFS(A:A, "Q1", B:B)

• D) =SUMIFS(B:B, A:A, "Q1")

CorreCt anSWer: A

rationale: SUMIF(range, criteria, sum_range) sums values in the sum_range where the
corresponding cells in the range meet the criteria. Option A correctly sums B:B where A:A equals
"Q1". SUMIFS is used for multiple criteria and has a different syntax.

,Question 5: An employee spreadsheet contains first names in column A and last names in
column B. Which formula combines them into a single cell with a space between?

• A) =A1+B1

• B) =CONCATENATE(A1, B1)

• C) =A1 & " " & B1

• D) Both B and C with proper formatting

CorreCt anSWer: D

rationale: Both =CONCATENATE(A1, " ", B1) and =A1 & " " & B1 produce the same result.
Option B as written would combine without a space; it should be CONCATENATE(A1, " ", B1).
Option C correctly uses the ampersand with a space.



Question 6: A financial analyst needs to calculate the future value of an investment with
monthly contributions. Which function is most appropriate?

• A) FV(rate, nper, pmt, [pv], [type])

• B) PV(rate, nper, pmt, [fv], [type])

• C) PMT(rate, nper, pv, [fv], [type])

• D) NPV(rate, value1, [value2], ...)

CorreCt anSWer: A

rationale: FV (Future Value) calculates the future value of an investment based on periodic,
constant payments and a constant interest rate. PV calculates present value, PMT calculates
payment amounts, and NPV calculates net present value of uneven cash flows.



Question 7: Which Excel function returns the current date and time?

• A) TODAY()

• B) NOW()

• C) DATE()

• D) TIME()

CorreCt anSWer: B

, rationale: NOW() returns both the current date and time. TODAY() returns only the current
date. DATE() and TIME() construct date/time values from components.



Question 8: A business needs to count the number of cells in range A1:A50 that contain the
word "Approved". Which formula should be used?

• A) =COUNT(A1:A50, "Approved")

• B) =COUNTIF(A1:A50, "Approved")

• C) =COUNTIFS(A1:A50, "Approved")

• D) =COUNTA(A1:A50, "Approved")

CorreCt anSWer: B

rationale: COUNTIF(range, criteria) counts cells that meet a single condition. COUNTIFS is for
multiple criteria. COUNT counts numeric cells, and COUNTA counts non-empty cells.



Question 9: A user needs to convert a text string to uppercase. Which function should be used?

• A) UPPER

• B) PROPER

• C) LOWER

• D) TEXT

CorreCt anSWer: A

rationale: UPPER converts text to all uppercase. PROPER capitalizes the first letter of each
word. LOWER converts to lowercase. TEXT formats values.



Question 10: Which Excel function returns the number of characters in a text string?

• A) CHAR

• B) LEN

• C) FIND

• D) SEARCH

CorreCt anSWer: B