| 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 |
| 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 |
| 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 |
| Print titles | Row and column labels that are reprinted on each page of a worksheet printout |
| electronic spreadsheet program | A computer program used to perform calculations and analyze and present numeric data. |
| workbook | A quick, simple chart located within a cell that serves as a visual indicator of data trends. |
| worksheet | A column chart turned on its side so that the length of each bar is based on its value. |
| name box | A box to the left of the formula bar that shows the cell reference or name of the active cell. |
| formula bar | The area above the worksheet grid where you enter or edit data in the active cell. |
| cell address | A cell’s location, expressed by its column letter and row number, such as A1. |
| cell pointer | The dark rectangle that outlines the active cell in a worksheet. |
| sheet tab scrolling buttons | Triangles that let you navigate to additional sheet tabs when available; located to the left of the sheet tabs. |
| mode indicator | In Office apps, an area on the left end of the status bar that indicates the program’s status, such as the Edit mode in Excel, which displays “Edit” in the mode indicator. |
| tell me box | A search box on the ribbon that is used to find a command or access the application Help system. |
| range | A group of cells in a rectangular block in a worksheet. Also calleda cell range. |
| labels | In Office, terms added to a file’s Document Properties that help locate the file in a search. |
| values | In Excel, numbers, formulas, and functions used in calculations. |
| auto fill | A button that appears after using the fill handle; lets you fill cells with specific elements (such as formatting) of the copied cell. |
| insertion point | A blinking vertical line that appears when you click in a paragraph, cell or text box; indicating where new text or an object will be inserted. |
| clipboard | A temporary Windows storage area that holds the selections you copy or cut so you can use them later. |
| formula | A mathematical statement in a spreadsheet or table cell that calculates a value using cell references, numbers, and arithmetic operators such as +, -, *, and /. |
| formula prefix | An arithmetic symbol, such as the equal sign (=), used to start a formula. |
| arithmetic operators | In a formula, a symbol that performs mathematical calculations, such as addition (+), subtraction (-), multiplication (*), division (/), or exponentiation (^). |
| function | A named operation that replaces the action of an arithmetic expression. |
| arguments | In Excel and Access, and in Word tables, information necessary for a formula or function to calculate an answer. |
| relative cell reference | In a formula, a cell address that automatically changes to reflect the new location when the formula is copied or moved; the default type of referencing used in Excel worksheets; also called a relative reference. |
| absolute cell reference | In a formula, a cell address that refers to a specific cell and does not change when you copy the formula. |
| order of operations | The sequence in which operators are applied in a calculation. |
| Formula AutoComplete | A feature that automatically suggests text, numbers, or dates to insert based on previous entries. |
| Normal view | The Excel view that shows the contents of the sheet but not a preview of how the sheet will look when printed. |
| Page Layout view | The Excel view that shows how the sheet will look when printed. |
| Backstage view | The view that contains commands that let you manage the file and program settings. |
| portrait | Describes a printed copy with the short (8½”) edge at the top of the printout; the printed page is taller than it is wide. |
| landscape | The position of a page, slide, or worksheet so that the page, slide, or worksheet is wider than it is tall. |
| format | The process of changing the appearance of text and objects. |
| number format | A format applied to values to express numeric concepts, such as currency, date, and percentage. |
| font | A set of letters, numbers, and symbols that all have the same style and appearance. |
| font size | The size of characters, measured in units called points. |
| point | An Excel mode that lets you select cells to use in a formula by using the pointer or a screen tap. |
| cell style | A collection of formatting options, such as a specified font, font size, font styles, font color, fill color, and borders, that is applied to a cell. |
| Font styles | A format that indicates how characters are emphasized, such as bold, underline, and italic. |
| alignment | The placement of cell contents in relation to a cell’s edges, such as left-aligned or centered. |
| column heading | The letters contained in boxes along the top of the workbook window that identify the worksheet columns. |
| AutoFit | In an Excel worksheet or a table in Word, PowerPoint, or Access a feature that automatically adjusts column width or row height to accommodate its widest or tallest entry. |
| theme | A predefined, coordinated set of colors, fonts, graphical effects, and other formats that can be applied to documents, spreadsheets, presentations, publications, and Access forms and reports to give them a consistent, professional look. |
| header | Information that appears at the top of each page; also, the blank area at the top of a page where such information can be inserted. |
| footer | In Excel, text or graphics that print at the bottom of each page. |
| conditional formatting | Special formatting that is applied if values meet specified criteria. |
| sheet tab scrolling buttons | Triangles that let you navigate to additional sheet tabs when available; located to the left of the sheet tabs. |
