The values and other inputs that function uses to calculate the result
What is Argument
100
Data arranged in columns and specially formatted with column headers that contain commands that allow you to sort, filter, and perform other functions on the table
What is Excel Table
100
A sort of equation that returns a value, such as TRUE or FALSE.
What is Expression
100
A method of applying conditional formatting based on how cell contents compare with a specified criterion such as a Less Than comparison
What is highlight cells rules
100
The selected worksheet
What is active sheet tab
200
A feature that temporarily performs the following calculations on a range of cells without the user having to enter a formula
What is auto calculate
200
Arrange the rows in a table or list of data in a new order according to the entries in one or more columns
What is sort
200
Using a function as an argument within another function
What is nesting
200
Conditional formatting rules that format the highest or lowest values in the formatted range or those that are above or below average
What is top/bottom rules
200
worksheets that are selected as a unit: any action performed on this unit will affect all the worksheets in the group
What is grouping
300
A predefined formula that performs a specific calculation using the inputs you specify.
What is function
300
A row you can display below a table to calculate data in the columns above using a function you choose.
What is Total row
300
A method to keep specified rows and columns in view when scrolling through a worksheet
What is freeze
300
To change the angle of the contents of a cell
What is rotate
300
row and colum labels that reprint on each page of a printout
What is print titles
400
To use a function as an argument within another function
What is function
400
The box at the far-left end of the formula bar that you can use to create and navigate to named ranges
What is name box
400
Sections or areas in a window that enable you to see different parts of the worksheet at the same time.
What is panes
400
The setting that determines whether the worksheet will be printed with the paper in a portrait or landscape format
What is orientation
400
A built in calculation used to add a range of values together
What is SUM function
500
The name given to one of Excel's predefined formulas
What is Function name
500
A function that updates and displays a new result each time you open the workbook
What is volatile
500
A type of conditional formatting that applies a background fill color that varies depending on te relative value stored in each of the formatted cells
What is color scales
500
Reducing or enlarging worksheet information to fit on a specified number of pages
What is scaling
500
The feature that enables Excel to create a series automatically