WGU D388 - Fundamentals of Spreadsheets and Data
Presentations
1. An excel file that stores all the information, previous
calculations, and analyses that you may have already completed.
Must contain at least one worksheet.
Ans: Workbook
2. A collection of cells arranged in the form of a table that
contains the actual data and calculations.
Ans: Worksheet
3. Small box that stores an individual piece of data or a
calculation in a worksheet.
Ans: Cell
4. The content within a cell.
Ans: Value
5. A stack of cells arranged vertically from the top to the bottom
of a worksheet - labeled with a letter.
Ans: Column
6. Collection of cells arranged horizontally from left to right of a
worksheet labeled with a number of
Ans: Row
7. Built in method for performing a calculation in excel
Ans: Function
8. A group of menu items used to manipulate workbooks
Ans: File
, 9. A group of menu items used to format the appearance of data
in cells
Ans: Home
10. Group of menu items that includes features for specializing
elements into workbooks, such as charts, pictures, and shapes
Ans: Insert
11. Group of menu items used to insert freehand sketches into
worksheets
Ans: Draw
12. Group of menu items used to format the appearance of
worksheets when they are printed
Ans: Page layout
13. Group of menu items used to perform calculations using
excels built in functions
Ans: Formulas
14. Group of menu items used to aid in importing and working
with data
Ans: Data
15. Group of menu items that help in sharing an excel workbook
with colleagues
Ans: Review
16. Group of menu items that are used to change how a
worksheet is displayed on the screen
Ans: View
17. Group of menu items that are used to obtain assistance on
spreadsheet features
Presentations
1. An excel file that stores all the information, previous
calculations, and analyses that you may have already completed.
Must contain at least one worksheet.
Ans: Workbook
2. A collection of cells arranged in the form of a table that
contains the actual data and calculations.
Ans: Worksheet
3. Small box that stores an individual piece of data or a
calculation in a worksheet.
Ans: Cell
4. The content within a cell.
Ans: Value
5. A stack of cells arranged vertically from the top to the bottom
of a worksheet - labeled with a letter.
Ans: Column
6. Collection of cells arranged horizontally from left to right of a
worksheet labeled with a number of
Ans: Row
7. Built in method for performing a calculation in excel
Ans: Function
8. A group of menu items used to manipulate workbooks
Ans: File
, 9. A group of menu items used to format the appearance of data
in cells
Ans: Home
10. Group of menu items that includes features for specializing
elements into workbooks, such as charts, pictures, and shapes
Ans: Insert
11. Group of menu items used to insert freehand sketches into
worksheets
Ans: Draw
12. Group of menu items used to format the appearance of
worksheets when they are printed
Ans: Page layout
13. Group of menu items used to perform calculations using
excels built in functions
Ans: Formulas
14. Group of menu items used to aid in importing and working
with data
Ans: Data
15. Group of menu items that help in sharing an excel workbook
with colleagues
Ans: Review
16. Group of menu items that are used to change how a
worksheet is displayed on the screen
Ans: View
17. Group of menu items that are used to obtain assistance on
spreadsheet features