WeLearn

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
All Grade 9 Information Technology key terms →

Key formulas

Adds all values from B2 to B6.
Mean of the values from B2 to B6.

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

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