| A | B |
|---|
| Argument | The values and other inputs that a function used to calculate the result. You specify the cell or range that holds the value(s) for each argument or input a particular value |
| Print titles | Row and column labels that are reprinted on each page of a worksheet printout |
| Formula AutoComplete | A feature that speeds up the manual entry of functions |
| Function | A predefined formula that performs a specific calculation using the inputs you specify |
| Function name | The name given to one of Excel’s predefined formulas |
| Nest | To use a function as an argument within another function |
| Banded rows or columns | The shading of alternating rows or columns to make a table easier to read |
| Column specifier | The structured reference to a table column, which consists of the table column header name in square brackets |
| Criterion | A value, some text, or an expression that defines the type of content you want to see |
| Excel table | 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 |
| Filter | Hide nonmatching rows in a table or list of data according to the criterion or criteria you specify |
| Sort | Arrange the rows in a table or list of data in a new order according to the entries in one or more columns |
| Structured References | Using the table name or a table column header in a formula to refer to data in the entire table or specified column |
| Table Style | A combination of cell color, border, shading, and other formatting attributes applied to a table |
| Total row | A row you can display below a table to calculate data in the columns above using a function you choose |
| Name Box | The box at the far-left end of the formula bar that you can use to create and navigate to named ranges |
| Range name | An identifying label assigned to a group of cells. Also known as defined name |
| Volatile | A function that updates and displays a new result each time you open the workbook |
| Expression | A type of equation (such as B6>25) that returns a value, such as TRUE or FALSE. Excel used expressions to identify cells to include in certain formulas such as IF and SUMIF |
| Nesting | Using a function as an argument within another function |
| Case | The use of capital (uppercase) and small (lowercase) letters in text |
| Concatenation | The linking of elements together in a series |
| Freeze | A method to keep specified rows and columns-usually ones containing labels for data-in view when scrolling through a worksheet |
| Panes | Sections or areas in a window that enable you to see different parts of the worksheet at the same time |
| Color scales | A type of conditional formatting that applies a background fill color that varies depending on the relative value stored in each of the formatted cells |
| Conditional Formatting | Variable formatting that changes the formatting applied based on the contents of the cells in the formatting range |
| Data bars | A type of conditional formatting that creates filled background bars reflecting the relative value stored in each of the formatted cells |
| Highlight cells rules | A method of applying conditional formatting based on how cell contents compare with a specified criterion, such as a Less Than comparison |
| Icon sets | A type of conditional formatting that includes one of a set of icons reflecting the relative value stored in each of the formatted cells |
| Quick analysis tool | A tool that provides formatting for data analysis |
| Top/Bottom rules | Conditional formatting rules that format the highest or lowest values in the formatted range, or those that are above or below average |
| Rotate | to change the angle of the contents of a cell |
| Active sheet tab | The selected worksheet; the tab name of an active sheet is bold |
| Grouping | Worksheets that are selected as a unit; any action performed on this unit will affect all the worksheets in the group |
| Gridlines | Light gray lines that mark the cell borders |
| Page break | A code inserted in a document that forces what follows to begin on a new page; a page break is represented on your screen as a dashed line in the worksheet |
| Page break preview | A view that allows you to move and delete page breaks and redefine the print area |
| Print area | The specified range of cells to be printed |
| AutoCalculate | A feature that temporarily performs the following calculations on a range of cells without the user having to enter a formula: AVERAGE, COUNT, COUNTA, MIN, MAX, OR SUM |
