15 questions
Points to a specific cell and does not change when copied and includes dollar signs in the reference name
Absolute cell reference
comparison operator
Data source
Filtering
Address of a cell indicating its column and row location
Cell References
Data series
Sorting
Spreadsheet
Applies formatting only when a cell's value meets a specified criterion
Absolute cell reference
Conditional format
Filtering
Spreadsheet
Range of values which is plotted as a single unit on the chart
Conditional format
Data series
Data source
Function
Range which contains the data selected to display in the chart
Comparison operator
Data series
Data source
Worksheet
Displays only data which meets certain criteria
Conditional format
Filtering
Logical function
Workbook
Expression which returns a value
Cell references
Filtering
Formula
Function
Named operation which returns a value
Formula
Function
Spreadsheet
Workbook
Grid of rows and columns in which text and numbers are entered and results are calculated
Function
Spreadsheet
Workbook
Worksheets
File used to store worksheets
Function
Spreadsheet
Workbook
Worksheets
Sheets containing formulas, functions, values, text and graphics which make up a workbook
Formulas
Spreadsheets
Workbooks
Worksheets
Contains all of the commands you will need to perform common tasks in Excel. It has multiple tabs, each with several groups of commands.
Ribbon
Column
Row
Group
Each rectangle in a workbook and the intersection of a row and a column.
The ribbon
Column
Cell
Row
Group of cells that runs from the left of the page to the right.
Row
Column
Cell
Ribbon
Group of cells that runs from the stop of the page to the bottom.
Row
Column
Cell
Ribbon