| A | B |
|---|
| comparison operator | A sign, such as greater than (>) or less than (<), that is used to compare two values. |
| criteria | Specifications that allot what data type users want to use in a cell or range of cells and how users want that data used, formatted, or displayed. |
| descending order | An arrangement in which data appear alphabetically from Z to A. |
| duplicate value | Occurs when all values in a row are an exact match for all the values in another row. |
| absolute cell reference | A reference that does not change when a formula is copied or moved. |
| arguments | A component of a function that is enclosed in parentheses. |
| constant | A number or text value that is entered directly into a formula. |
| external reference | A cell or range on a worksheet in another Excel workbook, or a defined name in another workbook. |
| formula | An equation that performs calculations, such as addition, subtraction, multiplication, and division, on values in a worksheet. |
| function | A predefined formula that performs a calculation. |
| mathematical operator | An element that specifies a calculation to be performed. |
| mixed reference | A reference in which one component is absolute and one is relative. |
| name | A meaningful and logical identifier that a user can apply to make it easier to understand the purpose of a cell reference, constant, formula, or table. |
| operand | An element that identifies the value to be used in a calculation. |
| reference | A component of a formula that identifies a cell or a range of cells on a worksheet. |
| relative cell reference | A reference that changes “relative” to the location where it is copied or moved. |
| scope | The location within which Excel recognizes an item without qualification. |
| argument | A component of a function that is enclosed in parentheses. |
| array | Used to build single formulas that produce multiple results or that operate on a group of arguments |
| authentication | The process of verifying that people and products are who and what they claim to be |
| certificate authority | A third-party entity that issues digital certificates to be used by others |
| change history | Information maintained about changes made in past editing sessions, including the name of the person who made each change, when the change was made, and what data was changed |
| conditional formula | Automatic formatting based on established criteria |
| digital certificate | A means of proving identity and authenticity |
| digital signature | A signature that is used to authenticate digital information using computer cryptography |
| lookup functions | Functions used to find information stored in a table in an Excel worksheet |
| password | Text that must be keyed before a user can access a workbook, worksheet, or worksheet element. |
| shared workbook | A workbook that is set up to allow multiple users on a network to view and make changes at the same time. |
| strong password | A password that combines uppercase and lowercase letters, numbers, and symbols |
| table | A range of cells in a worksheet that can be used by a lookup function |
| track changes | The ability to mark and record the changes that have been made to a workbook |
