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

      

The following information shows the income and expenditure for
“Bebayote” matatu for five days. The income from Monday to Friday was
Kshs 4,000, 9,000, 10,000, 15,000 and 12,000 respectively while the
expenditure for the same period was Kshs, 2,000, 3,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


Kavungya
i) fig2625620191253.png
ii) I. Monday’s profit = B4 – C4
II. Total income = Sum (B2: B6)
III. Highest expenditure = Max (B2: B6)
Kavungya answered the question on June 25, 2019 at 09:55


Next: Consider the linear arrays: (i) AAA (5:50) - (ii) BBB (5:10) - (iii) CCC (18) - Find the number of elements in each array
Previous: 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

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


Exams With Marking Schemes

Related Questions