WGU C268 Study Guide for EXCEL PA
Spreadsheets OA
200 Exam Questions & Answers with
Rationale
Academic Year 2026/2027
SECTION 1: BASIC EXCEL FUNCTIONS & FORMULAS (Questions 1-30)
Q1: What is the correct syntax for the SUM function?
A) =SUM(A1+A10)
B) =SUM(A1:A10)
C) =SUM(A1 to A10)
D) =ADD(A1:A10)
Answer: B) =SUM(A1:A10)
Rationale: The SUM function uses a colon to denote a range of cells. The correct
syntax is =SUM(A1:A10) which adds all values from cell A1 through A10.
Q2: Which function would you use to find the arithmetic mean of a range?
A) =AVG()
B) =MEAN()
C) =AVERAGE()
D) =MEDIAN()
Answer: C) =AVERAGE()
Rationale: AVERAGE is the correct Excel function for calculating the arithmetic
mean. AVG and MEAN are not valid Excel functions, and MEDIAN finds the
middle value.
,Q3: What does the COUNT function do?
A) Counts all cells in a range
B) Counts numeric cells in a range
C) Counts non-blank cells in a range
D) Counts text cells in a range
Answer: B) Counts numeric cells in a range
Rationale: COUNT specifically counts cells containing numbers. COUNTA counts
non-blank cells, and COUNTBLANK counts empty cells.
Q4: Which formula would correctly calculate the total of cells B2 through
B10?
A) =TOTAL(B2-B10)
B) =SUBTOTAL(B2:B10)
C) =SUM(B2:B10)
D) =ADD(B2:B10)
Answer: C) =SUM(B2:B10)
Rationale: SUM is the only correct function for adding a range of cells.
SUBTOTAL can perform multiple operations but requires a function number
argument.
Q5: What is the result of =MAX(5,10,15,20)?
A) 5
B) 15
C) 20
D) 10
Answer: C) 20
Rationale: MAX returns the largest value in the set of arguments. The maximum
value among 5, 10, 15, and 20 is 20.
Q6: Which function would return the smallest value in a range?
A) =LOWEST()
,B) =SMALLEST()
C) =MIN()
D) =LEAST()
Answer: C) =MIN()
Rationale: MIN is the Excel function that returns the minimum value from a range
or set of arguments.
Q7: What does the COUNTA function count?
A) Only cells with numbers
B) Only cells with text
C) All non-empty cells
D) Only cells with formulas
Answer: C) All non-empty cells
Rationale: COUNTA counts all cells that are not empty, including numbers, text,
logical values, error values, and formulas that return values.
Q8: How do you reference cell B5 in a formula?
A) [B5]
B) {B5}
C) B5
D) (B5)
Answer: C) B5
Rationale: In Excel, cell references are written as column letter followed by row
number without brackets, braces, or parentheses.
Q9: What is the correct way to add cells A1, A2, and A3?
A) =ADD(A1+A2+A3)
B) =SUM(A1,A2,A3)
C) =SUM(A1+A2+A3)
D) Both B and C
, Answer: D) Both B and C K. K. K. K. K.
Rationale: Both =SUM(A1,A2,A3) and =SUM(A1+A2+A3) work correctly. SUM
K. K. K. K. K. K. K.
accepts both comma-separated values and arithmetic expressions.
K. K. K. K. K. K. K.
Q10: Which formula calculates the average of B2:B10 excluding blank cells?
K. K. K. K. K. K. K. K. K. K.
A) =AVG(B2:B10)
K.
B) =AVERAGE(B2:B10)
K.
C) =AVERAGEA(B2:B10)
K.
D) =MEAN(B2:B10)
K.
Answer: B) =AVERAGE(B2:B10) K. K.
Rationale: AVERAGE automatically ignores blank cells. AVERAGEA includes
K. K. K. K. K. K. K.
logical values and text in calculations.
K. K. K. K. K. K.
Q11: What is the shortcut to autosum a range?
K. K. K. K. K. K. K. K.
A) Ctrl + A K. K.
B) Ctrl + S K. K.
C) Alt + = K. K.
D) Ctrl + Shift + = K. K. K. K.
Answer: C) Alt + = K. K. K. K.
Rationale: Alt + = is the keyboard shortcut for the AutoSum feature in Excel,
K. K. K. K. K. K. K. K. K. K. K. K. K.
which automatically enters a SUM function for the adjacent range.
K. K. K. K. K. K. K. K. K. K.
Q12: Which function returns the number of days between two dates?
K. K. K. K. K. K. K. K. K. K.
A) =DAYS()
K.
B) =DATEDIF()
K.
C) =NETWORKDAYS()
K.
D) All of the above
K. K. K. K.
Answer: D) All of the above K. K. K. K. K.
Rationale: DAYS, DATEDIF, and NETWORKDAYS all calculate days between
K. K. K. K. K. K. K. K.
dates, though with different features and parameters.
K. K. K. K. K. K. K.
Spreadsheets OA
200 Exam Questions & Answers with
Rationale
Academic Year 2026/2027
SECTION 1: BASIC EXCEL FUNCTIONS & FORMULAS (Questions 1-30)
Q1: What is the correct syntax for the SUM function?
A) =SUM(A1+A10)
B) =SUM(A1:A10)
C) =SUM(A1 to A10)
D) =ADD(A1:A10)
Answer: B) =SUM(A1:A10)
Rationale: The SUM function uses a colon to denote a range of cells. The correct
syntax is =SUM(A1:A10) which adds all values from cell A1 through A10.
Q2: Which function would you use to find the arithmetic mean of a range?
A) =AVG()
B) =MEAN()
C) =AVERAGE()
D) =MEDIAN()
Answer: C) =AVERAGE()
Rationale: AVERAGE is the correct Excel function for calculating the arithmetic
mean. AVG and MEAN are not valid Excel functions, and MEDIAN finds the
middle value.
,Q3: What does the COUNT function do?
A) Counts all cells in a range
B) Counts numeric cells in a range
C) Counts non-blank cells in a range
D) Counts text cells in a range
Answer: B) Counts numeric cells in a range
Rationale: COUNT specifically counts cells containing numbers. COUNTA counts
non-blank cells, and COUNTBLANK counts empty cells.
Q4: Which formula would correctly calculate the total of cells B2 through
B10?
A) =TOTAL(B2-B10)
B) =SUBTOTAL(B2:B10)
C) =SUM(B2:B10)
D) =ADD(B2:B10)
Answer: C) =SUM(B2:B10)
Rationale: SUM is the only correct function for adding a range of cells.
SUBTOTAL can perform multiple operations but requires a function number
argument.
Q5: What is the result of =MAX(5,10,15,20)?
A) 5
B) 15
C) 20
D) 10
Answer: C) 20
Rationale: MAX returns the largest value in the set of arguments. The maximum
value among 5, 10, 15, and 20 is 20.
Q6: Which function would return the smallest value in a range?
A) =LOWEST()
,B) =SMALLEST()
C) =MIN()
D) =LEAST()
Answer: C) =MIN()
Rationale: MIN is the Excel function that returns the minimum value from a range
or set of arguments.
Q7: What does the COUNTA function count?
A) Only cells with numbers
B) Only cells with text
C) All non-empty cells
D) Only cells with formulas
Answer: C) All non-empty cells
Rationale: COUNTA counts all cells that are not empty, including numbers, text,
logical values, error values, and formulas that return values.
Q8: How do you reference cell B5 in a formula?
A) [B5]
B) {B5}
C) B5
D) (B5)
Answer: C) B5
Rationale: In Excel, cell references are written as column letter followed by row
number without brackets, braces, or parentheses.
Q9: What is the correct way to add cells A1, A2, and A3?
A) =ADD(A1+A2+A3)
B) =SUM(A1,A2,A3)
C) =SUM(A1+A2+A3)
D) Both B and C
, Answer: D) Both B and C K. K. K. K. K.
Rationale: Both =SUM(A1,A2,A3) and =SUM(A1+A2+A3) work correctly. SUM
K. K. K. K. K. K. K.
accepts both comma-separated values and arithmetic expressions.
K. K. K. K. K. K. K.
Q10: Which formula calculates the average of B2:B10 excluding blank cells?
K. K. K. K. K. K. K. K. K. K.
A) =AVG(B2:B10)
K.
B) =AVERAGE(B2:B10)
K.
C) =AVERAGEA(B2:B10)
K.
D) =MEAN(B2:B10)
K.
Answer: B) =AVERAGE(B2:B10) K. K.
Rationale: AVERAGE automatically ignores blank cells. AVERAGEA includes
K. K. K. K. K. K. K.
logical values and text in calculations.
K. K. K. K. K. K.
Q11: What is the shortcut to autosum a range?
K. K. K. K. K. K. K. K.
A) Ctrl + A K. K.
B) Ctrl + S K. K.
C) Alt + = K. K.
D) Ctrl + Shift + = K. K. K. K.
Answer: C) Alt + = K. K. K. K.
Rationale: Alt + = is the keyboard shortcut for the AutoSum feature in Excel,
K. K. K. K. K. K. K. K. K. K. K. K. K.
which automatically enters a SUM function for the adjacent range.
K. K. K. K. K. K. K. K. K. K.
Q12: Which function returns the number of days between two dates?
K. K. K. K. K. K. K. K. K. K.
A) =DAYS()
K.
B) =DATEDIF()
K.
C) =NETWORKDAYS()
K.
D) All of the above
K. K. K. K.
Answer: D) All of the above K. K. K. K. K.
Rationale: DAYS, DATEDIF, and NETWORKDAYS all calculate days between
K. K. K. K. K. K. K. K.
dates, though with different features and parameters.
K. K. K. K. K. K. K.
