SECTION 2
Lesson 2.1 Working with Excel

   

 

 

In this exercise you will practice entering labels and data in a worksheet.

 

1.

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

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

 

 

 

 

 

2.

When you see the Excel screen click on the cell B1 to make it active.

 

 

Type Item in the cell and press the Right arrow key to move to the next cell on the right (C1).

 

 

 

3.

Type Quantity in cell C1, and then move to cell D1 and type Price.

 

 

 

Now move to cell B2 (with the arrow keys or by clicking the cell) and type widget1.

Press Enter and B3 will become the active cell. Type widget2  in cell B2

 

 

 

 

4.

Move to the cell beneath the Quantity label (C2) and type 100. Press enter and type 200 in the next cell (C3).

 

 

 

5.

Now enter 3.5 and 5.0 under the Price label in cells D2 and D3 respectively.

Move to cell D2 making it the active cell and click the Currency $ button on the formatting toolbar. Do the same for cell D3

 

 

You now have a simple spreadsheet detailing item types, quantity, and a price for each item.

 

 

6.

Click on the File menu and choose the Save as option,

File->Save as.

 

 

Browse to your Excel 2003 practice folder and type the file name Widgets, in the filename text field. Click the Save button to save the file.