Skip to content

ACCA Applied Knowledge · Management Accounting · Spreadsheets

A company records sales of 40, 55 and 75 units for three products in a table and wants a component bar chart in a spreadsheet showing each product's sales split between Region North and Region South. Which feature of a component (stacked) bar chart makes it suitable here?

A component bar chart shows each product's total as one bar and divides it into regional segments, so totals and composition can be seen together. Histograms use touching bars for continuous classes, and stacked charts can display absolute values, not only percentages.

  1. AEach bar's total is shown and split into its regional partsCorrect
  2. BEach region is plotted as a separate point against time
  3. CBars are drawn without gaps to show continuous class intervals
  4. DOnly the percentage of the grand total is shown, never absolute values

Explanation

A component bar chart stacks the regional segments within one bar per product, so both the total and the split are visible. Bars with no gaps describe a histogram. Stacked bars can show absolute values, so the last option is wrong.

Did you get it right without looking?

One question tells you little. A timed set on Spreadsheets shows your real accuracy, how long you take and where you lose marks.

Practise SpreadsheetsFree diagnostic mock

More Spreadsheets questions