SECTION 2
Lesson 2.2 Basic Excel Features

   

 

 

In this exercise you will practice entering text values with AutoComplete.

 

1.

 Start Excel 2003 by double clicking the Excel icon or by using the start menu

Start->Programs->Microsoft Office->Microsoft Office 2003

 

 

 

2.

When you see the Excel screen, click the Open button on the standard toolbar.

 

Text Box: Open

 

 

 

 

3.

Use the Open dialogue box to browse to Your Excel 2003 Practice Folder.

 

 

 


In the Open dialogue box select the Weather file and click the Open button

 

 

 

4.

You should now see the Weather worksheet.

 

 

Make the cell under the Climate label the active cell, and type Tropical. Press Enter.

 

 

 

5.

Type Desert in the next cell in the column, followed by Arctic in the next cell. Your worksheet should look like this.

 

 

 

6.

Now type T in the next cell in the column (G5). Notice that Excel completes the entry for you.

Do not press enter, because you do not want to enter Tropical in this cell. Instead, clear the cell using the Backspace key, and type Temperate. Press Enter.

 

 

 

7.

Now, in the next cell (G6) Type the letter T. AutoComplete will not fill in the rest of the word because there is not enough information to discern between the words Tropical and Temperate. When you type a second letter R, AutoComplete will fill in the word Tropical.

 

If you type D in a cell, AutoComplete will fill in the word Desert. If you type A in a cell, AutoComplete will complete the word Arctic. When you are finished typing,

 

 

 

press Enter, click the Save button on the standard toolbar, and exit Excel by clicking the X (close) button in the upper right corner of the screen