Skip to main contentSkip to solution

Arrange the following steps in order to prepare a chart :

A. Move (resize) a chart and Save a chart.

B. Enter data in a worksheet with proper column and row titles and Create a basic chart using the pattern from the panel available on top of worksheet in Chart groups' option.

C. Show or hide a legend. Display or hide chart axes or gridlines.

D. Change the layout or style of chart and Add or remove titles or data labels.

Choose the correct answer from the options given below:

Solution

✅ Correct Option: 3

First enter the data with proper row and column titles and create the basic chart (B). Next change the layout or style and add or remove titles and data labels (D). Then set the legend, axes and gridlines (C). Finally move, resize and save the chart (A).

Keyboard Shortcuts

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