Johnstone High School
Standard Grade Computing
Home
::
General Purpose Packages
::
Spreadsheet
::
General Homework
:: Spreadsheet General 8
Spreadsheet Homework 8
Name:
Email:
(optional)
1
What is your teacher's name?
Mrs Smith
Mr Munro
Mr McGivern
Mr Carey
2
Johnstone High School has decided to use a spreadsheet to keep track of the Activity Day finances. The spreadsheet is shown.
Some figures are calculated automatically by the use of formulae.
In which cells would each formula appear?
PS
=B3*E3 would appear in cell
=C3-D3 would appear in cell
(2 points)
Resource 1
3
State the formula which would appear in cell F7 .
PS
(1 point)
4
A new event of Web Design is to be entered on the spreadsheet. State the changes which will have to be made to include this activity in the correct place.
PS
(3 points)
5
Columns, C, D and E should have been displayed as money. Describe the steps needed to make these changes.
PS
(2 points)
6
In column A the word 'photography' does not fit properly into the cell. How would you solve this problem?
PS
(1 point)
