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 1
Name:
Email:
(optional)
1
What is your teacher's name?
Mr Carey
Mr McGivern
Mrs Smith
Mr Munro
2
Anna Croft runs a small business making clothes. To keep track of the costs and income for her business, Anna uses a software package as shown.
What kind of software package is this?
KU
(1 point)
Resource 1
3
Each month Anna types in the costs of the various items. She does
not
need to type in the total costs. Explain why she does
not
need to type in the total costs.
PS
(1 point)
4
“Quarterly totals” was originally typed in cell A6. What can be done to the cell so that the full cell contents are displayed?
PS
(1 point)
5
The amount in column F shows the total in pounds only. What can be done to display the amount in pounds and pence, so that F3 will show £3197.50?
PS
(1 point)
6
Cell F3 contains a formula.
Suggest a suitable formula for cell F3.
PS
(1 point)
7
Anna is worried that the formulae could accidentally be deleted from the cells that they are contained in. What could she do to these cells to prevent this from happening?
PS
(1 point)
8
Anna is worried that the information in the spreadsheet could be lost.
Describe
three
precautions that she should take against data loss.
KU
(3 points)
Home
|
S1 Topics
|
S2 Topics
Computing Standard Grade
|
Info Systems Intermediate II
|
Info Systems Higher
|
Internet Safety
Log into Glow
|
School Website
|
Contact Us
