Management Accounting · Presenting information

Spreadsheets and Presentation Software in Management Accounting

Updated 11 October 2026 · Fact-checked

A spreadsheet is a grid of cells that stores numbers and text and recalculates results using formulae and functions. Databases store and retrieve large sets of records. Presentation software communicates findings to an audience. In MA objective tests you choose the right tool, formula, chart or advantage or disadvantage for a scenario.

Understand Spreadsheets and Presentation Software

A spreadsheet is a grid of rows and columns. Each box is a cell, named by its column letter and row number, such as B3. A cell can hold a label, a number or a formula. Because formulae link cells, changing one input updates every result that depends on it.

This makes spreadsheets ideal for budgets, cost schedules, variance calculations, cash flow forecasts and what-if analysis. You change an assumption, such as sales volume, and see the effect on profit at once. Common features are formulae, built-in functions (SUM, AVERAGE, IF, VLOOKUP), sorting and filtering, charts, and multiple worksheets that can be linked.

A database is different. It stores structured records in related tables, such as customers, products and orders. Its strength is storing large volumes of data and retrieving it with queries and reports, with many users working on the same data. A spreadsheet is better for calculation and analysis; a database is better for storage and retrieval.

Presentation software is used to communicate results, usually as slides with text, tables, charts and images. It is for the audience, not for calculation. Good slides are brief, focused on key messages and use the right chart for the data.

Spreadsheets have advantages: speed, accuracy of calculation, easy updating, what-if analysis and clear charts. They have disadvantages: errors in formulae or data entry that go unnoticed, poor version control, limited security, and weak suitability for very large data sets or many simultaneous users. Errors often come from a human mistake, not the software.

Key formulas to remember

Start of a formula: = (equals sign); Every formula begins with =. Without it, the cell is treated as text.
Sum of a range: =SUM(B2:B10); Adds all cells from B2 to B10. The colon means 'from ... to'.
Average of a range: =AVERAGE(B2:B10); Gives the arithmetic mean of the values in the range.
Conditional result: =IF(test, value if true, value if false); Example: =IF(B2>C2,"Over","Within") flags an overspend.
Lookup: =VLOOKUP(lookup value, table, column number, FALSE); Finds a value in the first column of a table and returns data from another column. FALSE means exact match.
Relative and absolute references: B2 (relative); $B$2 (absolute); Relative references change when copied. Absolute references with $ stay fixed, e.g. a fixed tax rate or overhead rate.
Order of calculation: Brackets, then ×/÷, then +/−; =2+3*4 gives 14, not 20. Use brackets to force the order you want.

How to solve Spreadsheets and Presentation Software questions

Use this method for any question on spreadsheets, databases or presentation tools.

1Read the scenario and identify the task: calculate, store and retrieve, or communicate.
2Match the task to the tool: spreadsheet for calculation and what-if, database for large structured records, presentation software for audiences.
3If a formula is involved, check it starts with =, uses the right function and has correct cell references.
4Decide whether references should be relative or absolute. If the cell must not move when copied, it needs $.
5For chart questions, match the chart to the data: trends over time use a line chart, parts of a whole use a pie chart, comparisons use a bar chart.
6For advantages or disadvantages, tie each point to the scenario, such as speed of updating or risk of undetected error.
7Check the answer for the exact number of options required, then confirm your choice against the wording.

Quickest way: Tool, formula, chart: three-second check

When to use it: Use for multiple choice and multiple response items where you must pick the right tool, function or chart.

Underline the verb in the question: calculate, store, look up, show a trend, present.
Pick the tool: calculate means spreadsheet, store means database, present means slides.
For functions: add means SUM, mean means AVERAGE, decide means IF, find in a table means VLOOKUP.
For charts: time means line, share means pie, compare means bar.
Eliminate options that are true in general but do not answer the question asked.

Common mistakes in Spreadsheets and Presentation Software

Writing a formula without the equals sign.
Students think of the formula as a normal sum on paper.
Fix: Remember that every spreadsheet formula starts with =. Otherwise the cell shows text.
Using a relative reference where an absolute one is needed.
The formula works in the first cell, so the student copies it without checking.
Fix: If a rate or total must stay fixed when copied, lock it with $, for example $B$1.
Saying spreadsheets are always accurate.
Computers calculate correctly, so students assume the results are correct.
Fix: The software calculates what you tell it. Wrong formulae or wrong input data give wrong answers.
Confusing a database with a spreadsheet.
Both show data in rows and columns.
Fix: A spreadsheet is for calculation and analysis. A database is for storing and retrieving large linked sets of records.
Choosing a pie chart for data over time.
Pie charts look familiar and attractive.
Fix: Use a line chart for trends over time. Use a pie chart only for parts of one whole.
Ignoring brackets in a formula.
Students forget that multiplication and division come before addition and subtraction.
Fix: Add brackets to show the order you want, such as =(B2+B3)*C2.

Worked examples

Example 1

Cell B1 holds a fixed overhead absorption rate of $4 per hour. Cells A3 to A5 hold labour hours of 100, 150 and 200. A formula in B3 is =A3*B1 and is copied down to B5. What does B4 calculate, and how should the formula be corrected?

Show the solution

When copied down one row, relative references move down one row.
In B4 the formula becomes =A4*B2.
A4 is 150 hours, which is correct.
B2 is empty or a different cell, not the rate, so the result is wrong.
The rate must stay in B1, so lock it as $B$1.
The corrected formula in B3 is =A3*$B$1, which copies as =A4*$B$1 and =A5*$B$1.

Answer: B4 would calculate =A4*B2, which gives the wrong result. Use =A3*$B$1 in B3 and copy down. The results are $400, $600 and $800.

Example 2

A management accountant must (i) total monthly costs in a budget, (ii) store details of 50,000 customer orders with many users accessing them, and (iii) show the board how sales moved over the last 12 months. Which tool and chart suit each task?

Show the solution

Task (i) is calculation, so use a spreadsheet with =SUM.
Task (ii) is storing and retrieving a large volume of linked records for many users, so use a database.
Task (iii) is communicating to an audience, so use presentation software.
The data in (iii) is a trend over time, so a line chart is the best choice.

Answer: (i) Spreadsheet with SUM; (ii) database; (iii) presentation software with a line chart.

Exam tips

Learn the main functions: SUM, AVERAGE, IF and VLOOKUP. Questions often ask which one fits a task.
In disadvantage questions, think errors, version control, security and size limits, not just 'it is slow'.
Watch the number of answers required in multiple response questions. Select exactly that many.
For copied formulae, trace where each reference moves. Test the second cell, not the first.
Match chart type to data. Time means line, share of a whole means pie, comparison means bar.

Practice questions from Presenting information

Spreadsheets and Presentation Software: frequently asked questions

What are the main features of a spreadsheet for ACCA MA?

The main features are formulae, built-in functions, sorting and filtering, charts, and linked worksheets. Together they allow fast calculation and what-if analysis. You should be able to match each feature to a task.

What are the advantages and disadvantages of spreadsheets?

Advantages include speed, easy updating, what-if analysis and clear charts. Disadvantages include undetected formula or entry errors, poor version control, limited security and weakness with very large data. Always link the point to the scenario.

How are spreadsheets used in management accounting?

They are used to prepare budgets, cost schedules, variance calculations and forecasts. Changing an input updates all linked results. This lets managers test different assumptions quickly.

What is the difference between relative and absolute references?

A relative reference such as B2 changes when you copy the formula. An absolute reference such as $B$2 stays fixed. Use absolute references for constants like rates.