Have an account?
Skip to Content
15 questions
Show Answers
See Preview
- Multiple ChoicePlease save your changes before editing any 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
- Multiple ChoicePlease save your changes before editing any questions.
Address of a cell indicating its column and row location
Cell References
Data series
Sorting
Spreadsheet
- Multiple ChoicePlease save your changes before editing any questions.
Applies formatting only when a cell's value meets a specified criterion
Absolute cell reference
Conditional format
Filtering
Spreadsheet
- Multiple ChoicePlease save your changes before editing any questions.
Range of values which is plotted as a single unit on the chart
Conditional format
Data series
Data source
Function
- Multiple ChoicePlease save your changes before editing any questions.
Range which contains the data selected to display in the chart
Comparison operator
Data series
Data source
Worksheet
- Multiple ChoicePlease save your changes before editing any questions.
Displays only data which meets certain criteria
Conditional format
Filtering
Logical function
Workbook
- Multiple ChoicePlease save your changes before editing any questions.
Expression which returns a value
Cell references
Filtering
Formula
Function
- Multiple ChoicePlease save your changes before editing any questions.
Named operation which returns a value
Formula
Function
Spreadsheet
Workbook
- Multiple ChoicePlease save your changes before editing any questions.
Grid of rows and columns in which text and numbers are entered and results are calculated
Function
Spreadsheet
Workbook
Worksheets
- Multiple ChoicePlease save your changes before editing any questions.
File used to store worksheets
Function
Spreadsheet
Workbook
Worksheets
- Multiple ChoicePlease save your changes before editing any questions.
Sheets containing formulas, functions, values, text and graphics which make up a workbook
Formulas
Spreadsheets
Workbooks
Worksheets
- Multiple ChoicePlease save your changes before editing any questions.
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
- Multiple ChoicePlease save your changes before editing any questions.
Each rectangle in a workbook and the intersection of a row and a column.
The ribbon
Column
Cell
Row
- Multiple ChoicePlease save your changes before editing any questions.
Group of cells that runs from the left of the page to the right.
Row
Column
Cell
Ribbon
- Multiple ChoicePlease save your changes before editing any questions.
Group of cells that runs from the stop of the page to the bottom.
Row
Column
Cell
Ribbon