Skip to main contentSkip to solution

What allows you to reposition or change the size of a chart on the worksheet?

Solution

✅ Correct Option: 2

When you click on a chart in a worksheet, resize handles (small squares or circles) appear at the corners and edges of the chart. These handles allow you to:

  • Drag the corner handles to resize the chart proportionally
  • Drag the edge handles to resize width or height independently
  • Click and drag the chart body to move it to a different position on the worksheet

This is the resize or move functionality that enables repositioning and size adjustment of charts.


The other options serve different purposes:

  • Format tab provides styling and formatting options
  • Data validation controls cell input restrictions
  • Freeze panes locks rows/columns while scrolling

Therefore, Option 2 (Resize or move option) is correct as it directly enables chart repositioning and resizing through the visual handles and drag functionality.

Keyboard Shortcuts

  • Left arrow: Previous question
  • Right arrow: Next question
  • S key: Jump to solution
  • Q key: Jump to question