WGU D388 FUNDAMENTALS OF SPREADSHEETS
AND DATA PRESENTATIONS OBJECTIVE
ASSESSMENT | OA V1 AND V2 | QUESTIONS AND
ANSWERS | 2026 UPDATE | 100% CORRECT
Core Domains:
• Spreadsheet Basics and Navigation
• Cell References (Relative, Absolute, Mixed)
• Formulas and Functions (SUM, AVERAGE, COUNT, COUNTA, IF, VLOOKUP,
XLOOKUP, etc.)
• Data Organization and Management (Sorting, Filtering, Tables)
• Data Visualization (Charts, Graphs, Sparklines)
• Data Presentation and Formatting
• PivotTables and PivotCharts
• Data Validation and Conditional Formatting
• What-If Analysis and Data Tools
• Collaboration and Workbook Management
Introduction
This comprehensive objective assessment preparation guide is designed for students
enrolled in WGU D388 Fundamentals of Spreadsheets and Data Presentations. It
covers all essential concepts tested on the Objective Assessment (OA), including
spreadsheet navigation, cell references, formulas and functions, data organization,
data visualization, PivotTables, and data presentation techniques. The questions are
formatted to reflect the style and difficulty of actual OA questions, with an emphasis
on practical application and critical thinking. Each question is followed by the verified
correct answer and a detailed rationale to reinforce understanding of key
,spreadsheet concepts. This guide reflects the most current 2026 curriculum updates
and includes content relevant to both V1 and V2 versions of the OA. Success on this
exam demonstrates mastery of spreadsheet fundamentals essential for data analysis
and presentation in professional contexts.
SECTION ONE: QUESTIONS 1–200
Question 1
In Microsoft Excel, the intersection of a column and a row is called a:
A. Range
B. Worksheet
C. Cell
D. Workbook
C. Cell
RATIONALE: A cell is the intersection of a column letter and a row number. Each
cell has a unique address such as A1, B2, or C3.
Question 2
In Excel, a workbook is best defined as:
A. A single spreadsheet
B. A collection of worksheets
C. A chart
D. A formula
B. A collection of worksheets
RATIONALE: A workbook is an Excel file containing one or more worksheets. Each
worksheet is a separate spreadsheet within the workbook.
Question 3
The cell address B4 refers to:
,A. Column B, row 4
B. Row B, column 4
C. Cell B on worksheet 4
D. The fourth cell in column B
A. Column B, row 4
RATIONALE: In Excel, cell addresses are written with the column letter first,
followed by the row number. B4 refers to the cell at the intersection of column B and
row 4.
Question 4
Which of the following best describes a worksheet?
A. An Excel file that stores all information, calculations, and analyses
B. A collection of cells arranged in the form of a table that contains the actual data
and calculations
C. A small box that stores an individual piece of data or a calculation
D. A built-in method for performing a calculation
B. A collection of cells arranged in the form of a table that contains the actual
data and calculations
RATIONALE: A worksheet is a single spreadsheet within a workbook, organized as
a grid of cells in rows and columns that contains data and calculations.
Question 5
What is the term for the content stored within an individual cell in a worksheet?
A. Formula
B. Function
C. Value
D. Argument
C. Value
RATIONALE: The content within a cell is referred to as its value, which can be
text, numbers, dates, or other data types.
, Question 6
A stack of cells arranged vertically from the top to the bottom of a worksheet is called
a:
A. Row
B. Column
C. Range
D. Table
B. Column
RATIONALE: Columns are vertical stacks of cells labeled with letters (A, B, C,
etc.).
Question 7
A collection of cells arranged horizontally from left to right of a worksheet is called a:
A. Row
B. Column
C. Range
D. Table
A. Row
RATIONALE: Rows are horizontal collections of cells labeled with numbers (1, 2,
3, etc.).
Question 8
Which ribbon tab in Excel contains the tools for formatting the appearance of data in
cells?
A. File
B. Insert
C. Home
D. Formulas
C. Home
AND DATA PRESENTATIONS OBJECTIVE
ASSESSMENT | OA V1 AND V2 | QUESTIONS AND
ANSWERS | 2026 UPDATE | 100% CORRECT
Core Domains:
• Spreadsheet Basics and Navigation
• Cell References (Relative, Absolute, Mixed)
• Formulas and Functions (SUM, AVERAGE, COUNT, COUNTA, IF, VLOOKUP,
XLOOKUP, etc.)
• Data Organization and Management (Sorting, Filtering, Tables)
• Data Visualization (Charts, Graphs, Sparklines)
• Data Presentation and Formatting
• PivotTables and PivotCharts
• Data Validation and Conditional Formatting
• What-If Analysis and Data Tools
• Collaboration and Workbook Management
Introduction
This comprehensive objective assessment preparation guide is designed for students
enrolled in WGU D388 Fundamentals of Spreadsheets and Data Presentations. It
covers all essential concepts tested on the Objective Assessment (OA), including
spreadsheet navigation, cell references, formulas and functions, data organization,
data visualization, PivotTables, and data presentation techniques. The questions are
formatted to reflect the style and difficulty of actual OA questions, with an emphasis
on practical application and critical thinking. Each question is followed by the verified
correct answer and a detailed rationale to reinforce understanding of key
,spreadsheet concepts. This guide reflects the most current 2026 curriculum updates
and includes content relevant to both V1 and V2 versions of the OA. Success on this
exam demonstrates mastery of spreadsheet fundamentals essential for data analysis
and presentation in professional contexts.
SECTION ONE: QUESTIONS 1–200
Question 1
In Microsoft Excel, the intersection of a column and a row is called a:
A. Range
B. Worksheet
C. Cell
D. Workbook
C. Cell
RATIONALE: A cell is the intersection of a column letter and a row number. Each
cell has a unique address such as A1, B2, or C3.
Question 2
In Excel, a workbook is best defined as:
A. A single spreadsheet
B. A collection of worksheets
C. A chart
D. A formula
B. A collection of worksheets
RATIONALE: A workbook is an Excel file containing one or more worksheets. Each
worksheet is a separate spreadsheet within the workbook.
Question 3
The cell address B4 refers to:
,A. Column B, row 4
B. Row B, column 4
C. Cell B on worksheet 4
D. The fourth cell in column B
A. Column B, row 4
RATIONALE: In Excel, cell addresses are written with the column letter first,
followed by the row number. B4 refers to the cell at the intersection of column B and
row 4.
Question 4
Which of the following best describes a worksheet?
A. An Excel file that stores all information, calculations, and analyses
B. A collection of cells arranged in the form of a table that contains the actual data
and calculations
C. A small box that stores an individual piece of data or a calculation
D. A built-in method for performing a calculation
B. A collection of cells arranged in the form of a table that contains the actual
data and calculations
RATIONALE: A worksheet is a single spreadsheet within a workbook, organized as
a grid of cells in rows and columns that contains data and calculations.
Question 5
What is the term for the content stored within an individual cell in a worksheet?
A. Formula
B. Function
C. Value
D. Argument
C. Value
RATIONALE: The content within a cell is referred to as its value, which can be
text, numbers, dates, or other data types.
, Question 6
A stack of cells arranged vertically from the top to the bottom of a worksheet is called
a:
A. Row
B. Column
C. Range
D. Table
B. Column
RATIONALE: Columns are vertical stacks of cells labeled with letters (A, B, C,
etc.).
Question 7
A collection of cells arranged horizontally from left to right of a worksheet is called a:
A. Row
B. Column
C. Range
D. Table
A. Row
RATIONALE: Rows are horizontal collections of cells labeled with numbers (1, 2,
3, etc.).
Question 8
Which ribbon tab in Excel contains the tools for formatting the appearance of data in
cells?
A. File
B. Insert
C. Home
D. Formulas
C. Home
