Formulas
This operator is used to start a formula
Equals sign
A cell or range in a formula that uses both a relative and absolute reference
Mixed reference
A single cell or group of cells in an Excel worksheet with a designated name
Named Range
The group in which function commands are found.
Function Library
The COUNTBLANK function counts the number of these
Blank cells
This command displays all formulas in a worksheet
Show Formulas
Identifies a cells location within a worksheet
Cell reference
This symbol is used to separate a worksheet reference and a cell reference
Exclamation point
A prebuilt command in Excel that performs mathematical operations such as automatically adding up a range of cells or looking up values to be used in calculations
Function
This function indicates how many cells contain a numeric value
COUNT
Parts of a formula with these around them will be calculated first
Parentheses
This box shows the name of the selected cell
Name Box
A function that adds together the contents of a range
This function counts all nonblank cell entries in a range
COUNTA
This is a number or text value that is entered directly into a formula.
Constant
A cell reference in a formula that refers to a specific cell or range regardless of where the formula is located in the worksheet
Absolute reference
This command renames the selected cell or range
Define Name
The function that calculates the sum of a range and divides the sum by the number of cells in the range
Average
If a range contains cells 32 cells but only cells A1, B3, B4, B6 contain data, what would the COUNTA function for this range equal?
4
The standard mathematical rules that Excel uses when calculating a formula
Order of operations (PEMDAS)
$A7
Mixed reference
This dialogue box allows you to see and edit all cells in a workbook
Name Manager
This symbol separates the name of the function and the contents of the function
Parentheses
This category of the function library contains the count functions
Statistical