The following worksheet represents the number of stems of various types of flowers exported in Ken Flower Ltd.

      

The following worksheet represents the number of stems of various types of flowers exported in Ken Flower Ltd.

Q1120820191108.png

The cost of each stem from the farmer is Kshs 25. This amount is typed in cell B10.

(a) Write a function that will calculate the total number of stems of all the types of flowers in all months.

(b) Write a formula that can be typed in cell E2 and then be copied down to obtain monthly purchases for Roses.

(c) Identify the data type in cell C1 and cell D3.

  

Answers


Maurice
(a) = Sum (B2:D5)


(b) = $B$10 * B2


(c)
-C1 – Label

-D3 - Value
maurice.mutuku answered the question on August 20, 2019 at 08:12


Next: A tank holding 1m3 of water is filled in 10 minutes by a circular pipe of diameter 2cm. Find the speed of water in the pipe.
Previous: A rectangular tank has a hole in it such that 11cm3 of water leaks out every 5 seconds.

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


Exams With Marking Schemes

Related Questions