Page 8 of 15PREVNEXT

Lists I: How to use lists in Excel 2003

Test yourself

Complete the following test so you can be sure you understand the material. Your answers are private, and test results are not scored.


On which menu is the List command?

On the Tools menu.

On the Data menu.

On the List menu.

How do you add a column to a list?

Type in the empty column to the right.

On the Data menu, point to List, and then click Resize List.

Right-click the empty column to the right, click Insert, and then click Entire Column.

How would you count the number of names in the last column in a list?

Count them manually yourself.

Click the AutoSum button on the Standard toolbar.

Click the Toggle Total Row button on the List toolbar.

How do you hide the total row in a list?

Click List on the List toolbar, point to Delete, and then click Row.

Click the Toggle Total Row button on the List toolbar.

Press the DELETE key on the keyboard.

Page 8 of 15PREVNEXT