WGU D388 – FUNDAMENTALS OF SPREADSHEETS AND DATA PRESENTATIONS OBJECTIVE ASSESSMENT–
QUESTIONS AND ANSWERS | VERIFIED AND WELL DETAILED ANSWERS | PLUS RATIONALES | DOWNLOAD AND
PASS | LATEST EXAM UPDATE 2026/2027
Core Domains
1. Spreadsheet Fundamentals and Navigation
2. Data Entry, Formatting, and Validation
3. Formulas, Functions, and Logical Operations
4. Data Analysis and Visualization Techniques
5. Chart Creation and Interpretation
6. Data Management, Sorting, and Filtering
7. Professional Presentation and Reporting
8. Ethical Use of Data and Regulatory Compliance (e.g., GDPR, HIPAA)
9. Collaboration, Review, and Security Features
10. Scenario-Based Decision Making and Troubleshooting
Introduction
This comprehensive examination is designed to rigorously assess your mastery of the core principles and practical
applications of spreadsheets and data presentations as defined by the WGU D388 curriculum. It evaluates your
,foundational knowledge of spreadsheet navigation, data manipulation, and the creation of compelling visual
narratives. The assessment employs a combination of direct multiple-choice questions and complex, scenario-based
problems that require you to apply your skills to realistic professional contexts. You will be expected to demonstrate not
only technical proficiency in using functions and charts but also the critical thinking necessary for ethical data
handling, compliance, and effective decision-making. Success on this exam signifies your readiness to leverage data as
a strategic asset in any modern business environment.
Section One: Questions 1–50
1. What is the primary purpose of the "Name Box" in a spreadsheet application?
A. To display the formula contained within the active cell
B. To provide a search function for finding specific data within the worksheet
C. To display the reference of the active cell or the defined name of a selected range
D. To insert a new comment into the active cell
🟢 Correct Answer: C. To display the reference of the active cell or the defined name of a selected range
🔴 Explanation: The Name Box is located to the left of the formula bar and its main function is to show the address
(e.g., A1, B2) of the currently selected cell or the name of a selected range if one has been defined.
,2. When creating a formula in Excel that divides the value in cell B3 by the value in cell C7, what is the correct
syntax?
A. =B3/C7
B. =DIVIDE(B3, C7)
C. =B3 \ C7
D. B3 ÷ C7
🟢 Correct Answer: A. =B3/C7
🔴 Explanation: The forward slash (/) is the standard operator for division in spreadsheet formulas. The equals sign
(=) must precede the formula to indicate a calculation is being performed.
3. Which of the following best describes a relative cell reference?
A. A reference that remains constant when a formula is copied to a new location
B. A reference that adjusts its cell address based on the position to which the formula is copied
C. A reference that only works correctly when used in the same row
D. A reference that is indicated by the use of dollar signs ($)
🟢 Correct Answer: B. A reference that adjusts its cell address based on the position to which the formula is copied
, 🔴 Explanation: Relative references are the default in spreadsheets. When a formula containing a relative reference
is copied, the reference changes relative to the new location of the formula. For example, copying a formula with
=A1+B1 down one row will change to =A2+B2.
4. A financial analyst needs to sum the values in cells A1 through A10, but only if the corresponding value in
column B is greater than 100. Which function is most appropriate?
A. SUMIF
B. SUMIFS
C. SUM
D. COUNTIF
🟢 Correct Answer: A. SUMIF
🔴 Explanation: The SUMIF function is designed to sum a range of cells based on a single condition. The condition is
that cells in a specified range (B1:B10) meet a criterion (greater than 100), and it sums the corresponding cells in the
sum range (A1:A10).
5. What is the primary ethical concern associated with using data from a customer database for a marketing
analysis that was not explicitly consented to for that purpose?
A. Data degradation
B. Data security
QUESTIONS AND ANSWERS | VERIFIED AND WELL DETAILED ANSWERS | PLUS RATIONALES | DOWNLOAD AND
PASS | LATEST EXAM UPDATE 2026/2027
Core Domains
1. Spreadsheet Fundamentals and Navigation
2. Data Entry, Formatting, and Validation
3. Formulas, Functions, and Logical Operations
4. Data Analysis and Visualization Techniques
5. Chart Creation and Interpretation
6. Data Management, Sorting, and Filtering
7. Professional Presentation and Reporting
8. Ethical Use of Data and Regulatory Compliance (e.g., GDPR, HIPAA)
9. Collaboration, Review, and Security Features
10. Scenario-Based Decision Making and Troubleshooting
Introduction
This comprehensive examination is designed to rigorously assess your mastery of the core principles and practical
applications of spreadsheets and data presentations as defined by the WGU D388 curriculum. It evaluates your
,foundational knowledge of spreadsheet navigation, data manipulation, and the creation of compelling visual
narratives. The assessment employs a combination of direct multiple-choice questions and complex, scenario-based
problems that require you to apply your skills to realistic professional contexts. You will be expected to demonstrate not
only technical proficiency in using functions and charts but also the critical thinking necessary for ethical data
handling, compliance, and effective decision-making. Success on this exam signifies your readiness to leverage data as
a strategic asset in any modern business environment.
Section One: Questions 1–50
1. What is the primary purpose of the "Name Box" in a spreadsheet application?
A. To display the formula contained within the active cell
B. To provide a search function for finding specific data within the worksheet
C. To display the reference of the active cell or the defined name of a selected range
D. To insert a new comment into the active cell
🟢 Correct Answer: C. To display the reference of the active cell or the defined name of a selected range
🔴 Explanation: The Name Box is located to the left of the formula bar and its main function is to show the address
(e.g., A1, B2) of the currently selected cell or the name of a selected range if one has been defined.
,2. When creating a formula in Excel that divides the value in cell B3 by the value in cell C7, what is the correct
syntax?
A. =B3/C7
B. =DIVIDE(B3, C7)
C. =B3 \ C7
D. B3 ÷ C7
🟢 Correct Answer: A. =B3/C7
🔴 Explanation: The forward slash (/) is the standard operator for division in spreadsheet formulas. The equals sign
(=) must precede the formula to indicate a calculation is being performed.
3. Which of the following best describes a relative cell reference?
A. A reference that remains constant when a formula is copied to a new location
B. A reference that adjusts its cell address based on the position to which the formula is copied
C. A reference that only works correctly when used in the same row
D. A reference that is indicated by the use of dollar signs ($)
🟢 Correct Answer: B. A reference that adjusts its cell address based on the position to which the formula is copied
, 🔴 Explanation: Relative references are the default in spreadsheets. When a formula containing a relative reference
is copied, the reference changes relative to the new location of the formula. For example, copying a formula with
=A1+B1 down one row will change to =A2+B2.
4. A financial analyst needs to sum the values in cells A1 through A10, but only if the corresponding value in
column B is greater than 100. Which function is most appropriate?
A. SUMIF
B. SUMIFS
C. SUM
D. COUNTIF
🟢 Correct Answer: A. SUMIF
🔴 Explanation: The SUMIF function is designed to sum a range of cells based on a single condition. The condition is
that cells in a specified range (B1:B10) meet a criterion (greater than 100), and it sums the corresponding cells in the
sum range (A1:A10).
5. What is the primary ethical concern associated with using data from a customer database for a marketing
analysis that was not explicitly consented to for that purpose?
A. Data degradation
B. Data security
