WGU C268 – Spreadsheets Practice Exam,
Objective Assessment Questions with Complete
Solutions.
Exam Instructions:
This exam consists of 40 questions. Please read each question carefully and select the best
answer. Questions cover formula construction, data analysis, and financial modeling
scenarios.
Domain 1: Foundational Functions & Logical Operations
1. Scenario: You are calculating the total cost of items in a spreadsheet where Column B
contains the Unit Price and Column C contains the Quantity. You enter the formula =B2*C2 in
cell D2. You then copy this formula down to cell D10. However, cell D1 contains a specific Tax
Rate that needs to be multiplied by the result in D10. Which reference type should you use for
the Tax Rate in cell D1 to ensure it does not change when copied?
A) D1
B) $D$1
C) $D1
D) D$1
2. You have a value in cell A1 that you want to reference across different columns in the same
row, but you always want it to refer to Column A. As you copy the formula from Column B to
Column C, which reference ensures the column stays fixed but the row changes?
A) A$1
B) $A1
C) $A$1
D) A1
3. Which of the following IF statements correctly returns "Pass" if the score in cell A1 is
greater than or equal to 70, and "Fail" otherwise?
A) =IF(A1>70, "Pass", "Fail")
B) =IF(A1>=70, "Fail", "Pass")
C) =IF(A1>=70, "Pass", "Fail")
D) =IF(A1<70, "Pass", "Fail")
, 4. You need to assign a letter grade based on a score in cell A1. If A1 is greater than 89, return
"A". If A1 is greater than 79, return "B". Otherwise, return "C". Which nested IF formula is
correct?
A) =IF(A1>89, "A", IF(A1>79, "B", "C"))
B) =IF(A1>79, "B", IF(A1>89, "A", "C"))
C) =IF(A1>89, "A", A1>79, "B", "C")
D) =IFS(A1>89, "A", "A1>79", "B")
5. Which function returns the number of non-empty cells in a range A1:A10?
A) =COUNT(A1:A10)
B) =COUNTA(A1:A10)
C) =SUM(A1:A10)
D) =COUNTBLANK(A1:A10)
6. You need to find the smallest numeric value in the range B2:B20. Which function do you
use?
A) =MIN(B2:B20)
B) =SMALL(B2:B20, 1)
C) =BOTTOM(B2:B20)
D) =LOWEST(B2:B20)
7. Today is May 15, 2024. Which function will return the date for the last day of the current
month?
A) =TODAY()
B) =EOMONTH(TODAY(), 0)
C) =DATE(2024, 5, 31)
D) =NOW()
8. You want to calculate the number of complete days between a Start Date in cell A1 and an
End Date in cell B1. Which function is appropriate?
A) =DAYS(B1, A1)
B) =DATEDIF(A1, B1, "D")
C) =NETWORKDAYS(A1, B1)
D) =B1-A1
Domain 2: Lookup & Reference Functions
9. You need to look up an Employee ID in cell A2 within a table located in range E2:H20. The
Employee ID is in the first column of the table (Column E), and the Department Name is in the
third column (Column G). You require an exact match. Which formula is correct?
Objective Assessment Questions with Complete
Solutions.
Exam Instructions:
This exam consists of 40 questions. Please read each question carefully and select the best
answer. Questions cover formula construction, data analysis, and financial modeling
scenarios.
Domain 1: Foundational Functions & Logical Operations
1. Scenario: You are calculating the total cost of items in a spreadsheet where Column B
contains the Unit Price and Column C contains the Quantity. You enter the formula =B2*C2 in
cell D2. You then copy this formula down to cell D10. However, cell D1 contains a specific Tax
Rate that needs to be multiplied by the result in D10. Which reference type should you use for
the Tax Rate in cell D1 to ensure it does not change when copied?
A) D1
B) $D$1
C) $D1
D) D$1
2. You have a value in cell A1 that you want to reference across different columns in the same
row, but you always want it to refer to Column A. As you copy the formula from Column B to
Column C, which reference ensures the column stays fixed but the row changes?
A) A$1
B) $A1
C) $A$1
D) A1
3. Which of the following IF statements correctly returns "Pass" if the score in cell A1 is
greater than or equal to 70, and "Fail" otherwise?
A) =IF(A1>70, "Pass", "Fail")
B) =IF(A1>=70, "Fail", "Pass")
C) =IF(A1>=70, "Pass", "Fail")
D) =IF(A1<70, "Pass", "Fail")
, 4. You need to assign a letter grade based on a score in cell A1. If A1 is greater than 89, return
"A". If A1 is greater than 79, return "B". Otherwise, return "C". Which nested IF formula is
correct?
A) =IF(A1>89, "A", IF(A1>79, "B", "C"))
B) =IF(A1>79, "B", IF(A1>89, "A", "C"))
C) =IF(A1>89, "A", A1>79, "B", "C")
D) =IFS(A1>89, "A", "A1>79", "B")
5. Which function returns the number of non-empty cells in a range A1:A10?
A) =COUNT(A1:A10)
B) =COUNTA(A1:A10)
C) =SUM(A1:A10)
D) =COUNTBLANK(A1:A10)
6. You need to find the smallest numeric value in the range B2:B20. Which function do you
use?
A) =MIN(B2:B20)
B) =SMALL(B2:B20, 1)
C) =BOTTOM(B2:B20)
D) =LOWEST(B2:B20)
7. Today is May 15, 2024. Which function will return the date for the last day of the current
month?
A) =TODAY()
B) =EOMONTH(TODAY(), 0)
C) =DATE(2024, 5, 31)
D) =NOW()
8. You want to calculate the number of complete days between a Start Date in cell A1 and an
End Date in cell B1. Which function is appropriate?
A) =DAYS(B1, A1)
B) =DATEDIF(A1, B1, "D")
C) =NETWORKDAYS(A1, B1)
D) =B1-A1
Domain 2: Lookup & Reference Functions
9. You need to look up an Employee ID in cell A2 within a table located in range E2:H20. The
Employee ID is in the first column of the table (Column E), and the Department Name is in the
third column (Column G). You require an exact match. Which formula is correct?
