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
Resource for question 2?
Spreadsheet General Homework 9
Name:
Email:
(optional)
1
What is your teacher's name?
Mr McGivern
Mr Carey
Mr Munro
Mrs Smith
2
A spreadsheet is kept of the money pupils have saved towards the weekend. From this money they have to pay for an extra trip. Part of the spreadsheet is shown. What formula is used in cell E4?
PS
(1 point)
3
What formula is used in cell G4?
PS
(1 point)
4
What would have to be done to display all the appropriate figures as money?
PS
(2 points)
5
The year head wants to include the registration class of each pupil. What must be done to the above spreadsheet to allow this to happen?
PS
(1 point)
6
The spreadsheet is part of an integrated package. What is an integrated package?
KU
(1 point)
7
Give one advantage on the spreadsheet and the database having a similar HCI.
KU
(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
