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 General Homework 2
Name:
Email:
(optional)
1
What is your teacher's name?
Mr Munro
Mrs Smith
Mr McGivern
Mr Carey
2
Laura runs a small business making small wooden animals. The spreadsheet shows how Laura calculates her costs.
If cell C4 changes, name
one
other cell which would also change.
PS
(1 point)
Resource 1
3
Cells E5 and F5 both contain a formula.
Suggest a suitable formula for cell E5.
PS
(1 point)
4
Suggest a suitable formula for cell F5.
PS
(1 point)
5
The formula in E3 has been replicated down the other cells in column E.
What does the term replicate mean?
KU
(1 point)
6
Where else in the spreadsheet could the replicate feature have been used?
PS
(2 points)
7
Laura would like to display the contents of cell C3 as £3.00. What must she do to the cell attributes to change the way the data appears?
PS
(1 point)
8
. Ingrid would like to use the spreadsheet package but is unfamiliar with it. Laura recommends that she should make use of the
on-line tutorial
.
What is meant by an on-line tutorial?
KU
(1 point)
9
Which other feature could Laura suggest which would help Ingrid get used to using the package?
PS
(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
