Question

PLEASE HELP WORTH 100 POINTS !!!!!

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:



He uses the second table to calculate the cost for each type of fruit per month using the following calculation:

(number of boxes × number of days in the month × cost per box) + (number of boxes × 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

I know this isn't math but like i said i really need help!!!!

Answer 1

=$B4*30*$C4+$B4*$A$13

Explanation:

(number of boxes × number of days in the month × cost per box) + (number of boxes × transport cost)

Use this accordance with cell addresses.

=$B4*30(not sure about the number of days)*$C4+$B4*$A$13

• Number of days are difference for each month, but commonly use 30 days. Question has asked to copy the formula. Therefore, you should include another column with number of days in the month or can use 30.

• $ is use for absolute cells.