WGU D388 – FUNDAMENTALS OF
SPREADSHEETS & DATA
PRESENTATIONS OA COMPREHENSIVE
STUDY GUIDE 2026 FULL QUESTIONS AND
SOLUTIONS GRADED A+
◍ Axis.
Answer: A horizontal or vertical line that establishes the relationship
between data in a chart.
◍ Precedence.
Answer: order of operations
◍ Mixed Cell Reference.
Answer: A cell reference that contains both relative and absolute references.
◍ Accounting.
Answer: An option in the Number Format drop-down menu that defines a
number as money with the appropriate monetary symbol and two decimal
places. The user does not have as many ways to format negative numbers as
the Currency option.
◍ Logical Functions.
Answer: Functions that display text or values if certain conditions exist.
◍ Source.
Answer: The location data is being transferred from.
◍ Resizing.
Answer: Adjusting the width of a cell.
, ◍ Plot Area.
Answer: The graphical representation of all of the data series.
◍ Average.
Answer: A function or PivotTable Value Field setting that displays the
average of the values.
◍ Percentage.
Answer: Number format option representing a value as a percentage.
◍ Mathematical Functions.
Answer: Functions that manipulate quantitative data in a worksheet.
◍ Merge & Center.
Answer: Combines cell and centers content
◍ Cell.
Answer: A small box that stores an individual piece of data or a calculation
in a worksheet.
◍ Years since.
Answer: =YEARFRAC(J27,J21)
◍ Absolute Reference.
Answer: A cell reference that stays fixed when a formula is copied from one
cell to another.
◍ What is the total row used for in an Excel table?.
Answer: Summarize values in the table
◍ Dialog Box.
Answer: A box that opens when you strike a command that allows you to
choose more options.
◍ Relative Cell Reference.
Answer: A cell reference that adjusts to its new location when copied or
moved.
◍ Columns.
SPREADSHEETS & DATA
PRESENTATIONS OA COMPREHENSIVE
STUDY GUIDE 2026 FULL QUESTIONS AND
SOLUTIONS GRADED A+
◍ Axis.
Answer: A horizontal or vertical line that establishes the relationship
between data in a chart.
◍ Precedence.
Answer: order of operations
◍ Mixed Cell Reference.
Answer: A cell reference that contains both relative and absolute references.
◍ Accounting.
Answer: An option in the Number Format drop-down menu that defines a
number as money with the appropriate monetary symbol and two decimal
places. The user does not have as many ways to format negative numbers as
the Currency option.
◍ Logical Functions.
Answer: Functions that display text or values if certain conditions exist.
◍ Source.
Answer: The location data is being transferred from.
◍ Resizing.
Answer: Adjusting the width of a cell.
, ◍ Plot Area.
Answer: The graphical representation of all of the data series.
◍ Average.
Answer: A function or PivotTable Value Field setting that displays the
average of the values.
◍ Percentage.
Answer: Number format option representing a value as a percentage.
◍ Mathematical Functions.
Answer: Functions that manipulate quantitative data in a worksheet.
◍ Merge & Center.
Answer: Combines cell and centers content
◍ Cell.
Answer: A small box that stores an individual piece of data or a calculation
in a worksheet.
◍ Years since.
Answer: =YEARFRAC(J27,J21)
◍ Absolute Reference.
Answer: A cell reference that stays fixed when a formula is copied from one
cell to another.
◍ What is the total row used for in an Excel table?.
Answer: Summarize values in the table
◍ Dialog Box.
Answer: A box that opens when you strike a command that allows you to
choose more options.
◍ Relative Cell Reference.
Answer: A cell reference that adjusts to its new location when copied or
moved.
◍ Columns.
