Terms : Hide Images
| 2933722589 | Argument | Variables or values the function requires in order to calculate a solution. A value passed to a function, either as a constant or a variable. Example: In =IF(logical_test, value_if_true, value_if_false), logical_test, value_if_true, and value_if_false are all arguments. | 0 | |
| 2933728786 | AVERAGE function | A function that returns a weighted average from a specified range of cells. Blank cells in the range that is selected will be ignored. | 1 | |
| 2933729708 | Banding | Alternating the background color of rows and/or columns to assist in tracking information. |  | 2 |
| 2933732713 | Built-in cell style | Predefined and named combination of cell and content formatting properties. | 3 | |
| 2933753496 | Built-in function | A function included in Excel that can be categorized as financial, statistical, mathematical, date and time, text, or so on. | 4 | |
| 2933753979 | Cell alignment | Allows cell content to be left-aligned, centered, and right-aligned on the horizontal axis, as well as top-aligned, middle-aligned, and bottom-aligned on the vertical axis. | 5 | |
| 2933754499 | Cell reference | Refers to a particular cell or range of cells within a formula or function instead of a value. | 6 | |
| 2933755396 | Conditional formatting | Allows the specification of rules that apply formatting to cells, appointments, contacts, or tasks as determined by the rule outcome. In the attached image, any value in the Remaining Balance column that falls below the $1,000 threshold will be marked with an "!". |  | 7 |
| 2933755796 | Constant | A value that does not change. For instance, to represent the months in a year, one could enter 12 in a function's argument or formula because there are always 12 months in a year. Example: =SUM(A1:A20)/12 | 8 | |
| 2933761062 | COUNT function | A function that returns the number of cells in a range of cells that contain numbers. Blank cells or cells that contain something other than numeric data are not included in the results. |  | 9 |
| 2933778884 | Default | A setting that is automatically in place unless you specify otherwise. | 10 | |
| 2933779400 | Destination cell | The cell to be modified by a copy, move, or paste operation. | 11 | |
| 2933779793 | Fill color | The background color of a cell. | 12 | |
| 2933780171 | Format Painter | A tool that enables you to copy the format of objects, such as text or pictures, to other objects. | 13 | |
| 2933780597 | Formula | Performs a mathematical calculation (or calculations) using information in the worksheet to calculate new values; it can contain cell references, constants, functions, and mathematical operators. Example: =F2 + J5 | 14 | |
| 2933780598 | Function | A built-in program that performs operations against data and returns a value such as SUM or AVERAGE. Some functions, called null functions, do not require arguments. | 15 | |
| 2933782581 | Graphical format | The presentation of information in charts, graphs, and pictures. | 16 | |
| 2933783578 | Mathematical operator | Parentheses ( ), exponentiation ^, division /, multiplication *, addition +, and subtraction -. | 17 | |
| 2933784970 | MAX function | A function that examines all numeric values in a specified range and returns the maximum value. | 18 | |
| 2933784971 | MIN function | A function that examines all numeric values in a specified range and returns the minimum value. | 19 | |
| 2933785468 | Order of operations | The order in which Excel processes calculations in a formula that contains more than one operator. | 20 | |
| 2933786233 | Parameter | A term generally used to describe a value included for calculation or comparison purposes that is stored in a single location (a worksheet cell, for example) so that it can be used many times but be edited in a single location. | 21 | |
| 2933787184 | Portable Document Format (PDF) | A file type that preserves most formatting attributes of a source document regardless of the software the document was created in. | 22 | |
| 2933788355 | Relative cell reference | Default cell reference in a formula to a cell reference position that will automatically adjust when the formula is copied or extended to other cells; the cell being referenced changes relative to the placement of the formula. | 23 | |
| 2933789328 | Source cells | The cells that are to be the source of data for the AutoSum function. | 24 | |
| 2933789926 | SUBTOTAL function | A function that can return any of 11 different values including all of the AutoSum functions, the product, standard deviation, and variance. | 25 | |
| 2933790428 | Table style | A predefined set of formatting properties that determine the appearance of a table. |  | 26 |
| 2933790972 | Table | An organized grid of information, arranged in rows and columns. |  | 27 |
| 2933792114 | Tabular format | The presentation of information such as text and numbers in tables. | 28 | |
| 2933792115 | Theme | A set of design elements that enables you to create professional, color-coordinated documents. | 29 | |
| 2933792758 | Workbook theme | A collection of built-in cell styles associated with a workbook theme name. |  | 30 |
