WGU D388 Fundamentals of Spreadsheets and Data Presentations Objective Assessment |
OA V1 and V2 | Questions and Answers | 2026 Update | 100% Correct.
Scenario for Questions 1–10: Catering Data Management
Malinova Catering is reviewing its September Orders worksheet. The worksheet contains
duplicate event records, unnecessary spaces in customer names, incorrect event types, misplaced
columns, and inconsistently formatted phone numbers.
Question 1
Which tool should the catering manager use to ensure that every record in the September Orders
worksheet is unique?
A. Filter Tool
B. Remove Duplicates
C. TRIM function
D. Find and Replace
Correct answer: B. Remove Duplicates
Rationale: The Remove Duplicates feature identifies and removes rows containing identical
values in selected columns. Filtering only hides records, TRIM removes unnecessary spaces, and
Find and Replace changes specified content.
Question 2
What is the most efficient way to change all occurrences of “Private” to “Corporate” across the
entire worksheet?
A. Manual data entry
B. Filter and delete
C. Find and Replace
D. Text to Columns
Correct answer: C. Find and Replace
Rationale: Find and Replace changes every matching occurrence at once, making it faster and
more consistent than manually editing individual cells. Text to Columns separates combined data
rather than replacing it.
,Question 3
A manager notices entries such as “ John Doe ” that contain leading and trailing spaces. Which
function should be used to clean this text?
A. CLEAN()
B. TRIM()
C. PROPER()
D. SUBSTITUTE()
Correct answer: B. TRIM()
Rationale: TRIM removes leading and trailing spaces and reduces multiple spaces between
words to one. CLEAN removes nonprinting characters, PROPER changes capitalization, and
SUBSTITUTE replaces specified text.
Question 4
When formatting financial data, what is the primary characteristic of Accounting format
compared with Currency format?
A. It removes all decimal places.
B. It displays negative numbers in bright yellow.
C. It aligns currency symbols and decimal points within a column.
D. It is used only for percentage calculations.
Correct answer: C. It aligns currency symbols and decimal points within a column.
Rationale: Accounting format places currency symbols at the edge of each cell and aligns
decimal points, producing a consistent financial presentation. Currency format normally places
the currency symbol directly beside the value.
Question 5
Which function should a manager use to identify the highest total price among all catering
orders?
A. SUM()
B. AVERAGE()
C. MAX()
D. COUNT()
,Correct answer: C. MAX()
Rationale: MAX returns the largest numeric value in a specified range. SUM adds values,
AVERAGE calculates their arithmetic mean, and COUNT counts numeric cells.
Question 6
The Employee Name cell for the order in row 17 is empty. What type of data-quality issue does
this represent?
A. Duplicate data
B. Missing data
C. Incorrect formatting
D. Formula error
Correct answer: B. Missing data
Rationale: An expected value that is absent constitutes missing data. It may prevent correct
grouping, reporting, or analysis and should be investigated before the dataset is used.
Question 7
The owner wants to display only Pastry sales recorded during June. Which spreadsheet feature
should be used?
A. Sort
B. Filter
C. Wrap Text
D. Conditional Formatting
Correct answer: B. Filter
Rationale: A filter temporarily displays only rows meeting specified conditions, such as
Category = Pastry and Month = June. It does not delete the excluded rows.
Question 8
Which chart is most appropriate for presenting each dessert category’s total cost as a percentage
of the overall dessert cost?
, A. Line chart
B. Column chart
C. Pie chart
D. Scatter plot
Correct answer: C. Pie chart
Rationale: A pie chart shows how individual categories contribute to one total. A line chart
shows trends, a column chart compares quantities, and a scatter plot displays relationships
between numeric variables.
Question 9
When text is too long for a cell and should appear on multiple lines within that same cell, which
feature should be used?
A. Merge & Center
B. Wrap Text
C. Shrink to Fit
D. AutoSum
Correct answer: B. Wrap Text
Rationale: Wrap Text displays the cell’s contents on multiple lines and adjusts the row height
when necessary. It preserves the column width and keeps the complete text visible.
Question 10
Which feature automatically continues a sequence of order numbers such as 101, 102, and 103
down a column?
A. Format Painter
B. Fill Handle or Fill Series
C. Data Validation
D. Sort Ascending
Correct answer: B. Fill Handle or Fill Series
Rationale: After identifying an existing pattern, the Fill Handle continues it into adjacent cells.
Format Painter copies formatting, Data Validation restricts entries, and sorting only rearranges
existing data.
OA V1 and V2 | Questions and Answers | 2026 Update | 100% Correct.
Scenario for Questions 1–10: Catering Data Management
Malinova Catering is reviewing its September Orders worksheet. The worksheet contains
duplicate event records, unnecessary spaces in customer names, incorrect event types, misplaced
columns, and inconsistently formatted phone numbers.
Question 1
Which tool should the catering manager use to ensure that every record in the September Orders
worksheet is unique?
A. Filter Tool
B. Remove Duplicates
C. TRIM function
D. Find and Replace
Correct answer: B. Remove Duplicates
Rationale: The Remove Duplicates feature identifies and removes rows containing identical
values in selected columns. Filtering only hides records, TRIM removes unnecessary spaces, and
Find and Replace changes specified content.
Question 2
What is the most efficient way to change all occurrences of “Private” to “Corporate” across the
entire worksheet?
A. Manual data entry
B. Filter and delete
C. Find and Replace
D. Text to Columns
Correct answer: C. Find and Replace
Rationale: Find and Replace changes every matching occurrence at once, making it faster and
more consistent than manually editing individual cells. Text to Columns separates combined data
rather than replacing it.
,Question 3
A manager notices entries such as “ John Doe ” that contain leading and trailing spaces. Which
function should be used to clean this text?
A. CLEAN()
B. TRIM()
C. PROPER()
D. SUBSTITUTE()
Correct answer: B. TRIM()
Rationale: TRIM removes leading and trailing spaces and reduces multiple spaces between
words to one. CLEAN removes nonprinting characters, PROPER changes capitalization, and
SUBSTITUTE replaces specified text.
Question 4
When formatting financial data, what is the primary characteristic of Accounting format
compared with Currency format?
A. It removes all decimal places.
B. It displays negative numbers in bright yellow.
C. It aligns currency symbols and decimal points within a column.
D. It is used only for percentage calculations.
Correct answer: C. It aligns currency symbols and decimal points within a column.
Rationale: Accounting format places currency symbols at the edge of each cell and aligns
decimal points, producing a consistent financial presentation. Currency format normally places
the currency symbol directly beside the value.
Question 5
Which function should a manager use to identify the highest total price among all catering
orders?
A. SUM()
B. AVERAGE()
C. MAX()
D. COUNT()
,Correct answer: C. MAX()
Rationale: MAX returns the largest numeric value in a specified range. SUM adds values,
AVERAGE calculates their arithmetic mean, and COUNT counts numeric cells.
Question 6
The Employee Name cell for the order in row 17 is empty. What type of data-quality issue does
this represent?
A. Duplicate data
B. Missing data
C. Incorrect formatting
D. Formula error
Correct answer: B. Missing data
Rationale: An expected value that is absent constitutes missing data. It may prevent correct
grouping, reporting, or analysis and should be investigated before the dataset is used.
Question 7
The owner wants to display only Pastry sales recorded during June. Which spreadsheet feature
should be used?
A. Sort
B. Filter
C. Wrap Text
D. Conditional Formatting
Correct answer: B. Filter
Rationale: A filter temporarily displays only rows meeting specified conditions, such as
Category = Pastry and Month = June. It does not delete the excluded rows.
Question 8
Which chart is most appropriate for presenting each dessert category’s total cost as a percentage
of the overall dessert cost?
, A. Line chart
B. Column chart
C. Pie chart
D. Scatter plot
Correct answer: C. Pie chart
Rationale: A pie chart shows how individual categories contribute to one total. A line chart
shows trends, a column chart compares quantities, and a scatter plot displays relationships
between numeric variables.
Question 9
When text is too long for a cell and should appear on multiple lines within that same cell, which
feature should be used?
A. Merge & Center
B. Wrap Text
C. Shrink to Fit
D. AutoSum
Correct answer: B. Wrap Text
Rationale: Wrap Text displays the cell’s contents on multiple lines and adjusts the row height
when necessary. It preserves the column width and keeps the complete text visible.
Question 10
Which feature automatically continues a sequence of order numbers such as 101, 102, and 103
down a column?
A. Format Painter
B. Fill Handle or Fill Series
C. Data Validation
D. Sort Ascending
Correct answer: B. Fill Handle or Fill Series
Rationale: After identifying an existing pattern, the Fill Handle continues it into adjacent cells.
Format Painter copies formatting, Data Validation restricts entries, and sorting only rearranges
existing data.
