1.                  For the best results, an Excel list should contain

A.                  Numerical values only

B.                 Adjacent columns of data with distinct headings and no missing rows

C.                 Empty columns between the labeled columns.

D.                 No formulas or functions

2.                  To create a list in Excel 2003 you should

A.                  Click the list button on the formatting toolbar

B.                 Choose Data->List->Create List from the menu bar

C.                 Type List after each data entry in the formula bar

D.                 Select a range of data and press the Ctrl + Shift + Enter

3.                  Lists in Excel 2003 have

A.                  No differences from lists in earlier versions of Excel

B.                 Less functionality than lists in earlier versions of Excel

C.                 More functionality than lists in earlier versions of Excel

D.                 None of the above

4.                  In Excel, records and fields are roughly analogous to

A.                  Cells and data

B.                 Ranges and lists

C.                 Rows and columns

D.                 Text and numbers

5.                  In Database terminology, a record is

A.                  A collection of information describing a single instance of an entity

B.                 A column of data that is often repeated

C.                 A single cell of data used in the VLOOKUP function

D.                 None of the above

6.                  In database terminology, a field is

A.                  A single attribute of an entity that is combined with other fields to make a record

B.                 A range of data in adjacent data blocks

C.                 A and B

D.                 None of the above

7.                  In Excel you can sort a list by

A.                  Selecting a sort option from the AutoFilter menu

B.                 Choosing Data->Sort from the menu bar

C.                 Right clicking on a data cell and selecting order records from the menu

D.                 A and B

8.                  Wild card characters can be used to

A.                  Substitute other characters in a filtering criterion

B.                 Substitute numerical values in a formula

C.                 Create Array formulas

D.                 None of the above

9.                  In Excel, a criteria range is

A.                  A range of data used by the VLOOKUP function

B.                 A range of data used when creating an advanced filter

C.                 A range of data used in database functions

D.                 B and C

10.             In a criteria range, conditions on offset rows will be

A.                  Combined with a logical or

B.                 Combined with a logical and

C.                 Combined with another data range

D.                 None of the above