WGU D388 ? Fundamentals of Spreadsheetsand Data
and Data Presentations
Presentations
An excel file that stores all the information, previous calcu-
Workbook lations, and analyses that you may have already complet-
ed. Must contain atleast one worksheet.
A collection of cells arranged in the form of a table that
Worksheet
contains the actual data and calculations.
Small box that stores an individual piece of data or a
Cell
calculation in a worksheet
Value The content within a cell.
A stack of cells arranged vertically from the top to the
Column
bottom of a worksheet - labeled with a letter.
Collection of cells arranged horizontally from left to right
Row
of a worksheet- labeled with a number of
Function Built in method for performing a calculation in excel
File A group of menu items used to manipulate workbooks
A group of menu items used to format the appearance of
Home
data in cells
Group of menu items that includes features for specializ-
Insert ing elements into workbooks, such as charts, pictures, and
shapes
Group of menu items used to insert freehand sketches
Draw
into worksheets
Group of menu items used to format the appearance of
Page layout
worksheets when they are printed
Group of menu items used to perform calculations using
Formulas
excels built in functions
Group of menu items used to aid in importing and work-
Data
ing with data
Review 2025/2026
1/7
, D388 - Fundamentals of Spreadsheets
WGU D388 ? Fundamentals of Spreadsheetsand Data
and Data Presentations
Presentations
Study online at https://quizlet.com/_hvowcz
Group of menu items that help in sharing an excel work-
book with colleagues
Group of menu items that are used to change how a
View
worksheet is displayed on the screen
Group of menu items that are used to obtain assistance
Help
on spreadsheet features
Group of menu options that allows the user to change how
Zoom
much of the worksheet appears in the window
Window View of the current workbook
Pane The area of a worksheet that is visible on the screen
The options that determine whether gridlines, column
Show
letters, and row numbers are visible in the worksheet
The bar located at the top of an Excel worksheet. It displays
Title bar the name of the application and the name of the spread-
sheet.
The bar located below the title bar. Provides access to tools
Tool bar commonly associated with task performed in an Excel
workbook.
A bar located beneath the toolbar in an Excel worksheet,
Formula bar
where the user can add or edit the contents of a cell
The "fx" symbol located to the left of the formula bar. Users
Insert function icon can click on the symbol and select built-in calculations that
can be applied to data.
Changing the appearance of the data and cells in a work-
Formatting
sheet
A consecutive block of cells, arranged in a row, a column,
Range or a combination of both. For example, A1:B3 is the range
of cells that includes A1, A2, A3, B1, B2, and B3.
2025/2026
2/7