LAB #6

CSC 101

Introduction to Spreadsheets

R Mohammadi

October 1998

Objectives:

Using Microsoft Excel, learn to...

store data in a spreadsheet.

Use formulas/functions to do calculations.

 

about this lab ...

This lab introduces you to spreadsheets. A Spreadsheet is a two dimensional entity that holds data in such a way that is very natural for maintaining tables. Information is placed into cells identified by their row and column. For instance, B10 refers to the cell at the intersection of column B and row 10. You can use the first row for putting in your column headers in spreadsheets. It is OK to mix the types of information from characters to numbers or formulas in a given column.

 

You will need your 3.5" disk for this lab.

 

 

1. Learn to create and modify Excel workbooks with Microsoft Office Starts Here.

 

    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.  

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

      3.  

    3. Choose the Basics by clicking on it.
    4. On the left hand side of the Window under Sections, pick

      5.  

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

      6.  

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

      7.  

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

 

2. Starting Microsoft Excel.

Start Microsoft Excel by clicking on Start, clicking on Programs, and then clicking Microsoft Excel. An Excel window should be on your screen.

 

3. Create a Table.

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

 

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

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

    2.  

  2. To change the format of your numbers to currency (numbers with $ and ,).
      1. Highlight the numeric cells.
      2. In the Format menu, click on Style ...
      3. Click on Modify, select the Number folder, click on Currency.
    1. Point/Click on the cell intersecting clothing, total and from the smart icon bar click on this will add your clothing sales for January, February, and March. Hit enter to accept.

      2.  

    2. To copy the formula for summation in clothing, total, point on the clothing, total cell and press/drag till jewelry, total cell. Select Fill from the Edit menu. Click on Down. This will copy the formula from clothing, total into the other total cells.

      3.  

    3. Repeat step d. for cell total, January.

      4.  

    4. Copy the formula from total, January into the other total cells in the total row. Highlight the three cells and select Fill from the Edit menu. Click on Right. Your sheet 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

4. Replicate Table and Modify.

 

a. Highlight the First quarter table including its header.

b. Click on the copy button

 

c. Click in a cell in column A below the First Quarter table, such as A15.

 

d. Choose Paste from the Edit Pull-down menu.

 

    1. Change the headers and the values to what is shown below. Note that formulas should remain intact.

 

 

5. Save your spreadsheet.

 

Save this sheet as LAB6 on your 3 ½" Floppy (A:). You have now completed the lab. Logout of the workstation after your lab instructor examines your work.