WGU D388 Fundamentals of Spreadsheets and Data
Presentations Comprehensive Mock Exam | Questions
and Answers | New 2026/2027 Update
Section 1/5: 20 Marks Total
Section 1: Multiple Choice Questions
Question 1–10 Refer to the passage below.
Catering Data Management
Malinova Catering is reviewing their September Orders worksheet. The data
contains several issues: duplicate entries for the same event, extra spaces in the
'Customer Name' column, and incorrect event types where 'Private' was
accidentally entered instead of 'Corporate'. Additionally, some columns are out of
order, and several phone numbers do not follow the standard pattern.
Question 1 - 2 marks
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' tool is specifically designed to scan a dataset
and remove rows that contain identical data across specified columns. While a
filter can help find duplicates, only the Remove Duplicates tool will permanently
delete the redundant rows, ensuring record uniqueness for analysis.
,Question 2 - 2 marks
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 tool
D. Text to Columns
Correct Answer: C. Find and Replace tool
Rationale: The 'Find and Replace' tool is the most efficient solution for this task
because it allows for bulk editing of specific text strings across the entire
worksheet. It is significantly faster and more accurate than manual entry and
doesn't risk deleting data like "Filter and delete."
Question 3 - 2 marks
A manager notices that some entries like ' John Doe ' have leading and trailing
spaces. Which function should be applied to clean this text?
A. CLEAN()
B. TRIM()
C. PROPER()
D. SUBSTITUTE()
Correct Answer: B. TRIM()
Rationale: The TRIM function is specifically designed to remove all extra spaces
from text except for single spaces between words. It will remove the leading and
trailing spaces in ' John Doe ' to produce 'John Doe'. CLEAN() removes non-
printable characters, PROPER() capitalizes words, and SUBSTITUTE() replaces
specific text.
Question 4 - 2 marks
, When formatting financial data in a spreadsheet, what is the primary
characteristic of the 'Accounting' format compared to 'Currency'?
A. It removes all decimal places.
B. It displays negative numbers in bright yellow.
C. It aligns currency symbols and decimal points in a column.
D. It is only used for percentage calculations.
Correct Answer: C. It aligns currency symbols and decimal points in a column.
Rationale: The Accounting format distinguishes itself from the Currency format by
aligning the currency symbol to the left edge of the cell and the numbers to the
right, with the decimal points lined up vertically. This makes columns of financial
data easier to read and compare.
Question 5 - 2 marks
If a manager needs to find the highest total price among all catering orders,
which function is appropriate?
A. SUM
B. AVERAGE
C. MAX
D. COUNT
Correct Answer: C. MAX
Rationale: The MAX function's purpose is to return the largest numerical value
within a given range. In this scenario, it will correctly identify the highest total
price. SUM, AVERAGE, and COUNT serve different functions: addition, mean
calculation, and counting cells, respectively.
Question 6 - 2 marks
While reviewing the spreadsheet, the manager discovers that the 'Employee
Name' for the order in row 17 is empty. This is an example of:
Presentations Comprehensive Mock Exam | Questions
and Answers | New 2026/2027 Update
Section 1/5: 20 Marks Total
Section 1: Multiple Choice Questions
Question 1–10 Refer to the passage below.
Catering Data Management
Malinova Catering is reviewing their September Orders worksheet. The data
contains several issues: duplicate entries for the same event, extra spaces in the
'Customer Name' column, and incorrect event types where 'Private' was
accidentally entered instead of 'Corporate'. Additionally, some columns are out of
order, and several phone numbers do not follow the standard pattern.
Question 1 - 2 marks
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' tool is specifically designed to scan a dataset
and remove rows that contain identical data across specified columns. While a
filter can help find duplicates, only the Remove Duplicates tool will permanently
delete the redundant rows, ensuring record uniqueness for analysis.
,Question 2 - 2 marks
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 tool
D. Text to Columns
Correct Answer: C. Find and Replace tool
Rationale: The 'Find and Replace' tool is the most efficient solution for this task
because it allows for bulk editing of specific text strings across the entire
worksheet. It is significantly faster and more accurate than manual entry and
doesn't risk deleting data like "Filter and delete."
Question 3 - 2 marks
A manager notices that some entries like ' John Doe ' have leading and trailing
spaces. Which function should be applied to clean this text?
A. CLEAN()
B. TRIM()
C. PROPER()
D. SUBSTITUTE()
Correct Answer: B. TRIM()
Rationale: The TRIM function is specifically designed to remove all extra spaces
from text except for single spaces between words. It will remove the leading and
trailing spaces in ' John Doe ' to produce 'John Doe'. CLEAN() removes non-
printable characters, PROPER() capitalizes words, and SUBSTITUTE() replaces
specific text.
Question 4 - 2 marks
, When formatting financial data in a spreadsheet, what is the primary
characteristic of the 'Accounting' format compared to 'Currency'?
A. It removes all decimal places.
B. It displays negative numbers in bright yellow.
C. It aligns currency symbols and decimal points in a column.
D. It is only used for percentage calculations.
Correct Answer: C. It aligns currency symbols and decimal points in a column.
Rationale: The Accounting format distinguishes itself from the Currency format by
aligning the currency symbol to the left edge of the cell and the numbers to the
right, with the decimal points lined up vertically. This makes columns of financial
data easier to read and compare.
Question 5 - 2 marks
If a manager needs to find the highest total price among all catering orders,
which function is appropriate?
A. SUM
B. AVERAGE
C. MAX
D. COUNT
Correct Answer: C. MAX
Rationale: The MAX function's purpose is to return the largest numerical value
within a given range. In this scenario, it will correctly identify the highest total
price. SUM, AVERAGE, and COUNT serve different functions: addition, mean
calculation, and counting cells, respectively.
Question 6 - 2 marks
While reviewing the spreadsheet, the manager discovers that the 'Employee
Name' for the order in row 17 is empty. This is an example of:
