Get premium membership and access questions with answers, video lessons as well as revision papers.
(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
- What is a 'Worksheet?'(Solved)
Define a 'Worksheet'.
Date posted: April 9, 2018. Answers (1)
- What is a 'Cell?'(Solved)
Define a 'Cell' in relation to spreadsheets.
Date posted: April 9, 2018. Answers (1)
- What is a 'Workbook'(Solved)
Define a 'Workbook'
Date posted: April 9, 2018. Answers (1)
- What is a Graph(Chart) in relation to spreadsheets?(Solved)
Define a Graph(Chart) in relation to spreadsheets.
Date posted: April 9, 2018. Answers (1)
- What is 'automatic recalculation' as used in a spreadsheet?(Solved)
Explain the meaning of 'automatic recalculation' as used in a spreadsheet.
Date posted: April 9, 2018. Answers (1)
- What are the advantages of electronic spreadsheet over the traditional ledger book?(Solved)
Give the advantages of electronic spreadsheet over the traditional ledger book.
Date posted: April 9, 2018. Answers (1)
- Other than MS Excel, what other spreadsheet packages are available in the market?(Solved)
Other than MS Excel, list other examples of spreadsheet packages available in the market.
Date posted: April 9, 2018. Answers (1)
- What is a 'spreadsheet?'(Solved)
Define the word 'spreadsheet'
Date posted: April 9, 2018. Answers (1)
- What are the main types of spreadsheets?(Solved)
Highlight the main types of spreadsheets.
Date posted: April 9, 2018. Answers (1)
- What are 'Thumbnails?'(Solved)
Describe 'Thumbnails' as used in Microsoft word document.
Date posted: April 9, 2018. Answers (1)
- What is 'Print Layout/ Page layout view?'(Solved)
Explain the meaning of 'Print Layout/ Page Layout view'.
Date posted: April 9, 2018. Answers (1)
- What is 'Normal view'?(Solved)
Explain the meaning of 'Normal view' in Microsoft word document.
Date posted: April 9, 2018. Answers (1)
- What is 'Outline view?'(Solved)
Explain the meaning of 'Outline view'
Date posted: April 9, 2018. Answers (1)
- What is 'Web Layout/ Online layout view'?(Solved)
Explain 'Web layout/ Online layout view' of a Microsoft word document.
Date posted: April 9, 2018. Answers (1)
- What is 'Page orientation'?(Solved)
Describe the meaning of 'Page orientation'
Date posted: April 9, 2018. Answers (1)
- What is a 'Document?' (Solved)
Describe the meaning of a 'Document' as used in word processing.
Date posted: April 9, 2018. Answers (1)
- How can you print the first three pages of a document?(Solved)
Explain how to print the first three pages of a document.
Date posted: April 9, 2018. Answers (1)
- How can you print just the currently visible page of a document?(Solved)
Explain how to print just the currently visible page of a document.
Date posted: April 9, 2018. Answers (1)
- Outline three disk management activities.(Solved)
Outline three disk management activities.
Date posted: April 7, 2018. Answers (1)
- Why it is important to preview a document before sending it to the printer?(Solved)
Why it is important to preview a document before sending it to the printer?
Date posted: April 6, 2018. Answers (1)