|
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.
|
|
|
|