For which purpose the Column charts are useful?

Both options 1 & 2

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.