Trusted by millions of Kenyans
Study resources on Kenyaplex

Get ready-made curriculum aligned revision materials

Exam papers, notes, holiday assignments and topical questions – all aligned to the Kenyan curriculum.

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

Answer Attachments

Exams With Marking Schemes

Related Questions