Lesson 29 — Activity 2: Using Spreadsheets


Getting Ready



A spreadsheet is a table of data arranged in columns and rows. Spreadsheets are used to list information and related numbers.

For example, they are used by:
  • accountants to organize and track income and expenses of businesses
  • farmers to record data on crops, cattle, and other commodities
  • teachers who use spreadsheets to record students, assignments, tests, and marks






This is an example of a spreadsheet used by a teacher.

In this activity, you will look at and learn how to use a spreadsheet.




The above image is of a computer spreadsheet. Computer spreadsheets organize information and are also a handy tool for doing calculations with this information. One advantage of a computer spreadsheet is that the related parts will automatically adjust when new information is added. Each cell, row, or column of a spreadsheet is set up and changed according to the needs of the user.

Here are the parts of a spreadsheet:

    Read through each part of the spreadsheet.                         


Try This:

Below is an image of a spreadsheet used for keeping track of student grades. Answer the questions regarding the spreadsheet that follow.


Look closely at each part of the spreadsheet.

  • Which number appears in the active cell?
  • What is the cell address that is showing?
  • How many columns are being used in this spreadsheet?
  • What value is shown in Column D, Row 8 (D8)?
  • What label is given to Column E?



  • 92.33 appears in the active cell.
  • E2 is the cell address.
  • Five columns are being used in this spreadsheet.
  • 74 is the value shown in Column D, Row 8.
  • The label given to Column E is Average.

  Images courtesy of www.imagesgoogle.com 

Digging Deeper

Watch this video that explains how to set up a grade book in Microsoft Excel.