WGU C268 Study Guide for EXCEL PA Spreadsheets OA 200 Exam Questions & Answers with Rationale Academic Year 2026/2027

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.