Lesson 29 — Activity 2: Using Spreadsheets
Completion requirements
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

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:
Try This:
Below is an image of a spreadsheet used for keeping track of student grades. Answer the questions regarding the spreadsheet that follow.

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