1. Use a calculator to do the following calculations (turn your calculator upside down and you will see a "word"):

a. 97 − 63
b. 46708 − 45789
c. 140 ÷ 4 × 100 − 455
d. 64.9656 ÷ 84
e. 241670 ÷ 65
f. 592 + 4237/19

g. Y7_Calculators_and_Spreadsheets_ex_01.gif

Y7_Calculators_and_Spreadsheets_ex_02.gif

2. Use a calculator to do the following calculations involving brackets and exponents:

a. 42 x (56 + 47)
b. (23 + 56) x 91
c. 4.3 + (3.5 − 2.3) x 2.4
d. 232 + 312
e. 23 − 3.42
f. 2.63
g. 5.43 − 3.63

3. Use a calculator to calculate the following and round your answers to the nearest whole number.

a. 44.55 + 98.1 x 24.6
b. 5.62
c. 24.65 ÷ 0.352
d. 4.53
e. 2.63 + (9.67 − 3.97)
f. (5.6 + 9.7) − 5.84
g. 5.452 − 3.592

4. The following table shows the distances from Christchurch to eight New Zealand South Island towns and cities.

Name of city or town
Distance from Christchurch (km)
Invercargill
579
Y7_Calculators_and_Spreadsheets_ex_03.gif
Dunedin
362
Westport
333
Nelson
424
Greymouth
258
Oamaru
247
Queenstown
486
Timaru
163

a. Enter the data into the first two columns of a spreadsheet.
b. Make the names of the cities bold.
c. Centre the distances.
d. Use a formula to add all of the distances together.
e. Sort the distances into order from smallest to largest.

5. The following data shows the amount earned in dollars($) in a week by four workers at a supermarket.

 
Ralph
Susan
Sam
Jan
Y7_Calculators_and_Spreadsheets_ex_04.gif

Monday

79
89
82
65
Tuesday
58
85
95
54
Wednesday
90
84
92
56
Thursday
83
78
86
54
Friday
82
89
102
49

a. Put this information into the first 5 columns and first 6 rows of a spreadsheet.
b. Use formulae to find the total amount earned by each employee.
c. Use formulae to find the total amount earned each day.
d. Find the total amount earned by all of the workers.
e. If the workers are paid an avarage of $9.50 for each hour worked, use a spreadsheet cell to calculate the total hours worked.