Foundation Foundation Set 3

What is your teacher's name?

Mr Munro
Mrs Smith
Mr Carey
Mr McGivern

The table shown is part of a spreadsheet. It shows the Upland Ladies Rugby League during the season. What data is in cell A7? KU (1 point)

Resource 1

Give the reference of a cell in the spreadsheet shown that contains text. KU (1 point)

Give the reference of a cell in the spreadsheet above that contains a value. KU (1 point)

The full table as shown has rows and columns which hold formulae to calculate points scored by each team and totals.
Complete the sentences using the word bank. KU

The points for Games Played are held in a ?
The totals are held in a ? (2 points)

Resource 1

Cell B2 holds a formula which calculates the number of games played by Auchter Ross. Which of the following shows the correct formula? (1 point)

SUM(C2:E2)
AVERAGE(C2:E2)
SUM(C3:C8)

Introduction
to Spreadsheets

More Complex Tasks

Advanced Tasks

Homework

Helpful Extras

Spreadsheet Foundation Homework 3