Grade 9 Information Technology · Lesson 3.3
Manipulating Data in Spreadsheets
Unit 3: Application Software
A spreadsheet is an application that organises data in a grid of rows and columns and performs calculations on it. Columns are labelled with letters (A, B, C) and rows with numbers (1, 2, 3); the box where a column and row meet is a cell, named by its address, such as B3. A file is called a workbook, and it contains one or more worksheets.
Key terms
- Cell
- the box where a row and column meet
- Cell address
- column letter plus row number, e.g. C4
- Range
- a block of cells, e.g. A1:A10
- Formula
- a calculation starting with =
- Function
- a built-in formula such as SUM or AVERAGE
- Fill handle
- tool for copying formulas to nearby cells
- Chart
- a graph made from spreadsheet data
Key formulas
Summary
- Spreadsheets organise data in cells named by column and row.
- Formulas start with = and update automatically.
- Functions such as SUM, AVERAGE, MAX and MIN save time; charts show trends.
In everyday life: Farmers' cooperatives in Oromia track coffee deliveries and payments in spreadsheets so every member's total is calculated accurately.
Check yourself
- What is the address of the cell in column D, row 7?
- Write a formula to add A1 to A20.
- What happens to a formula's addresses when you copy it down?
Practice questions
1. In a spreadsheet, cells A1 to A4 contain 10, 20, 30 and 40. What does =AVERAGE(A1:A4) return?
- A. 25
- B. 100
- C. 40
- D. 4
Show answer
Answer: 25
AVERAGE adds the values (100) and divides by the number of values (4), giving 25.
2. Cell B2 contains 150 and C2 contains 4. What value does the formula =B2*C2 give?
Show answer
Answer: 600
The asterisk means multiply, so 150 × 4 = 600. Spreadsheet formulas always begin with = and use * for multiplication.
On WeLearn
The full lesson: reading notes, worked examples, class activities and the Unit 3 quiz
Study Manipulating Data in Spreadsheets on WeLearnTeach Manipulating Data in Spreadsheets with WeLearn
We will bring a demo to your school: a lesson on your interactive TV, a virtual lab and a classroom game, with your own teachers.
