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

---

a)
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

Exams With Marking Schemes

• Grade 1
• Grade 2
• Grade 3
• Grade 4
• Grade 5
• Grade 6
• Grade 7
• Grade 8
• Grade 9
• PP1
• PP2
• Playgroup
• Form 1
• Form 2
• Form 3
• Form 4

Related Questions

---

• Define Optical fibre cables. (Solved)
  

  Define Optical fibre cables.

  Date posted: June 25, 2019 .    Answers (1)

• Give one advantage and one disadvantage of coaxial cables. (Solved)
  

  Give one advantage and one disadvantage of coaxial cables.

  Date posted: June 25, 2019 .    Answers (1)

• Give one advantage and one disadvantage of twisted pair cables. (Solved)
  

  Give one advantage and one disadvantage of twisted pair cables.

  Date posted: June 25, 2019 .    Answers (1)

• A program is required for reading in a student’s name and scores obtained in two subjects. The output of the program will consist of the student’s... (Solved)
  

  A program is required for reading in a student’s name and scores obtained in two
  subjects. The output of the program will consist of the student’s name, the two
  scores, the average of the two scores and comment. The comment is based on the
  average as follows:
  
  Write a program to solve the problem using a high level language.

  Date posted: June 25, 2019 .    Answers (1)

• What is the use of the search? Replace future in a word-processor. (Solved)
  

  What is the use of the search? Replace future in a word-processor.

  Date posted: June 25, 2019 .    Answers (1)

• Define Optical Mark Reader (OMR). (Solved)
  

  Define Optical Mark Reader (OMR).

  Date posted: June 25, 2019 .    Answers (1)

• List the steps that you would use to correct wrongly spelt words in a document using the spell-checking feature. (Solved)
  

  List the steps that you would use to correct wrongly spelt words in a document using the spell-checking feature.

  Date posted: June 25, 2019 .    Answers (1)

• Differentiate between primary memory and secondary memory. (Solved)
  

  Differentiate between primary memory and secondary memory.

  Date posted: June 25, 2019 .    Answers (1)

• Briefly explain any two advantages and two disadvantages of using a database (Solved)
  

  Briefly explain any two advantages and two disadvantages of using a database

  Date posted: June 25, 2019 .    Answers (1)

• The roots of the equation ax² +bx + c= 0 are by the formula a) Draw a flowchart to compute the roots of the equation. b) Using... (Solved)
  

  The roots of the equation ax² +bx + c= 0 are by the formula
  
  a) Draw a flowchart to compute the roots of the equation.
  b) Using the flow-chart write a program that will compute the roots and
  if b² – 4ac is negative, the program should display the message
  “NEGATIVE

  Date posted: June 25, 2019 .    Answers (1)

• Give any two types of data entries that may be input into a worksheet cell. (Solved)
  

  Give any two types of data entries that may be input into a worksheet cell.

  Date posted: June 25, 2019 .    Answers (1)

• Name any two types of graphs that are supported by spreadsheets. (Solved)
  

  Name any two types of graphs that are supported by spreadsheets.

  Date posted: June 25, 2019 .    Answers (1)

• Give two types of storage devices used in a computer giving an example of each. (Solved)
  

  Give two types of storage devices used in a computer giving an example of each.

  Date posted: June 25, 2019 .    Answers (1)

• State one advantage and one disadvantage of a laser printer (Solved)
  

  State one advantage and one disadvantage of a laser printer

  Date posted: June 25, 2019 .    Answers (1)

• What is a distributed system? (Solved)
  

  What is a distributed system?

  Date posted: June 25, 2019 .    Answers (1)

• State two operational methods of an organization ensuring of data. (Solved)
  

  State two operational methods of an organization ensuring of data.

  Date posted: June 25, 2019 .    Answers (1)

• Explain the difference between the printing of multiple copies and the printing of multiple pages (Solved)
  

  Explain the difference between the printing of multiple copies and the
  printing of multiple pages

  Date posted: June 25, 2019 .    Answers (1)

• A spreadsheet has the following entries: Provide a formula for cell C% that can be copied onto cell D5 and the reange C6.. D10 to give a... (Solved)
  

  A spreadsheet has the following entries:
  
  Provide a formula for cell C% that can be copied onto cell D5 and the reange C6..
  D10 to give a uniform increase of 10% of the previous year’s value for each item.

  Date posted: June 25, 2019 .    Answers (1)

• In which memory would the monitor program would be stored? (Solved)
  

  In which memory would the monitor program would be stored?

  Date posted: June 25, 2019 .    Answers (1)

• State a situation where real time processing would be appropriate. (Solved)
  

  State a situation where real time processing would be appropriate.

  Date posted: June 25, 2019 .    Answers (1)