| Absolute Cell Reference |
A cell reference in a formula that will always
reference the same cell, even if the formula is copies 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 the cell in an 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 calculations in a
spreadsheets. Also referred to as 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 A4: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 sort records is ascending order, text
values are arranged from A=>Z. Numeric values are sorted from the smallest
to largest, 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 us again for example a mailing address you use often or a long
distribution list for memos. |