1.         In Excel 2003 columns are indexed by

A.                    Column numbers

B.                    Column letters

C.                   Column names

D.                   Column references

2.         In Excel 2003 AutoSum can be used to

A.                    Calculate totals for numerical data in adjacent cells

B.                    Sort columns of data

C.                   Change the formatting of adjacent cells

D.                   Remove formatting from a selection of cells

3.         A formula in an Excel worksheet should not

A.                    Contain multiple cell references

B.                    Combine mathematical operations

C.                   Be relocated to another cell

D.                   Contain circular references.

4.         You can select a range of cells in Excel by

A.                    Dragging with your mouse

B.                    Entering  a range in the Cell Name field on the formula bar

C.                   A. and B.

D.                   None of the above

5.         The function of AutoComplete is

A.                    To search a worksheet for spelling mistakes

B.                    To automatically fill in entries that increase by a fixed increment

C.                   To change the formatting of numerical data

D.                   To complete entries by filling in the closest match to what you type based on data in adjacent cells

6.         The Paste Special Feature can

A.                    Use the values to be pasted in operations on the destination cells

B.                    Adjust the dimensions of the destination cells

C.                   Paste only the results of a formula and not the formula itself

D.                   All of the above

7.         You can use Find and Replace to

A.                    Find and replace numerical data

B.                    Find and replace textual data

C.                   Find every occurrence of an item

D.                   All of the above

8.         You can use the Redo feature to

A.                    Redo an action that was undone

B.                    Find spelling errors

C.                   Find circular references

D.                   Save your workbook under a different name.

9.         To copy multiple cells you can

A.                    Select a range of cells, right click on a cell in the range, and choose Copy

B.                    Select a range of cells, right click on the destination cell, and choose Copy

C.                   Select a range of cells, and choose Tools->Options->Copy Multiple Cells 

D.                   Select a range of cells and click the Multiple Cell button on the standard toolbar

10.       A Smart Tag will normally provide you with

A.                    The same set of options every time

B.                    A  set of options that will change depending on the context of your actions

C.                   The ability to use Excel as a word processor

D.                   A way to document your worksheet with notes and comments.