Category 1
The column letter and row number that identify a cell.
Cell address
The tool used in a worksheet to display formulas.
Show Formulas or press Ctrl Tilde
A prebuilt workbook used as a pattern for creating new workbooks
Template
A tool in Excel that provides tools to be used for the selected data.
Quick Analysis
The box that identifies the patterns or colors assigned to the data series.
Legend
This error message prevent users from entering invalid data in a cell
Stop
The small green square in the lower right corner of the active cell.
Fill Handle
Addition and this mathematical operator are considered to be on the same precedence level.
Subtraction
A single instruction that expands automatically into a set of instructions to perform a particular task.
Macro
Data in an Excel table can be sorted in this way.
Smallest to largest
Symbols that specify mathematical operations such as addition or subtraction.
Arithmetic operators
This will be pasted when the paste option Keep Source Column Widths is selected.
all content (Everything) including the source Column width
Clear Contents - This will be deleted when clearing the contents of a cell.
Only the contents - (not the formatting)
An Excel function that returns the serial number of the current date and time.
NOW
A function that counts the number of cells that contain numbers.
COUNT
A cell ________ color is also known as the background color.
fill
A format, such as cell shading, that is applied to cells when a specified condition is true.
Conditional Cell Formatting
This command ensures that header rows and columns remain visible when a worksheet is scrolled.
Freeze Panes
The character used to separate columns of text in a data table is called a ________.
delimiter
This command displays only rows that meet a specified condition.
Filter
This function is used to join text from separate cells and columns.
CONCATENATE
Use this option to change the formatting or underlying values of cells as they are pasted.
Paste Special
This function is used to count the number of cells in a range that meet a certain criterion.
COUNTIF
This options pastes the displayed values of the copied cell instead of the underlying formulas.
Paste Values
Returns a specified number of characters from the left side of data.
LEFT