Microsoft Office 2003
Concepts and Techniques
Creating,
Sorting, and
Querying a Worksheet List
|
TERM |
TERM DEFINITION |
TERM AS IT RELATES
TO YOU AND YOUR EXPERIENCE |
|
xls (EX 361) |
|
|
|
access key(EX 321) |
|
|
|
ascending sequence (EX 333) |
|
|
|
AutoFilter (EX 346) |
|
|
|
automatic subtotals (EX 338) |
|
|
|
comparison criteria (EX 343) |
|
|
|
computational field (EX 306) |
|
|
|
computed criteria (EX 346) |
|
|
|
control field (EX 338) |
|
|
|
criteria range (EX 350) |
|
|
|
criteria area (EX 307) |
|
|
|
data form (EX 318) |
|
|
|
database (EX 306) |
|
|
|
database functions (EX 358) |
|
|
|
DAVERAGE function (EX 358 |
|
|
|
DCOUNT function (EX 358) |
|
|
|
descending sequence (EX 333) |
|
|
|
extract range (EX 354) field (EX 306) |
|
|
|
file extension (EX 361) |
|
|
|
filter criterion (EX 346) |
|
|
|
hide detail symbol (-) (EX 342) |
|
|
|
HLOOKUP function (EX 323) |
|
|
|
insert row (EX 315) |
|
|
|
intermediate sort key (EX 336) |
|
|
|
list (EX 306) |
|
|
|
major sort key (EX 336) |
|
|
|
Microsoft Excel workbook (EX 361) |
|
|
|
minor sort key (EX 336) |
|
|
|
OR operator (EX 350) |
|
|
|
outlining features (EX 342) |
|
|
|
query (EX 346) |
|
|
|
querying (EX 343) |
|
|
|
question mark (?) (EX 345) |
|
|
|
record (EX 306) |
|
|
|
resize handle (EX 315) |
|
|
|
row level bar (EX 342) |
|
|
|
row level symbols (EX 342) |
|
|
|
show detail symbol (+) (EX 342 |
|
|
|
sort key (EX 333) |
|
|
|
sorting (EX 333) |
|
|
|
table arguments (EX 323) |
|
|
|
table array (EX 323) |
|
|
|
table value (EX 323) |
|
|
|
total row (EX 329) |
|
|
|
VLOOKUP function (EX 323) |
|
|
|
wildcard characters (EX 345) |
|
|