Spreadsheets

Question 1

What can spreadsheets be used for?

Answer 1

• Can be used to prepare Cash Budgets.
• Can be used to prepare Inventory Record Cards
• Can be used to prepare Overhead Analysis Statements

Question 2

What are the benefits of spreadsheets?

Answer 2

• Calculations, with the use of formulae, are more accurate than manual.
• Can show the effects of ‘What if’ scenarios and use this technique for forecasting.
• Can use templates with formulae already inserted.
• Calculations are updated automatically provided formulae have been inserted.
• Worksheets can be linked together with information easily being transferred from one to another.
• Information can be converted to graphs/charts for presentation purposes.

Question 3

What are the costs of spreadsheets?

Answer 3

• Installation costs
• Staff training costs
• ## Maintenance and repair costs