WGU C268 Spreadsheets Actual Exam 2026/2027
| Verified Questions
Western Governors University | Verified Q&A | Business Spreadsheet Analysis
Candidates
Introduction
Welcome to the comprehensive, original, and verified question set for the WGU C268 Spreadsheets Actual
Exam 2026/2027. This examination preparation document contains exactly 100 highly detailed and
professionally rigorous questions structured to replicate the official Western Governors University (WGU)
C268 Introduction to Spreadsheets course objectives. The questions are evenly distributed across four
primary content domains: Spreadsheet Functions and Formulas (25 questions), Data Analysis and
Visualization (25 questions), Financial Calculations and Amortization (25 questions), and Business
Problem Solving with Spreadsheets (25 questions). This original content is designed to reinforce core
spreadsheet and analytical competencies, providing high-quality preparatory material for Business
Spreadsheet Analysis Candidates seeking actual exam readiness, professional spreadsheet proficiency,
and Higher Education degree progress.
Domain: Spreadsheet Functions and Formulas
Question 1: [VLOOKUP - Exact vs. Approximate Match]
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 of the
following Excel formulas is the 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.
WGU C268 Spreadsheets Actual Exam 2026/2027
,Question 2: [HLOOKUP - Row Index and Syntax]
A tax bracket table is arranged horizontally. The tax rates are in row 3 of the range
$B$1:$M$3, and the taxable income thresholds are in row 1. If a taxpayer's income is
located in cell P2, which HLOOKUP formula correctly finds the appropriate tax rate using
an approximate match?
(A) =HLOOKUP(P2, $B$1:$M$3, 1, TRUE)
(B) =HLOOKUP(P2, $B$1:$M$3, 3, FALSE)
(C) =HLOOKUP(P2, $B$1:$M$3, 3, TRUE)
(D) =HLOOKUP($B$1:$M$3, P2, 3, TRUE)
Correct Answer: C
Rationale: HLOOKUP searches the top row of a table (row 1) and returns a value in the same column
from a specified row (row index 3 contains the tax rates). Since tax brackets require finding the largest
value less than or equal to the lookup value, an approximate match (TRUE or omitted) is required. Thus,
option A is correct.
Question 3: [INDEX and MATCH - Two-Way Lookup]
A marketing manager wants to retrieve the sales figure for a specific region and month
from a grid table. The regions are listed vertically in range A2:A10, and the months are
listed horizontally in range B1:M1. The sales data is in range B2:M10. If the target region is
in cell P2 and the target month is in cell P3, which formula achieves this two-way lookup?
(A) =INDEX(B2:M10, MATCH(P2, A2:A10, 0), MATCH(P3, B1:M1, 0))
(B) =INDEX(B2:M10, MATCH(P3, B1:M1, 0), MATCH(P2, A2:A10, 0))
(C) =MATCH(B2:M10, INDEX(P2, A2:A10, 0), INDEX(P3, B1:M1, 0))
(D) =INDEX(A2:M10, MATCH(P2, A2:A10, 0), MATCH(P3, B1:M1, 0))
Correct Answer: A
Rationale: The INDEX function syntax is INDEX(array, row_num, column_num). To find the row
number, MATCH is used to find the target region (P2) in the vertical range (A2:A10). To find the column
number, MATCH is used to locate the target month (P3) in the horizontal range (B1:M1). This creates a
flexible, robust two-way lookup.
Question 4: [XLOOKUP - Syntax and Advantages]
An HR database administrator needs to find an employee's department. The employee ID
is in cell B5. The employee IDs are stored in column A, and departments are in column C.
Which of the following XLOOKUP formulas is correct to perform an exact match lookup by
default?
(A) =XLOOKUP(B5, A:C, 3)
(B) =XLOOKUP(B5, C:C, A:A)
(C) =XLOOKUP(B5, A:A, C:C)
(D) =XLOOKUP(A:C, B5, 3, FALSE)
Correct Answer: C
Rationale: XLOOKUP's basic syntax is XLOOKUP(lookup_value, lookup_array, return_array). Here,
the lookup value is B5, the range to search is A:A (employee IDs), and the range containing the values to
return is C:C (departments). XLOOKUP defaults to an exact match, eliminating the need for a fourth
'FALSE' argument. This tests modern Excel standards.
Question 5: [IF - Logical Test and Output]
A sales representative receives a 5% bonus if their total sales (cell C2) exceed the target of
WGU C268 Spreadsheets Actual Exam 2026/2027
,$50,000.00. Otherwise, they receive no bonus (represented as 0). Which of the following
Excel formulas represents this logical test?
(A) =IF(C2 >= 50000, 0.05, 0)
(B) =IF(C2 > 50000, 0, C2 * 0.05)
(C) =IF(C2 < 50000, C2 * 0.05, 0)
(D) =IF(C2 > 50000, C2 * 0.05, 0)
Correct Answer: D
Rationale: The IF function syntax is IF(logical_test, value_if_true, value_if_false). The logical test is
C2 > 50000. If true, the bonus is C2 * 0.05. If false, the output is 0. Option D is incorrect because it
returns only the decimal rate (0.05) rather than calculating the dollar bonus.
Question 6: [Nested IF - Multiple Conditions]
A retail pricing spreadsheet categorizes discounts based on quantity purchased (cell B2):
quantity >= 100 receives 15% discount; quantity >= 50 receives 10%; and quantity < 50
receives no discount (0). Which of the following nested IF formulas correctly implements
this tier structure?
(A) =IF(B2 < 50, 0, IF(B2 >= 50, 0.10, 0.15))
(B) =IF(B2 >= 50, 0.10, IF(B2 >= 100, 0.15, 0))
(C) =IF(B2 >= 100, 0.15, IF(B2 >= 50, 0.10, 0))
(D) =IF(B2 >= 100, 0.15, 0) + IF(B2 >= 50, 0.10, 0)
Correct Answer: C
Rationale: When nesting IF functions for numeric ranges, conditions must be evaluated in descending
or ascending order to prevent early exit conflicts. Starting with B2 >= 100 correctly catches large
orders, then nested IF(B2 >= 50) catches the mid-tier, and the final false argument catches everything
below 50. Option B would incorrectly assign 10% to quantities >= 100.
Question 7: [IFS - Syntax and Implementation]
Which of the following formulas represents the correct Excel syntax to replace nested IF
statements with the IFS function for evaluating student grades (cell G2): score >= 90 is 'A',
score >= 80 is 'B', score >= 70 is 'C', and anything else is 'F'?
(A) Option A and Option B are both correct and valid in Microsoft Excel.
(B) =IFS(G2 >= 90, "A", G2 >= 80, "B", G2 >= 70, "C", G2 < 70, "F")
(C) =IFS(G2 >= 90, "A", IF(G2 >= 80, "B", IF(G2 >= 70, "C", "F")))
(D) =IFS(G2 >= 90, "A", G2 >= 80, "B", G2 >= 70, "C", TRUE, "F")
Correct Answer: A
Rationale: The IFS function evaluates multiple conditions in order. Option B lists the final condition
explicitly (G2 < 70, 'F'). Option A uses the standard Excel convention of placing 'TRUE' as the final
condition to act as a catch-all 'else' argument. Both formulas are completely valid and execute correctly
in Excel.
WGU C268 Spreadsheets Actual Exam 2026/2027
, Question 8: [AND, OR, NOT - Complex Logic]
An underwriter needs to flag a loan application as 'Approved' if the applicant's credit score
(cell C3) is greater than 650 AND their debt-to-income ratio (cell D3) is less than 0.40.
Otherwise, the loan is 'Denied'. Which formula is correct?
(A) =IF(AND(C3 > 650, D3 < 40%), "Denied", "Approved")
(B) =IF(OR(C3 > 650, D3 < 0.40), "Approved", "Denied")
(C) =AND(IF(C3 > 650, "Approved"), IF(D3 < 0.40, "Approved", "Denied"))
(D) =IF(AND(C3 > 650, D3 < 0.40), "Approved", "Denied")
Correct Answer: D
Rationale: The AND function is placed as the logical test argument of the IF function. AND(C3 > 650,
D3 < 0.40) returns TRUE only if both individual conditions are met, resulting in 'Approved'. If either
fails, it returns FALSE, resulting in 'Denied'.
Question 9: [COUNTIF - Single Criterion]
A warehouse database contains a list of orders. The order status is in column D (range
D2:D200). Which Excel formula counts the total number of orders that have a status of
'Shipped'?
(A) =COUNT(D2:D200, "Shipped")
(B) =COUNTIF("Shipped", D2:D200)
(C) =COUNTIF(D2:D200, "Shipped")
(D) =COUNTIFS(D2:D200, "=Shipped", D2:D200, "<>")
Correct Answer: C
Rationale: The COUNTIF function syntax is COUNTIF(range, criteria). Here, the range to evaluate is
D2:D200, and the criterion is the text string 'Shipped'. Option C is incorrect because COUNT only counts
cells containing numbers.
Question 10: [COUNTIFS - Multiple Criteria]
A sales coordinator needs to count the number of sales transactions that occurred in the
'East' region (column B, range B2:B150) AND had a transaction value greater than
$1,000.00 (column F, range F2:F150). Which formula should be used?
(A) =COUNTIF(B2:B150, "East", F2:F150, ">1000")
(B) =COUNTIFS(B2:B150, "East", F2:F150, ">1000")
(C) =COUNTIFS("East", B2:B150, ">1000", F2:F150)
(D) =SUMPRODUCT((B2:B150="East") * (F2:F150>1000))
Correct Answer: B
Rationale: COUNTIFS allows for multiple criteria ranges and corresponding criteria in pairs:
COUNTIFS(criteria_range1, criteria1, criteria_range2, criteria2, ...). Option B matches this syntax
perfectly. (Note: Option D also calculates this, but COUNTIFS is the standard native statistical function
tested in WGU C268).
WGU C268 Spreadsheets Actual Exam 2026/2027
| Verified Questions
Western Governors University | Verified Q&A | Business Spreadsheet Analysis
Candidates
Introduction
Welcome to the comprehensive, original, and verified question set for the WGU C268 Spreadsheets Actual
Exam 2026/2027. This examination preparation document contains exactly 100 highly detailed and
professionally rigorous questions structured to replicate the official Western Governors University (WGU)
C268 Introduction to Spreadsheets course objectives. The questions are evenly distributed across four
primary content domains: Spreadsheet Functions and Formulas (25 questions), Data Analysis and
Visualization (25 questions), Financial Calculations and Amortization (25 questions), and Business
Problem Solving with Spreadsheets (25 questions). This original content is designed to reinforce core
spreadsheet and analytical competencies, providing high-quality preparatory material for Business
Spreadsheet Analysis Candidates seeking actual exam readiness, professional spreadsheet proficiency,
and Higher Education degree progress.
Domain: Spreadsheet Functions and Formulas
Question 1: [VLOOKUP - Exact vs. Approximate Match]
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 of the
following Excel formulas is the 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.
WGU C268 Spreadsheets Actual Exam 2026/2027
,Question 2: [HLOOKUP - Row Index and Syntax]
A tax bracket table is arranged horizontally. The tax rates are in row 3 of the range
$B$1:$M$3, and the taxable income thresholds are in row 1. If a taxpayer's income is
located in cell P2, which HLOOKUP formula correctly finds the appropriate tax rate using
an approximate match?
(A) =HLOOKUP(P2, $B$1:$M$3, 1, TRUE)
(B) =HLOOKUP(P2, $B$1:$M$3, 3, FALSE)
(C) =HLOOKUP(P2, $B$1:$M$3, 3, TRUE)
(D) =HLOOKUP($B$1:$M$3, P2, 3, TRUE)
Correct Answer: C
Rationale: HLOOKUP searches the top row of a table (row 1) and returns a value in the same column
from a specified row (row index 3 contains the tax rates). Since tax brackets require finding the largest
value less than or equal to the lookup value, an approximate match (TRUE or omitted) is required. Thus,
option A is correct.
Question 3: [INDEX and MATCH - Two-Way Lookup]
A marketing manager wants to retrieve the sales figure for a specific region and month
from a grid table. The regions are listed vertically in range A2:A10, and the months are
listed horizontally in range B1:M1. The sales data is in range B2:M10. If the target region is
in cell P2 and the target month is in cell P3, which formula achieves this two-way lookup?
(A) =INDEX(B2:M10, MATCH(P2, A2:A10, 0), MATCH(P3, B1:M1, 0))
(B) =INDEX(B2:M10, MATCH(P3, B1:M1, 0), MATCH(P2, A2:A10, 0))
(C) =MATCH(B2:M10, INDEX(P2, A2:A10, 0), INDEX(P3, B1:M1, 0))
(D) =INDEX(A2:M10, MATCH(P2, A2:A10, 0), MATCH(P3, B1:M1, 0))
Correct Answer: A
Rationale: The INDEX function syntax is INDEX(array, row_num, column_num). To find the row
number, MATCH is used to find the target region (P2) in the vertical range (A2:A10). To find the column
number, MATCH is used to locate the target month (P3) in the horizontal range (B1:M1). This creates a
flexible, robust two-way lookup.
Question 4: [XLOOKUP - Syntax and Advantages]
An HR database administrator needs to find an employee's department. The employee ID
is in cell B5. The employee IDs are stored in column A, and departments are in column C.
Which of the following XLOOKUP formulas is correct to perform an exact match lookup by
default?
(A) =XLOOKUP(B5, A:C, 3)
(B) =XLOOKUP(B5, C:C, A:A)
(C) =XLOOKUP(B5, A:A, C:C)
(D) =XLOOKUP(A:C, B5, 3, FALSE)
Correct Answer: C
Rationale: XLOOKUP's basic syntax is XLOOKUP(lookup_value, lookup_array, return_array). Here,
the lookup value is B5, the range to search is A:A (employee IDs), and the range containing the values to
return is C:C (departments). XLOOKUP defaults to an exact match, eliminating the need for a fourth
'FALSE' argument. This tests modern Excel standards.
Question 5: [IF - Logical Test and Output]
A sales representative receives a 5% bonus if their total sales (cell C2) exceed the target of
WGU C268 Spreadsheets Actual Exam 2026/2027
,$50,000.00. Otherwise, they receive no bonus (represented as 0). Which of the following
Excel formulas represents this logical test?
(A) =IF(C2 >= 50000, 0.05, 0)
(B) =IF(C2 > 50000, 0, C2 * 0.05)
(C) =IF(C2 < 50000, C2 * 0.05, 0)
(D) =IF(C2 > 50000, C2 * 0.05, 0)
Correct Answer: D
Rationale: The IF function syntax is IF(logical_test, value_if_true, value_if_false). The logical test is
C2 > 50000. If true, the bonus is C2 * 0.05. If false, the output is 0. Option D is incorrect because it
returns only the decimal rate (0.05) rather than calculating the dollar bonus.
Question 6: [Nested IF - Multiple Conditions]
A retail pricing spreadsheet categorizes discounts based on quantity purchased (cell B2):
quantity >= 100 receives 15% discount; quantity >= 50 receives 10%; and quantity < 50
receives no discount (0). Which of the following nested IF formulas correctly implements
this tier structure?
(A) =IF(B2 < 50, 0, IF(B2 >= 50, 0.10, 0.15))
(B) =IF(B2 >= 50, 0.10, IF(B2 >= 100, 0.15, 0))
(C) =IF(B2 >= 100, 0.15, IF(B2 >= 50, 0.10, 0))
(D) =IF(B2 >= 100, 0.15, 0) + IF(B2 >= 50, 0.10, 0)
Correct Answer: C
Rationale: When nesting IF functions for numeric ranges, conditions must be evaluated in descending
or ascending order to prevent early exit conflicts. Starting with B2 >= 100 correctly catches large
orders, then nested IF(B2 >= 50) catches the mid-tier, and the final false argument catches everything
below 50. Option B would incorrectly assign 10% to quantities >= 100.
Question 7: [IFS - Syntax and Implementation]
Which of the following formulas represents the correct Excel syntax to replace nested IF
statements with the IFS function for evaluating student grades (cell G2): score >= 90 is 'A',
score >= 80 is 'B', score >= 70 is 'C', and anything else is 'F'?
(A) Option A and Option B are both correct and valid in Microsoft Excel.
(B) =IFS(G2 >= 90, "A", G2 >= 80, "B", G2 >= 70, "C", G2 < 70, "F")
(C) =IFS(G2 >= 90, "A", IF(G2 >= 80, "B", IF(G2 >= 70, "C", "F")))
(D) =IFS(G2 >= 90, "A", G2 >= 80, "B", G2 >= 70, "C", TRUE, "F")
Correct Answer: A
Rationale: The IFS function evaluates multiple conditions in order. Option B lists the final condition
explicitly (G2 < 70, 'F'). Option A uses the standard Excel convention of placing 'TRUE' as the final
condition to act as a catch-all 'else' argument. Both formulas are completely valid and execute correctly
in Excel.
WGU C268 Spreadsheets Actual Exam 2026/2027
, Question 8: [AND, OR, NOT - Complex Logic]
An underwriter needs to flag a loan application as 'Approved' if the applicant's credit score
(cell C3) is greater than 650 AND their debt-to-income ratio (cell D3) is less than 0.40.
Otherwise, the loan is 'Denied'. Which formula is correct?
(A) =IF(AND(C3 > 650, D3 < 40%), "Denied", "Approved")
(B) =IF(OR(C3 > 650, D3 < 0.40), "Approved", "Denied")
(C) =AND(IF(C3 > 650, "Approved"), IF(D3 < 0.40, "Approved", "Denied"))
(D) =IF(AND(C3 > 650, D3 < 0.40), "Approved", "Denied")
Correct Answer: D
Rationale: The AND function is placed as the logical test argument of the IF function. AND(C3 > 650,
D3 < 0.40) returns TRUE only if both individual conditions are met, resulting in 'Approved'. If either
fails, it returns FALSE, resulting in 'Denied'.
Question 9: [COUNTIF - Single Criterion]
A warehouse database contains a list of orders. The order status is in column D (range
D2:D200). Which Excel formula counts the total number of orders that have a status of
'Shipped'?
(A) =COUNT(D2:D200, "Shipped")
(B) =COUNTIF("Shipped", D2:D200)
(C) =COUNTIF(D2:D200, "Shipped")
(D) =COUNTIFS(D2:D200, "=Shipped", D2:D200, "<>")
Correct Answer: C
Rationale: The COUNTIF function syntax is COUNTIF(range, criteria). Here, the range to evaluate is
D2:D200, and the criterion is the text string 'Shipped'. Option C is incorrect because COUNT only counts
cells containing numbers.
Question 10: [COUNTIFS - Multiple Criteria]
A sales coordinator needs to count the number of sales transactions that occurred in the
'East' region (column B, range B2:B150) AND had a transaction value greater than
$1,000.00 (column F, range F2:F150). Which formula should be used?
(A) =COUNTIF(B2:B150, "East", F2:F150, ">1000")
(B) =COUNTIFS(B2:B150, "East", F2:F150, ">1000")
(C) =COUNTIFS("East", B2:B150, ">1000", F2:F150)
(D) =SUMPRODUCT((B2:B150="East") * (F2:F150>1000))
Correct Answer: B
Rationale: COUNTIFS allows for multiple criteria ranges and corresponding criteria in pairs:
COUNTIFS(criteria_range1, criteria1, criteria_range2, criteria2, ...). Option B matches this syntax
perfectly. (Note: Option D also calculates this, but COUNTIFS is the standard native statistical function
tested in WGU C268).
WGU C268 Spreadsheets Actual Exam 2026/2027
