Andrew, Jane, David and Zablon had tea, sausages and bananas for breakfast. They took one sausage, two sausages, three sausages and one sausage respectively. In addition, they took a cup of tea and two bananas. Tea, sausages and bananas cost Kshs 10, 15 and 5 respectively.
By naming columns A, B, C … and rows 1, 2, 3 …………….
(a) Construct a worksheet showing the above information (7mks)
(b) State the expression you would use to obtain:
(i) Total expenditure by David
= C6 * $C$3 + D6*$D$3 + E6*$E$3 (4mks)
(ii) Total number of sausages taken (2mks)
= sum (C4: C7)
(iii) The cost of the cheapest item (2mks)
= Min (C3: E3)