Topic 2E: Data and Presenting Information: Reports and Spreadsheets

Question 1

What is the essence of a spreadsheet?

Answer 1

Basic tool of accountants to record and manipulate management information

Question 2

What are some common applications of spreadsheets?

Answer 2

• Preparation of management accounts
• Cash flow analysis, budgeting and forecasting
• Account reconc
• Revenue and cost analysis
  Comparison and variance analysis
  Sorting, categorising and filtering large volumes of data