Which of the following is the most suitable spreadsheet feature for checking whether a cell showing total profit has been calculated from the correct inputs?
Answer and explanation
Correct answer: C. Tracing the precedent cells that feed the formula
- Step 1: To audit a formula we need to see which cells it depends on.
- Step 2: Trace precedents highlights the input cells.
- Step 3: The other features address presentation, security and ordering.
Answer
Tracing the precedent cells that feed the formula.
Why not the others: Applying a number format to the cell: A number format changes how the value looks and not how it is calculated. Protecting the sheet with a password: Protection stops unauthorised changes but does not show where a figure comes from. Sorting the data in ascending order: Sorting rearranges rows and could even break relationships between cells.
Practise more Data analysis and statistical techniques.
Free questions with an explanation for every one, and full timed ACCA Applied Knowledge (BT, MA, FA) mock tests.
More Data analysis and statistical techniques questions
- A researcher wants a sample from a population of employees in which each department is represented in proportion to its size. Which sampling…
- Which of the following sampling methods is a non-probability method?
- The monthly sales (in £000) for five months are 12, 15, 11, 15, 17. What are the mean and the median?
- The correlation coefficient between advertising spending and sales is calculated as +0.92. What does this indicate?
- A regression of total cost (y, in £) on units produced (x) gives y = 12,000 + 3.5x. What is the forecast total cost for 4,000 units?
- A coefficient of determination (r²) of 0.64 has been found for a regression of sales on advertising. Which interpretation is correct?