What allows you to reposition or change the size of a chart on the worksheet?
Answer & explanation
Correct answer: option 2
The correct answer is Option (2) → Resize or move option
Once a chart is placed on a worksheet, it can be moved to another spot or resized by selecting it and dragging it or the handles on its corners and borders. This is the “Move (resize) a chart” step of preparing a chart.
Option (1) Format tab — Incorrect. The Format tab changes the look of chart elements (shape styles, effects, colours), not where the chart sits.
Option (3) Data validation — Incorrect. Data validation restricts what can be entered in a cell; it has nothing to do with charts.
Option (4) Freeze panes — Incorrect. Freeze panes keeps chosen rows or columns visible while scrolling the worksheet; it does not move or resize a chart.
NCERT (2026-27 edition):
NCERT (2026-27 edition): |
