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

In what areas are spreadsheets commonly used?

Give areas where spreadsheets are commonly used.

Answers

Maurice
(i) Forecasting: Through spreadsheets, users can have a projection that enables predicting of trends in the event of "What if analysis". For example, cash flows or budgeting.

(ii) Data Management: Spreadsheet enables data management tools such as sorting, filtering, use of forms for entries of data, subtotals and pivot tables/ charts.

(iii) Statistical analysis: Spreadsheets provide statistical data analysis tools such as finding averages, mean, ANOVA, trends and other inferential statistics.

(iv) Accounting: For recording the day to day transactions involving financial details such as calculating the profit and loss reports, preparing budgets or book keeping details.
maurice.mutuku answered the question on April 9, 2018 at 08:24

Answer Attachments

Next: What is a 'Worksheet?'

Previous: What are the methods of starting Ms Excel application stored in a computer? (Methods may vary depending on Operating System or Ms Office version)

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

Exams With Marking Schemes

Related Questions