R Mohammadi

1. Place your CD for Microsoft Office Starts Here in your CD-ROM Drive. Click the Quit button if a dialog box comes up to auto-start the software.

 

2. Start Microsoft Office Starts Here by clicking the Icon on your desktop.

 

3. Choose the Basics by clicking on it.

 

4. On the left hand side of the Window under Sections, pick

 

5. Do the first two lessons, Create a Workbook and Enter and Modify Text and Numbers.

 

6. Take Quiz after each lesson. Be sure to let your lab instructor see the results before you continue.

 

7. Close the window by clicking on the X in its upper right hand corner.

1. Create a table for First Quarter Sales as shown:

 

 

	Smally Department Store
	First Quarter Sales
	January	February	March	Total
Clothing	1500	1600	1800
Toys	800	700	800
Houseware	1200	1600	1700
Jewelry	900	1100	700
Total

 

2. To make row and column headers bold, simply, highlight those cells and click on the Bold button in your tool bar.

 

3. To change the format of your numbers to currency (numbers with $ and ,).

 

1. Highlight the numeric cells.
2. In the Format menu, click on Cells ..
3. Select the Number folder by clicking on its tap in the Format Cell window that pops up.
4. Select Currency as the category.

 

4. To compose a formula in the total cell for clothing:

 

1. Point/Click on the cell intersecting clothing, Total.
2. From the smart icon bar click on . This will highlight your clothing sales for January, February, and March automatically and formulate a summation formula to add the cell contents.
3. Hit Enter to accept the composed formula.

 

5. To copy the summation formula from the clothing, Total cell into the other total cells in this column:

    

   1. point to the clothing, Total cell and press/drag until all total cells through jewelry, Total are highlighted.
   2. Point to the Fill option from the Edit pull-down menu. The Fill submenu pops up.
   3. Choose Down in the Fill submenu. This will copy the formula from clothing, Total into the other highlighted total cells.

    

6. To compose a formula for the Total cell for January:

 

1. Point/Click on the cell intersecting Total, January.
2. From the smart icon bar click on . This will highlight sales for January and formulate a summation formula to add the cell contents.
3. Hit Enter to accept the composed formula.

 

7. To copy the summation formula from the Total, January cell into the other total cells in this row:

 

1. Point to the Total, January cell and press/drag until all total cells through Total, Total are highlighted.
2. Point to the Fill option from the Edit pull-down menu. The Fill submenu pops up.
3. Choose Right in the Fill submenu. This will copy the formula from Total, January into the other highlighted total cells.
4. If the Total, Total cell contains ######, it simply means that there isn't enough room for its content. Highlight the column by clicking on the column tab at the top, it should be E in this case. In the Format menu, point to Column and when the column format choices pop up, choose AutoFit Selection.
5. Your table should look like the following:

 

 

	Smally Department Store
	First Quarter Sales
	January	February	March	Total
Clothing	$1,500.00	$1,600.00	$1,800.00	$ 4,900.00
Toys	$ 800.00	$ 700.00	$ 800.00	$ 2,300.00
Houseware	$1,200.00	$1,600.00	$1,700.00	$ 4,500.00
Jewelry	$ 900.00	$1,100.00	$ 700.00	$ 2,700.00
Total	$4,400.00	$5,000.00	$5,000.00	$14,400.00

 

 

1. Highlight the First quarter table including its header.
2. Click on the copy button
3. Click in a cell in column A below the First Quarter table, such as A15.
4. Choose Paste from the Edit Pull-down menu.
5. Change the headers and the values to what is shown below. Note that formulas should remain intact, but the summation results change.