WGU D388 – FUNDAMENTALS OF
SPREADSHEETS & DATA
PRESENTATIONS OA FINAL TEST 2026
QUESTIONS WITH CORRECT ANSWERS
GRADED A+
◍ year function.
Answer: calculates the year element of a date. For example
=YEAR(1/1/2022) would return 2022
◍ The style or design of letters, numbers, or other symbols.
Answer: Font face
◍ An Excel tool that finds values and replaces them with other specified
values.
Answer: Find and Replace
◍ The content within a cell..
Answer: Value
◍ To approximate the birthdate from the age.
Answer: subtract the approximate number of days a dog has been alive (its
age times 365) from the current date (which is calculated using the
TODAY() function)
◍ A feature that allows users to limit the number of visible rows in a
worksheet.
Answer: Filtering
◍ Layout.
Answer: describes where the data will be used in the chart
, ◍ A collection of cells arranged in the form of a table that contains the actual
data and calculations..
Answer: Worksheet
◍ paste values.
Answer: this only copies over the value not the format of the previous cell.
so if one cell has a currency data cell with $25.00 as its data, it will only
copy 25.
◍ When data sets in a chart are compared to each other. Example, if a chart
contains blue and orange, vertical columns, the height of both colored bars
can be compared to each other..
Answer: Inter-category comparison
◍ A bar located beneath the toolbar in an Excel worksheet, where the user can
add or edit the contents of a cell.
Answer: Formula bar
◍ A formula that produces a consistent value.
Answer: Static
◍ A consecutive block of cells, arranged in a row, a column, or a combination
of both. For example, A1:B3 is the range of cells that includes A1, A2, A3,
B1, B2, and B3..
Answer: Range
◍ Aligning values in the center of a cell.
Answer: Centering
◍ The function that displays the largest cell value in a data set.
Answer: Max
◍ Formatting.
Answer: Changing the appearance of the data ana cells in a worksheet
◍ COUNTA.
Answer: By contrast, the ______function differentiates between blank cells
and those with any type of data. The ________function returns the number
SPREADSHEETS & DATA
PRESENTATIONS OA FINAL TEST 2026
QUESTIONS WITH CORRECT ANSWERS
GRADED A+
◍ year function.
Answer: calculates the year element of a date. For example
=YEAR(1/1/2022) would return 2022
◍ The style or design of letters, numbers, or other symbols.
Answer: Font face
◍ An Excel tool that finds values and replaces them with other specified
values.
Answer: Find and Replace
◍ The content within a cell..
Answer: Value
◍ To approximate the birthdate from the age.
Answer: subtract the approximate number of days a dog has been alive (its
age times 365) from the current date (which is calculated using the
TODAY() function)
◍ A feature that allows users to limit the number of visible rows in a
worksheet.
Answer: Filtering
◍ Layout.
Answer: describes where the data will be used in the chart
, ◍ A collection of cells arranged in the form of a table that contains the actual
data and calculations..
Answer: Worksheet
◍ paste values.
Answer: this only copies over the value not the format of the previous cell.
so if one cell has a currency data cell with $25.00 as its data, it will only
copy 25.
◍ When data sets in a chart are compared to each other. Example, if a chart
contains blue and orange, vertical columns, the height of both colored bars
can be compared to each other..
Answer: Inter-category comparison
◍ A bar located beneath the toolbar in an Excel worksheet, where the user can
add or edit the contents of a cell.
Answer: Formula bar
◍ A formula that produces a consistent value.
Answer: Static
◍ A consecutive block of cells, arranged in a row, a column, or a combination
of both. For example, A1:B3 is the range of cells that includes A1, A2, A3,
B1, B2, and B3..
Answer: Range
◍ Aligning values in the center of a cell.
Answer: Centering
◍ The function that displays the largest cell value in a data set.
Answer: Max
◍ Formatting.
Answer: Changing the appearance of the data ana cells in a worksheet
◍ COUNTA.
Answer: By contrast, the ______function differentiates between blank cells
and those with any type of data. The ________function returns the number
