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 2
Name:
Email:
(optional)
1
What is your teacher's name?
Mr McGivern
Mr Munro
Mrs Smith
Mr Carey
2
Doonbrae Bike Company makes and sells bicycles. Calum works in the sales department of the Doonbrae Bike Company. He uses a computer and an integrated package to keep track of the number of bikes which have been sold. Here is a diagram showing part of Calum's screen. Which part of the integrated package is Calum using?
KU
(1 point)
Graphics
Spreadsheet
Word processor
Database
3
Which cell on Calum's screen shows the number of bikes sold in May?
PS
(1 point)
4
Each cell on the screen can contain a value, text or a formula. Match the term to the description.
PS
(1 point per match)
A
B
C
Value
A. Cell B5, Data 33
A
B
C
Text
B. Cell B10, Data =SUM(B3:B8)
A
B
C
Formula
C. Cell A3, data January
5
Calum would like the total of Money taken in to be calculated automatically. What should he type in C10?
PS
(1 point)
=SUM(B2:C7)
=SUM(A9:C9)
=SUM(C2:C7)
=SUM(A2:A87
6
Calum thinks that the recent increase in bike sales is good news. He is going to show this information to the other workers. He has decided to present it as shown. Which part of the integrated package has Calum used to prepare this presentation? Select one option.
KU
(1 point)
Resource 1
Charting
Database
Word Processing
Home
|
S1 Topics
|
S2 Topics
Computing Standard Grade
|
Info Systems Intermediate II
|
Info Systems Higher
|
Internet Safety
Log into Glow
|
School Website
|
Contact Us
