GLOSSARY TERMS " A "
| Absolute cell Reference | A cell reference in a formula that will always reference the same cell, even if the formula is copied to a different part of the worksheet. To make a cell reference absolute insert dollar signs in its address for example, $A$5. Function key F4 can be used to do this. |
| Active X control | An Active Control in an object that you insert on a form to enable or enhance a user's interaction with an application. |
| Address | The location of a cell in a worksheet, defined by the letter of its column followed by the number of its row. For example, E5 is the address of the cell in column E and 5. |
| Adjustment Handle | The adjustment handle lets you adjust the dimensions of a selected object. |
| Application | Software designed to carry out a certain kind of action or activity, such as word processing or calculation in a spreadsheet. Also referred to a s a program. |
| Argument | A variable required by any = function or macro command. It supplies additional information used by the command. For example, in the= function command = sum(A4:A10),the block address A10:A10 is the argument; it tells Excel what values to add together. |
| Arithmetic Operator | The +, -,/,* and() operators are used to construct arithmetic expressions in queries. |
| Ascending Order | When you records in ascending order, text values are arranged from A Z. Numeric values from the smallest, and date values from earliest to latest. |
| Attribute | Features of an object which you can change using tools and commands. These include line, fill, shadow, embossing, colours and shape. |
| Auto text | A storage location for text or graphics you want to use again- for example, a mailing address you often use or a long distribution list for memos. |