This command joins selected cells into one larger cell and then centers the contents.
What is Merge and Center?
100
All Excel formulas begin with this symbol.
What is the equal sign?
100
The Excel function that performs total calculations on values in a spreadsheet.
What is the SUM function?
100
The element of the Excel window that displays the address or reference of the active cell.
What is the Name Box?
100
The address of a cell that is based on the relative position of the cell that contains the formula and the cell referred to in the formula and that also changes when the formula is copied.
What is the Relative Cell Address.
200
The Excel command that allows the user to select one or more rows or columns and lock them.
What is Freeze Panes?
200
The symbol placed between two cell references that indicates a range that includes all the cells between the two cell references.
What is the colon?
200
The function used to find a middle value in a group of data.
What is the median function?
200
The element of the Excel window that displays the underlying value or formula contained in the active cell.
What is formula bar?
200
A prewritten formula that looks at values, performs an operation, and then returns a final value.
What is a function?
300
The command that allows a cell to change appearance based on a criteria.
What is Conditional Formatting?
300
- The small black plus sign in the lower right corner of a selected cell used to copy a formula.
What is the Fill Handle?
300
This function has three arguments— the criteria, the value to return if true, and the value to return if the criteria is not true.
What is the IF function?
300
The element of the Excel spreadsheet formed by the intersection of a row and column.
What is a cell?
300
The cell address that refers to cells by their fixed position in a worksheet and does not change when the formula is copied.
What is the Absolute Cell Address?
400
The Excel command that allow you to specify rows and columns to repeat on each printed page.
What is Print Titles?
400
The symbol displayed when a cell's width is too narrow to properly display the numeric contents of the cell.
What is the (#) pound or number symbol?
400
The function that adds a group of values, and then divides the result by the number of values in the group.
What is the AVERAGE function?
400
The selected cell in an Excel spreadsheet that is surrounded by a black border and ready to receive data.
What is the active cell?
400
The identification of a specific cell by its intersecting column letter and row number.
What is the cell reference?
500
The command that arranges data in a specific order based on the value in each field.
What is sorting?
500
Tiny chart symbols embedded in a cell that give a visual trend summary alongside your data.
What are Sparklines?
500
The function that determines the largest value in a range.
What is MAX function?
500
Each worksheet is identified by the element found along the lower border of the Excel window.
What is a sheet tab?
500
Two or more cells that Excel treats as a single unit.