WGU D388 - Fundamentals of
Spreadsheets and Data Presentations
Insert - CORRECT ANSWER-Group of menu items that includes features for
specializing elements into workbooks, such as charts, pictures, and shapes
Draw - CORRECT ANSWER-Group of menu items used to insert freehand
sketches into worksheets
Page layout - CORRECT ANSWER-Group of menu items used to format the
appearance of worksheets when they are printed
Formulas - CORRECT ANSWER-Group of menu items used to perform
calculations using excels built in functions
Data - CORRECT ANSWER-Group of menu items used to aid in importing and
working with data
Review - CORRECT ANSWER-Group of menu items that help in sharing an excel
workbook with colleagues
View - CORRECT ANSWER-Group of menu items that are used to change how a
worksheet is displayed on the screen
Help - CORRECT ANSWER-Group of menu items that are used to obtain
assistance on spreadsheet features
Zoom - CORRECT ANSWER-Group of menu options that allows the user to
change how much of the worksheet appears in the window
Window - CORRECT ANSWER-View of the current workbook
Pane - CORRECT ANSWER-The area of a worksheet that is visible on the screen
Show - CORRECT ANSWER-The options that determine whether gridlines, column
letters, and row numbers are visible in the worksheet
Title bar - CORRECT ANSWER-The bar located at the top of an Excel worksheet. It
displays the name of the application and the name of the spreadsheet.
Tool bar - CORRECT ANSWER-The bar located below the title bar. Provides
access to tools commonly associated with task performed in an Excel workbook.
, Formula bar - CORRECT ANSWER-A bar located beneath the toolbar in an Excel
worksheet, where the user can add or edit the contents of a cell
Insert function icon - CORRECT ANSWER-The "fx" symbol located to the left of the
formula bar. Users can click on the symbol and select built-in calculations that
can be applied to data.
Formatting - CORRECT ANSWER-Changing the appearance of the data and cells in
a worksheet
Range - CORRECT ANSWER-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.
Workbook - CORRECT 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 - CORRECT ANSWER-A collection of cells arranged in the form of a
table that contains the actual data and calculations.
Cell - CORRECT ANSWER-Small box that stores an individual piece of data or a
calculation in a worksheet
Value - CORRECT ANSWER-The content within a cell.
Column - CORRECT ANSWER-A stack of cells arranged vertically from the top to
the bottom of a worksheet - labeled with a letter.
Row - CORRECT ANSWER-Collection of cells arranged horizontally from left to
right of a worksheet- labeled with a number of
Function - CORRECT ANSWER-Built in method for performing a calculation in
excel
File - CORRECT ANSWER-A group of menu items used to manipulate workbooks
Home - CORRECT ANSWER-A group of menu items used to format the
appearance of data in cells
Font face - CORRECT ANSWER-The style or design of letters, numbers, or other
symbols
Font size -
Spreadsheets and Data Presentations
Insert - CORRECT ANSWER-Group of menu items that includes features for
specializing elements into workbooks, such as charts, pictures, and shapes
Draw - CORRECT ANSWER-Group of menu items used to insert freehand
sketches into worksheets
Page layout - CORRECT ANSWER-Group of menu items used to format the
appearance of worksheets when they are printed
Formulas - CORRECT ANSWER-Group of menu items used to perform
calculations using excels built in functions
Data - CORRECT ANSWER-Group of menu items used to aid in importing and
working with data
Review - CORRECT ANSWER-Group of menu items that help in sharing an excel
workbook with colleagues
View - CORRECT ANSWER-Group of menu items that are used to change how a
worksheet is displayed on the screen
Help - CORRECT ANSWER-Group of menu items that are used to obtain
assistance on spreadsheet features
Zoom - CORRECT ANSWER-Group of menu options that allows the user to
change how much of the worksheet appears in the window
Window - CORRECT ANSWER-View of the current workbook
Pane - CORRECT ANSWER-The area of a worksheet that is visible on the screen
Show - CORRECT ANSWER-The options that determine whether gridlines, column
letters, and row numbers are visible in the worksheet
Title bar - CORRECT ANSWER-The bar located at the top of an Excel worksheet. It
displays the name of the application and the name of the spreadsheet.
Tool bar - CORRECT ANSWER-The bar located below the title bar. Provides
access to tools commonly associated with task performed in an Excel workbook.
, Formula bar - CORRECT ANSWER-A bar located beneath the toolbar in an Excel
worksheet, where the user can add or edit the contents of a cell
Insert function icon - CORRECT ANSWER-The "fx" symbol located to the left of the
formula bar. Users can click on the symbol and select built-in calculations that
can be applied to data.
Formatting - CORRECT ANSWER-Changing the appearance of the data and cells in
a worksheet
Range - CORRECT ANSWER-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.
Workbook - CORRECT 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 - CORRECT ANSWER-A collection of cells arranged in the form of a
table that contains the actual data and calculations.
Cell - CORRECT ANSWER-Small box that stores an individual piece of data or a
calculation in a worksheet
Value - CORRECT ANSWER-The content within a cell.
Column - CORRECT ANSWER-A stack of cells arranged vertically from the top to
the bottom of a worksheet - labeled with a letter.
Row - CORRECT ANSWER-Collection of cells arranged horizontally from left to
right of a worksheet- labeled with a number of
Function - CORRECT ANSWER-Built in method for performing a calculation in
excel
File - CORRECT ANSWER-A group of menu items used to manipulate workbooks
Home - CORRECT ANSWER-A group of menu items used to format the
appearance of data in cells
Font face - CORRECT ANSWER-The style or design of letters, numbers, or other
symbols
Font size -
