Activity In this activity, you will create a table to demonstrate the different types of cell references.
A grocer keeps track of the fruits he purchases each month. He has a standard order in boxes. For example, if he orders apples in January, then
for the full month of January he will get a daily shipment of 10 boxes of apples. A monthly transport cost is necessary on each box, and this cost is
the same for all fruits. He enters his orders in a spreadsheet such as the following:
E
G
1
3
K
F
January
February
H
March
April
May
А
B
1 Fruit
Boxes
2 Apples
3 Oranges
4 Strawberries
5 Grapefruit
6 Peaches
7 Plums
8 Grapes
9 Apricots
10
11
12 Transport cost
13
035
14
15
с
D
Cost per box Total cost
10
22.05
15
27.15
40
1225
9
42.12
151 19.73
20
18 36
25
25 55
19
34 02
He uses the second table to calculate the cost for each type of fruit per month using the following calculation:
(number of boxes x number of days in the month x cost per box) + (number of boxes x transport cost).
If he orders strawberries throughout January, write a formula to calculate the cost, and then copy the formula to the worksheet for the following
entries:
January: strawberries, peaches, plums, grapes
February: peaches, oranges, apples, grapes
March: peaches, apples, plums
April: peaches, strawberries, grapes
May: oranges, grapefruit, plums, apricots
B