For which purpose the Column charts are useful?
Answer & explanation
Correct answer: option 3
The correct answer is option 3- Both options 1 & 2.
Column charts in Excel are effective for:
1) Showing data changes over a period of time – by displaying trends or changes across time intervals (e.g., months, years).
2) Illustrating comparisons among items – By comparing values across categories (e.g., sales by department).
So, column charts are ideal when we want to visualize trends and make comparisons between different data points.