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


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