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. |
| ActiveX Control | An ActiveX Control is 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 row 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 as a program. |
| Argument | A variable required by any =function or macro command. It supplies additional information used by the command =sum(A4:A10), the block address A4:A10 is the argument; it tells Excel what values to add together. |
| Arithmetic Operator | The +,-,*,/, and () operators are to construct arithmetic expressions in queries. |
| ascending Order | When you sort records in ascending order, text values are arranged from A to Z Numeric values are sorted from the smallest to largest, and data 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 use again -for example a mailing address you use often or a long distribution list for memos. |
| Home |