1|P a g e
WGU D388 FUNDAMENTALS OF
SPREADSHEETS AND DATA
PRESENTATIONS OA EXAM (2025)
QUESTIONS AND (ELABORATED) WITH
COMPLETE SOLUTIONS
Workbook - ✔✔ANSWER✔✔-An excel file that stores all the information,
previous calculations, and analyses that you may have already completed.
Must contain atleast one worksheet.
Gridlines - ✔✔ANSWER✔✔-The horizontal lines that correspond with each
value on the vertical axis of a chart
Data labels - ✔✔ANSWER✔✔-The actual value of data displayed in a chart or
graph
Legend - ✔✔ANSWER✔✔-A visual key that describes the data series used on a
chart and the colored elements that represent those series
Intra-category comparison - ✔✔ANSWER✔✔-When a category of data in a
chart is compared to itself. Example, if a chart contains blue and orange,
vertical columns, the blue columns can be compared to learn more about the
trend of the date of represented by the blue columns.
, 2|P a g e
Worksheet - ✔✔ANSWER✔✔-A collection of cells arranged in the form of a
table that contains the actual data and calculations.
Cell - ✔✔ANSWER✔✔-Small box that stores an individual piece of data or a
calculation in a worksheet
Value - ✔✔ANSWER✔✔-The content within a cell.
Column - ✔✔ANSWER✔✔-A stack of cells arranged vertically from the top to
the bottom of a worksheet - labeled with a letter.
Row - ✔✔ANSWER✔✔-Collection of cells arranged horizontally from left to
right of a worksheet- labeled with a number of
Function - ✔✔ANSWER✔✔-Built in method for performing a calculation in
excel
File - ✔✔ANSWER✔✔-A group of menu items used to manipulate workbooks
Home - ✔✔ANSWER✔✔-A group of menu items used to format the
appearance of data in cells
Insert - ✔✔ANSWER✔✔-Group of menu items that includes features for
specializing elements into workbooks, such as charts, pictures, and shapes
WGU D388 FUNDAMENTALS OF
SPREADSHEETS AND DATA
PRESENTATIONS OA EXAM (2025)
QUESTIONS AND (ELABORATED) WITH
COMPLETE SOLUTIONS
Workbook - ✔✔ANSWER✔✔-An excel file that stores all the information,
previous calculations, and analyses that you may have already completed.
Must contain atleast one worksheet.
Gridlines - ✔✔ANSWER✔✔-The horizontal lines that correspond with each
value on the vertical axis of a chart
Data labels - ✔✔ANSWER✔✔-The actual value of data displayed in a chart or
graph
Legend - ✔✔ANSWER✔✔-A visual key that describes the data series used on a
chart and the colored elements that represent those series
Intra-category comparison - ✔✔ANSWER✔✔-When a category of data in a
chart is compared to itself. Example, if a chart contains blue and orange,
vertical columns, the blue columns can be compared to learn more about the
trend of the date of represented by the blue columns.
, 2|P a g e
Worksheet - ✔✔ANSWER✔✔-A collection of cells arranged in the form of a
table that contains the actual data and calculations.
Cell - ✔✔ANSWER✔✔-Small box that stores an individual piece of data or a
calculation in a worksheet
Value - ✔✔ANSWER✔✔-The content within a cell.
Column - ✔✔ANSWER✔✔-A stack of cells arranged vertically from the top to
the bottom of a worksheet - labeled with a letter.
Row - ✔✔ANSWER✔✔-Collection of cells arranged horizontally from left to
right of a worksheet- labeled with a number of
Function - ✔✔ANSWER✔✔-Built in method for performing a calculation in
excel
File - ✔✔ANSWER✔✔-A group of menu items used to manipulate workbooks
Home - ✔✔ANSWER✔✔-A group of menu items used to format the
appearance of data in cells
Insert - ✔✔ANSWER✔✔-Group of menu items that includes features for
specializing elements into workbooks, such as charts, pictures, and shapes
