Skip to main contentSkip to solution

Steps in preparing a chart:

A. Create a basic chart using the pattern from the panel available on top of worksheet in Chart groups option.

B. Change the layout or style of chart

C. Enter data in a worksheet with proper column and row titles.

D. Add or remove titles or data labels.

Choose the correct answer from the options given below:

Solution

✅ Correct Option: 3

Data must exist before a chart can be drawn, so entry of data comes first (C), then the basic chart is inserted from the Charts group (A), then its layout or style is changed (B), and finally titles and data labels are added or removed (D).

Keyboard Shortcuts

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