Trusted by millions of Kenyans
LoginRegister
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.

Browse exam papers
Or go directly to:
Class notes Holiday assignments Topical questions Other resources

Study the spread sheet below and answer the questions that follow. i)Write down the function that can be used to find price of most costly book....

Study the spread sheet below and answer the questions that follow.
fig581020191226.png
i)Write down the function that can be used to find price of most costly book.
ii)Write down the formula that can be used to determine the total sales for the book titled COMMUTER
iii)Write down the function that can be used to determine the average price of the books in cell D10.
iv)Write down the formula in cell D3 that can be used to calculate new price for DBASE IV
if the price went up by a percentage written in B10 (5%).
v)State any two advantages of using an electronic spread sheet as compared to a traditional spread sheet.

Answers

Kavungya
i)= MAX (C3 : C9)
ii)= C9: B9
iii)= AVERAGE (D2: D9)
iv)= B10*400 + 400
v)Automatic recalculation
Utilises the powerful aspects of comp such as speed, accuracy and efficiency.
Have inbuilt functions
Enable users to produce neat work
Kavungya answered the question on October 8, 2019 at 09:27

Answer Attachments

Next: Nomino zifuatazo ni za ngeli gani? i) Nzi ii) Soksi

Previous: Saidi : Hallo............Hallo....Huyo ni Bw. Mohamed?Mohamed : Ndio...uko wapi...Saidi : Shuleni...sasa...ulinifikishia ujumbe?Mohamed : La. Parade ilikuwa imehitimishwaSaidi : Sina credit. Nipigie tafadhali.Mohamed : Sina...

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

Exams With Marking Schemes

Related Questions