The following information shows the income and expenditure for “behayote” matatu for five days. The income from Monday to Friday was Ksh. 4,000, 9,000, 10,000, 15,000,...

      

The following information shows the income and expenditure for “behayote”
matatu for five days. The income from Monday to Friday was Ksh. 4,000, 9,000, 10,000, 15,000, and 12,000 respectively while the expenditure for the same period was Kshs. 2,000, e, 000, 7,000, 5,000, and 6,000 respectively.

i) Draw a spreadsheet that would contain the information. Indicate the rows as 1, 2, 3…..And the columns as a, B, C….
ii) State the expression that would be used to obtain:
I Monday’s profit
II Total income
III Highest expenditure.

  

Answers

---

i)
ii)I Monday’s profit
= B3-C3
II Total income
= SUM(B3:B7) -OR- =B3 + B4 + B5 + B6 + B7
III Highest expenditure.
= MAX(C3:C7)

---

Kavungya answered the question on June 5, 2019 at 08:01

Next: Subtract 0111₂ from 1001₂
Previous: Differentiate between bolding and highlighting text.

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

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

---

• Subtract 0111₂ from 1001₂(Solved)
  

  Subtract 0111₂ from 1001₂

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

• Using two's complement, subtract 7 from 4 and give the answer in decimal notation.(Solved)
  

  Using two's complement, subtract 7 from 4 and give the answer in decimal notation.

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

• Convert 91B₁₆ to octal.(Solved)
  

  Convert 91B₁₆ to octal.

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

• Convert 376₈ to hexadecimal(Solved)
  

  Convert 376₈ to hexadecimal

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

• Convert 9.625₁₀ to binary(Solved)
  

  Convert 9.625₁₀ to binary

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

• Convert 254₁₀ to hexadecimal(Solved)
  

  Convert 254₁₀ to hexadecimal

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

• Explain what the following DOS commands will do when executed. (i) A:\>copy *.* B: (ii) C:\>ERASE *.DOC (iii) B:\>DIR P*.BAT (iv) A:\>MD EXAMS (Solved)
  

  Explain what the following DOS commands will do when executed.
  (i) A:\>copy *.* B:
  (ii) C:\>ERASE *.DOC
  (iii) B:\>DIR P*.BAT
  (iv) A:\>MD EXAMS
  

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

• List two disadvantages of hierarchical network topology.(Solved)
  

  List two disadvantages of hierarchical network topology.

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

• List two advantages of hierarchical network topology.(Solved)
  

  List two advantages of hierarchical network topology.

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

• State the functions of the tab key.(Solved)
  

  State the functions of the tab key.

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

• State the functions of the enter key.(Solved)
  

  State the functions of the enter key.

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

• State the functions of the shift key.(Solved)
  

  State the functions of the shift key.

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

• Name the application areas of simulation.(Solved)
  

  Name the application areas of simulation.

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

• What is meant by the term simulation?(Solved)
  

  What is meant by the term simulation?

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

• State three advantages of computer based simulation.(Solved)
  

  State three advantages of computer based simulation.

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

• Explain three ways in which computers have impacted on education.(Solved)
  

  Explain three ways in which computers have impacted on education.

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

• Briefly explain the classification of computer according to historical development (generations)(Solved)
  

  Briefly explain the classification of computer according to historical development (generations)

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

• Explain the following input/ output terms as used in computer systems. Give an example for each (a) Read (b) Write(Solved)
  

  Explain the following input/ output terms as used in computer systems. Give an example for each
  (a) Read
  (b) Write

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

• State any three functions of a computer(Solved)
  

  State any three functions of a computer

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

• Clearly define a computer.(Solved)
  

  Clearly define a computer.

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