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 7
Name:
Email:
(optional)
1
What is your teacher's name?
Mrs Smith
Mr Carey
Mr McGivern
Mr Munro
2
The results of a recent figure skating competition are stored in a spreadsheet. Part of the spreadsheet is shown
.
Match the words to complete the sentences
.
PS
(1 point per match)
Resource 1
A
B
C
Column
A. All the information about Katy Anderson is contained in a
A
B
C
Row
B. All the scores from Judge 2 is contained in a
A
B
C
cell
C. In the spreadsheet, a box is called a
3
Match the words to complete the sentences.
PS
(1 point per match)
A
B
C
Value
A. Cell B1 contains
A
B
C
Formula
B. Cell E6 contains
A
B
C
Text
C. Cell D5 contains
4
Cell E2 contains a formula which calculates the total score. Which of the following is the correct formula?
PS
(1 point)
=B2+D2
=B2/D2
=SUM(B2:D2)
=B2*D2
5
When the data was first entered into the spreadsheet some of the competitors names did not fit properly. How was this problem solved?
PS
(1 point)
6
The score in cell D5 should have been 5.3 and not 5.2. The contents of
one
other cell will change when the correct score is entered. Which other cell will change when the correct score is entered?
PS
(1 point)
7
The spreadsheet package uses a
WIMP
environment. What is meant by WIMP?
KU
(4 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
