Microsoft Office 2003
Concepts and Techniques

Excel 2003

Project FIVE

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)

 

 

 

 

Hosted by www.Geocities.ws

1