WGU D388 – Fundamentals of Spreadsheets & Data Presentations OA |
Questions and Answers | 2026 Updated Version | 100% Correct.
WGU D388 – Fundamentals of Spreadsheets & Data Presentations, modeled to OA difficulty, wording,
and concept balance.
⏱ Time Limit: 120 minutes
📊 Passing Benchmark: 70%
⏱ Format: Scenario-based, conceptual, and calculation logic (no trick fluff)
✅ WGU D388 – FULL 70-Question Timed Mock OA
Questions 1–10: Spreadsheet Fundamentals
1. What is the primary purpose of a spreadsheet?
A. Store images
B. Organize, calculate, and analyze data
C. Write documents
D. Design websites
Answer: B
2. What identifies a cell uniquely in a spreadsheet?
A. Column name
B. Row number
C. Cell reference
D. Sheet name
Answer: C
3. A workbook contains:
A. One worksheet only
B. Only formulas
C. Multiple worksheets
D. Only charts
Answer: C
4. Which entry must start with an equals sign?
A. Label
,B. Number
C. Formula
D. Date
Answer: C
5. Which data type allows calculations?
A. Text
B. Numbers
C. Images
D. Comments
Answer: B
6. What happens when you copy a formula with relative references?
A. References remain fixed
B. References update automatically
C. Formula deletes
D. Values turn to text
Answer: B
7. Which is an example of an absolute reference?
A. A1
B. A$1
C. $A1
D. $A$1
Answer: D
8. Why are absolute references used?
A. To speed up calculations
B. To lock a value when copying formulas
C. To remove errors
D. To format cells
Answer: B
9. What does copying a formula down a column usually do?
A. Deletes original formula
B. Adjusts row references
,C. Adjusts column references
D. Converts formula to value
Answer: B
10. Which symbol locks a cell reference?
A. &
B. %
C. $
D. #
Answer: C
Questions 11–25: Core Functions
11. Which function adds values in a range?
A. ADD
B. TOTAL
C. SUM
D. COUNT
Answer: C
12. What does =AVERAGE(A1:A5) return?
A. Total
B. Median
C. Mean
D. Count
Answer: C
13. COUNT counts:
A. All non-blank cells
B. Only numeric values
C. Only text values
D. Blank cells
Answer: B
14. COUNTA counts:
A. Numbers only
, B. Blank cells
C. All non-blank cells
D. Errors only
Answer: C
15. Which function returns the smallest value?
A. LOW
B. MIN
C. MAX
D. SMALL
Answer: B
16. Which function returns the largest value?
A. TOP
B. HIGH
C. MAX
D. BIG
Answer: C
17. What does this formula do?
=IF(B2>=60,"Pass","Fail")
A. Calculates average
B. Applies formatting
C. Performs a logical test
D. Sorts data
Answer: C
18. IF statements require how many arguments?
A. One
B. Two
C. Three
D. Four
Answer: C
19. Which operator means “not equal to”?
A. ==
Questions and Answers | 2026 Updated Version | 100% Correct.
WGU D388 – Fundamentals of Spreadsheets & Data Presentations, modeled to OA difficulty, wording,
and concept balance.
⏱ Time Limit: 120 minutes
📊 Passing Benchmark: 70%
⏱ Format: Scenario-based, conceptual, and calculation logic (no trick fluff)
✅ WGU D388 – FULL 70-Question Timed Mock OA
Questions 1–10: Spreadsheet Fundamentals
1. What is the primary purpose of a spreadsheet?
A. Store images
B. Organize, calculate, and analyze data
C. Write documents
D. Design websites
Answer: B
2. What identifies a cell uniquely in a spreadsheet?
A. Column name
B. Row number
C. Cell reference
D. Sheet name
Answer: C
3. A workbook contains:
A. One worksheet only
B. Only formulas
C. Multiple worksheets
D. Only charts
Answer: C
4. Which entry must start with an equals sign?
A. Label
,B. Number
C. Formula
D. Date
Answer: C
5. Which data type allows calculations?
A. Text
B. Numbers
C. Images
D. Comments
Answer: B
6. What happens when you copy a formula with relative references?
A. References remain fixed
B. References update automatically
C. Formula deletes
D. Values turn to text
Answer: B
7. Which is an example of an absolute reference?
A. A1
B. A$1
C. $A1
D. $A$1
Answer: D
8. Why are absolute references used?
A. To speed up calculations
B. To lock a value when copying formulas
C. To remove errors
D. To format cells
Answer: B
9. What does copying a formula down a column usually do?
A. Deletes original formula
B. Adjusts row references
,C. Adjusts column references
D. Converts formula to value
Answer: B
10. Which symbol locks a cell reference?
A. &
B. %
C. $
D. #
Answer: C
Questions 11–25: Core Functions
11. Which function adds values in a range?
A. ADD
B. TOTAL
C. SUM
D. COUNT
Answer: C
12. What does =AVERAGE(A1:A5) return?
A. Total
B. Median
C. Mean
D. Count
Answer: C
13. COUNT counts:
A. All non-blank cells
B. Only numeric values
C. Only text values
D. Blank cells
Answer: B
14. COUNTA counts:
A. Numbers only
, B. Blank cells
C. All non-blank cells
D. Errors only
Answer: C
15. Which function returns the smallest value?
A. LOW
B. MIN
C. MAX
D. SMALL
Answer: B
16. Which function returns the largest value?
A. TOP
B. HIGH
C. MAX
D. BIG
Answer: C
17. What does this formula do?
=IF(B2>=60,"Pass","Fail")
A. Calculates average
B. Applies formatting
C. Performs a logical test
D. Sorts data
Answer: C
18. IF statements require how many arguments?
A. One
B. Two
C. Three
D. Four
Answer: C
19. Which operator means “not equal to”?
A. ==
