HOME
|
SIGN IN TO GLOW
|
SCHOOL WEBSITE
General
Purpose Packages
Automated
Systems
Commercial Data
Processing
Computer Systems
Hardware
Computer Systems
Software
Programming
Course
Arrangements
Introduction
to Spreadsheets
1. Home
2. Formula & Functions
3. Replication
4. Formatting
More Complex Tasks
5. Sorting Data
6. Making Charts
7. Cell Protection
8. Insert Rows & Columns
Advanced Tasks
9. Referencing Cells
10. Conditional Formula
11. Case Studies
Homework
Foundation
General
Credit
Helpful Extras
Index
Glossary
Arrangements
Spreadsheet Foundation Homework 4
Name:
Email:
(optional)
1
What is your teacher's name?
Mr Munro
Mrs Smith
Mr McGivern
Mr Carey
2
Class 2W has carried out a survey to find the favourite flavour of crisps. The class entered the results of the survey into a spreadsheet. The class used the spreadsheet to calculate the total number of votes. The spreadsheet is shown.
A8
is an example of a cell which is
Blank
.
Give an example of a cell that holds
Text
.
PS
(1 point)
Resource 1
3
Give an example of a cell that holds a
Number
.
PS
2 PS
(1 point)
4
Cell
B9
holds a formula that calculates the total number of votes. Choose the correct answer from the options shown.
PS
(1 point)
=SUM(B2:B7)
=AVERAGE(A1:B9)
=B7*B2
=B3-A3
5
The class would like to make a poster to show the results of the survey.
What way, other than the spreadsheet shown above, could be used to present the results?
PS
(1 point)
6
(1 point)
Home
|
S1 Topics
|
S2 Topics
Computing Standard Grade
|
Info Systems Intermediate II
|
Info Systems Higher
|
Internet Safety
Log into Glow
|
School Website
|
Contact Us
