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...

      

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
(b) State the expression you would use to obtain:
(i) Total expenditure by David
(ii) Total number of sausages taken
(iii) The cost of the cheapest item

  

Answers


Kavungya
a) fig1225620191033.png
b) i) = C6 * $C$3 + D6*$D$3 + E6*$E$3
ii) = sum (C4: C7)
iii) = Min (C3: E3)
Kavungya answered the question on June 25, 2019 at 07:35


Next: Define Optical fibre cables.
Previous: Compare the two types of diskettes used in microcomputers in terms of physical size and densities.

View More Computer Studies Questions and Answers | Return to Questions Index


Exams With Marking Schemes

Related Questions