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.
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
Draw - (ANSWER)Group of menu items used to insert freehand sketches into
worksheets
Page layout - (ANSWER)Group of menu items used to format the appearance of
worksheets when they are printed
Formulas - (ANSWER)Group of menu items used to perform calculations using
excels built in functions
Data - (ANSWER)Group of menu items used to aid in importing and working with
data
Review - (ANSWER)Group of menu items that help in sharing an excel workbook
with colleagues
View - (ANSWER)Group of menu items that are used to change how a worksheet
is displayed on the screen
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.
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
Draw - (ANSWER)Group of menu items used to insert freehand sketches into
worksheets
Page layout - (ANSWER)Group of menu items used to format the appearance of
worksheets when they are printed
Formulas - (ANSWER)Group of menu items used to perform calculations using
excels built in functions
Data - (ANSWER)Group of menu items used to aid in importing and working with
data
Review - (ANSWER)Group of menu items that help in sharing an excel workbook
with colleagues
View - (ANSWER)Group of menu items that are used to change how a worksheet
is displayed on the screen