1
WGU D388 Fundamentals of Spreadsheets
and Data Presentations OA Review Official
Practice Exam Actual Exam 2026/2027 with
Detailed Rationales | Complete Exam-Style
Questions | Pass Guaranteed – A+ Graded
TABLE OF CONTENTS
Section 1 | Excel Fundamentals & Workbook Management | Q1 – Q10
Section 2 | Cell Referencing, Formulas & Functions | Q11 – Q20
Section 3 | Data Formatting & Presentation | Q21 – Q30
Section 4 | Data Analysis & PivotTables | Q31 – Q40
Section 5 | NGN-Style Integrated Case Analysis | Q41 – Q50
Instructions: Choose the single best answer. Pass: 40 in 90 minutes.
══════════════════════════════════════
SECTION 1: EXCEL FUNDAMENTALS & WORKBOOK MANAGEMENT
Q1 – Q10
══════════════════════════════════════
Question 1 of 50
A new administrative assistant at a healthcare clinic is organizing patient
appointment data. The supervisor asks the assistant to create a single Excel file that
will contain separate tabs for each month of the year. The assistant needs to
understand the relationship between the overall file and the individual monthly tabs
before beginning the project.
A. The overall file is a worksheet, and each monthly tab is a workbook.
B. The overall file is a cell, and each monthly tab is a value.
,2
C. The overall file is a workbook, and each monthly tab is a worksheet. ✓
CORRECT
D. The overall file is a column, and each monthly tab is a row.
Correct Answer: C
Rationale: A workbook is an Excel file that stores all information and can contain
one or more worksheets, which are the individual tabs where data is entered and
organized. Choice A reverses these definitions, which is a common trap for
students new to Excel. In professional settings, understanding this hierarchy is
essential because formulas and formatting often span multiple worksheets within
the same workbook.
Question 2 of 50
A financial analyst needs to adjust the page orientation and margins before printing
a quarterly budget report. The analyst remembers that Excel organizes commands
into related groups on the ribbon, but cannot recall which tab contains the page
setup options.
A. The Home tab
B. The Page Layout tab ✓ CORRECT
C. The Review tab
D. The View tab
Correct Answer: B
Rationale: The Page Layout tab on the ribbon contains the Page Setup group,
which includes commands for orientation, margins, paper size, and print area.
Choice A is incorrect because the Home tab focuses on formatting tools like font,
alignment, and number formats rather than print layout settings. Knowing where
page setup commands live saves time and prevents last-minute formatting issues
before presenting reports to stakeholders.
Question 3 of 50
A data entry specialist is entering a complex formula into cell D15 and notices that
the formula appears both inside the cell and in a long bar at the top of the
worksheet. The specialist wants to edit the formula directly in that top bar to avoid
accidentally clicking another cell.
,3
A. The Name Box
B. The Status Bar
C. The Formula Bar ✓ CORRECT
D. The Quick Access Toolbar
Correct Answer: C
Rationale: The Formula Bar is the horizontal area located above the worksheet grid
that displays the contents of the active cell and allows direct editing of formulas
and values. Choice A is incorrect because the Name Box displays the cell reference
or range name and is not used for editing cell content. Using the Formula Bar is a
best practice when working with long or nested formulas because it provides more
space and prevents unintended cell selection.
Question 4 of 50
An inventory manager writes the formula =5+3*2^2 into cell B4 to calculate a
storage fee. The manager expects the result to be 32 but Excel returns a different
value.
A. 11
B. 22
C. 64
D. 17 ✓ CORRECT
Correct Answer: D
Rationale: Excel follows the standard order of operations (PEMDAS), so it first
calculates the exponent 2^2 = 4, then performs multiplication 3*4 = 12, and finally
adds 5+12 = 17. Choice B is incorrect because it suggests left-to-right calculation
without respecting operator precedence, which is a common misconception among
new Excel users. Always use parentheses to control calculation order explicitly
when building business-critical formulas.
Question 5 of 50
A training coordinator is developing a handout for new employees that identifies
the key components of the Excel interface. The coordinator asks the employees to
, 4
select all statements that accurately describe fundamental Excel elements. (Select
all that apply.)
A. "A workbook is an Excel file that stores all information, calculations, and
analyses, and it contains at least one worksheet." and "A column is a vertical stack
of cells labeled with a letter, while a row is a horizontal collection of cells labeled
with a number." ✓ CORRECT
B. "A cell is the entire grid of rows and columns, and a worksheet is the individual
box that stores data."
C. "The ribbon contains only the File and Home tabs, and all other commands are
found in the formula bar."
D. "A value is the label at the top of a column, and the formula bar is used only to
display the current date."
Correct Answer: A
Rationale: A workbook is indeed an Excel file containing one or more worksheets,
and columns are vertical while rows are horizontal, making both statements in
choice A accurate. Choice B reverses the definitions of cell and worksheet, which
is a frequent exam trap. Understanding these foundational terms is critical because
every advanced Excel skill builds on this basic vocabulary.
Question 6 of 50
A sales manager is building a tracking sheet and needs to reference the cell located
at the intersection of column E and row 12. The manager wants to confirm the
correct cell reference notation before writing a formula that pulls data from that
location.
A. 12E
B. E12 ✓ CORRECT
C. E:12
D. 12:E
Correct Answer: B
Rationale: Excel references cells by listing the column letter first followed by the
row number, so the intersection of column E and row 12 is E12. Choice A reverses
WGU D388 Fundamentals of Spreadsheets
and Data Presentations OA Review Official
Practice Exam Actual Exam 2026/2027 with
Detailed Rationales | Complete Exam-Style
Questions | Pass Guaranteed – A+ Graded
TABLE OF CONTENTS
Section 1 | Excel Fundamentals & Workbook Management | Q1 – Q10
Section 2 | Cell Referencing, Formulas & Functions | Q11 – Q20
Section 3 | Data Formatting & Presentation | Q21 – Q30
Section 4 | Data Analysis & PivotTables | Q31 – Q40
Section 5 | NGN-Style Integrated Case Analysis | Q41 – Q50
Instructions: Choose the single best answer. Pass: 40 in 90 minutes.
══════════════════════════════════════
SECTION 1: EXCEL FUNDAMENTALS & WORKBOOK MANAGEMENT
Q1 – Q10
══════════════════════════════════════
Question 1 of 50
A new administrative assistant at a healthcare clinic is organizing patient
appointment data. The supervisor asks the assistant to create a single Excel file that
will contain separate tabs for each month of the year. The assistant needs to
understand the relationship between the overall file and the individual monthly tabs
before beginning the project.
A. The overall file is a worksheet, and each monthly tab is a workbook.
B. The overall file is a cell, and each monthly tab is a value.
,2
C. The overall file is a workbook, and each monthly tab is a worksheet. ✓
CORRECT
D. The overall file is a column, and each monthly tab is a row.
Correct Answer: C
Rationale: A workbook is an Excel file that stores all information and can contain
one or more worksheets, which are the individual tabs where data is entered and
organized. Choice A reverses these definitions, which is a common trap for
students new to Excel. In professional settings, understanding this hierarchy is
essential because formulas and formatting often span multiple worksheets within
the same workbook.
Question 2 of 50
A financial analyst needs to adjust the page orientation and margins before printing
a quarterly budget report. The analyst remembers that Excel organizes commands
into related groups on the ribbon, but cannot recall which tab contains the page
setup options.
A. The Home tab
B. The Page Layout tab ✓ CORRECT
C. The Review tab
D. The View tab
Correct Answer: B
Rationale: The Page Layout tab on the ribbon contains the Page Setup group,
which includes commands for orientation, margins, paper size, and print area.
Choice A is incorrect because the Home tab focuses on formatting tools like font,
alignment, and number formats rather than print layout settings. Knowing where
page setup commands live saves time and prevents last-minute formatting issues
before presenting reports to stakeholders.
Question 3 of 50
A data entry specialist is entering a complex formula into cell D15 and notices that
the formula appears both inside the cell and in a long bar at the top of the
worksheet. The specialist wants to edit the formula directly in that top bar to avoid
accidentally clicking another cell.
,3
A. The Name Box
B. The Status Bar
C. The Formula Bar ✓ CORRECT
D. The Quick Access Toolbar
Correct Answer: C
Rationale: The Formula Bar is the horizontal area located above the worksheet grid
that displays the contents of the active cell and allows direct editing of formulas
and values. Choice A is incorrect because the Name Box displays the cell reference
or range name and is not used for editing cell content. Using the Formula Bar is a
best practice when working with long or nested formulas because it provides more
space and prevents unintended cell selection.
Question 4 of 50
An inventory manager writes the formula =5+3*2^2 into cell B4 to calculate a
storage fee. The manager expects the result to be 32 but Excel returns a different
value.
A. 11
B. 22
C. 64
D. 17 ✓ CORRECT
Correct Answer: D
Rationale: Excel follows the standard order of operations (PEMDAS), so it first
calculates the exponent 2^2 = 4, then performs multiplication 3*4 = 12, and finally
adds 5+12 = 17. Choice B is incorrect because it suggests left-to-right calculation
without respecting operator precedence, which is a common misconception among
new Excel users. Always use parentheses to control calculation order explicitly
when building business-critical formulas.
Question 5 of 50
A training coordinator is developing a handout for new employees that identifies
the key components of the Excel interface. The coordinator asks the employees to
, 4
select all statements that accurately describe fundamental Excel elements. (Select
all that apply.)
A. "A workbook is an Excel file that stores all information, calculations, and
analyses, and it contains at least one worksheet." and "A column is a vertical stack
of cells labeled with a letter, while a row is a horizontal collection of cells labeled
with a number." ✓ CORRECT
B. "A cell is the entire grid of rows and columns, and a worksheet is the individual
box that stores data."
C. "The ribbon contains only the File and Home tabs, and all other commands are
found in the formula bar."
D. "A value is the label at the top of a column, and the formula bar is used only to
display the current date."
Correct Answer: A
Rationale: A workbook is indeed an Excel file containing one or more worksheets,
and columns are vertical while rows are horizontal, making both statements in
choice A accurate. Choice B reverses the definitions of cell and worksheet, which
is a frequent exam trap. Understanding these foundational terms is critical because
every advanced Excel skill builds on this basic vocabulary.
Question 6 of 50
A sales manager is building a tracking sheet and needs to reference the cell located
at the intersection of column E and row 12. The manager wants to confirm the
correct cell reference notation before writing a formula that pulls data from that
location.
A. 12E
B. E12 ✓ CORRECT
C. E:12
D. 12:E
Correct Answer: B
Rationale: Excel references cells by listing the column letter first followed by the
row number, so the intersection of column E and row 12 is E12. Choice A reverses
