WGU D388 – FUNDAMENTALS OF
SPREADSHEETS & DATA
PRESENTATIONS OA CERTIFICATION
SCRIPT 2026 QUESTIONS WITH SOLUTIONS
GRADED A+
◍ The values for years classify the data according to when the sales occurred.
What would these values be considered on a
chart?measurescategoriesclassificationsportions.
Answer: categories
◍ page layout menu.
Answer: used to format the appearance of worksheets when they are printed
◍ What do the numbers displayed in a chart
represent?groupscategoriesmeasuresclassifications.
Answer: measures
◍ Algorithm.
Answer: The part of a calculation that is applied to the measure. Example:
average gas price.
◍ Quantitative.
Answer: Numerical data, generally used as the basis for calculations
◍ Arguments.
Answer: The information inputted to create a function
◍ Static.
Answer: A formula that produces a consistent value (for example, =1+1 will
always yield 2)
, ◍ help menu.
Answer: used to obtain assistance on spreadsheet features (such as help
pages, contact customer support, leave feedback, and keyboard shortcuts)
◍ 4 main strategies for dealing with missing values in a dataset.
Answer: 1. Leave the missing value as missing.2. Substitute a default
value.3. Substitute an average value.4. Substitute a value based on
information in other columns.
◍ Charts.
Answer: - Depictions of larger data sets which less-related categories- A
visual representation of usually larger sets of data where categories may or
may not be related to each other
◍ workbook.
Answer: an Excel file that stores all the information, previous calculations,
and analyses that you may have already completed; must contain at least one
worksheet
◍ MAX.
Answer: returns the largest value in a set of numbers=MAX(number1,
[number2], ...)
◍ Scatterplot.
Answer: Similar to a line chart in that it depicts points of intersection
between values on the horizontal and vertical axes. It generally replaces
time on the horizontal axis with values of a second variable and may or may
not use a line to connect the points on the chart.
◍ range.
Answer: a consecutive block of cells arranged in a row, column, or a
combination of both. For example: A1:B3 is the range of sells that includes
cells A1, A2, A3, B1, B2, and B3.
◍ Data.
Answer: A class of menu items used to aid in importing and working with
SPREADSHEETS & DATA
PRESENTATIONS OA CERTIFICATION
SCRIPT 2026 QUESTIONS WITH SOLUTIONS
GRADED A+
◍ The values for years classify the data according to when the sales occurred.
What would these values be considered on a
chart?measurescategoriesclassificationsportions.
Answer: categories
◍ page layout menu.
Answer: used to format the appearance of worksheets when they are printed
◍ What do the numbers displayed in a chart
represent?groupscategoriesmeasuresclassifications.
Answer: measures
◍ Algorithm.
Answer: The part of a calculation that is applied to the measure. Example:
average gas price.
◍ Quantitative.
Answer: Numerical data, generally used as the basis for calculations
◍ Arguments.
Answer: The information inputted to create a function
◍ Static.
Answer: A formula that produces a consistent value (for example, =1+1 will
always yield 2)
, ◍ help menu.
Answer: used to obtain assistance on spreadsheet features (such as help
pages, contact customer support, leave feedback, and keyboard shortcuts)
◍ 4 main strategies for dealing with missing values in a dataset.
Answer: 1. Leave the missing value as missing.2. Substitute a default
value.3. Substitute an average value.4. Substitute a value based on
information in other columns.
◍ Charts.
Answer: - Depictions of larger data sets which less-related categories- A
visual representation of usually larger sets of data where categories may or
may not be related to each other
◍ workbook.
Answer: an Excel file that stores all the information, previous calculations,
and analyses that you may have already completed; must contain at least one
worksheet
◍ MAX.
Answer: returns the largest value in a set of numbers=MAX(number1,
[number2], ...)
◍ Scatterplot.
Answer: Similar to a line chart in that it depicts points of intersection
between values on the horizontal and vertical axes. It generally replaces
time on the horizontal axis with values of a second variable and may or may
not use a line to connect the points on the chart.
◍ range.
Answer: a consecutive block of cells arranged in a row, column, or a
combination of both. For example: A1:B3 is the range of sells that includes
cells A1, A2, A3, B1, B2, and B3.
◍ Data.
Answer: A class of menu items used to aid in importing and working with
