Spreadsheets and Calculators Exercise

1. Use a calculator to do the following calculations:

a. 54 x 39
b. 56 + 32 x 9
c. 40 ÷ 4 × 10
d. 5695 ÷ 5
e. 19 + 17.5 − 4.324
f. 32 x 6.5 ÷ 5
g. 1.2875 ÷ 0.5 + 2 x 4

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

a. 32 x (45 + 23)
b. (23 + 56) x 91
c. 4.3 + (3.5 − 2.3) x 2.4
d. 342 + 232
e. 23 − 5.22
f. 3.43
g. 4.53 − 2.53

3. Use a calculator to calculate the following and round your answers to one decimal place.e.g. 53.4

a. 34.53 + 48.1 x 64.9
b. 4.52
c. 13.45 ÷ 0.252
d. 2.53
e. 3.43 + (4.66 − 2.97)
f. (3.6 + 5.6) − 6.34
g. 2.492 − 1.492

4. The following table shows the distances from Sydney to eight Australian towns and cities.

Name of city or town
Distance from Sydney (km)
Adelaide
1412
Perth
4078
Hobart
1142
Brisbane
1001
Alice Springs
3830
Darwin
4034
Canberra
286
Melbourne
872

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 hours worked in a week by four workers at a Pizza takeaway.

 
Fred
Sally
Bill
Jenny

Monday

7
6
8
9
Tuesday
5
5
7
5
Wednesday
6
8
9
10
Thursday
4
7
6
5
Friday
8
9
10
9

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

 

6. The following table shows the distances from Wellington to eight New Zealand towns and cities.

Name of city or town
Distance from Wellington (km)
Auckland
657
Gisborne
547
Hamilton
531
Hastings
322
Masterton
99
Napier
232
Rotorua
460
Taupo
402

 

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.