Arrange the following steps in order of use in preparation of chart in excel.
(A) Create a basic chart using the pattern from the panel available on top of worksheet in Chart groups' option.
(B) Display or hide chart axes or gridlines
(C) Save a chart
(D) Enter data in a worksheet with proper column and row titles
Choose the correct answer from the options given below:
Answer & explanation
Correct answer: option 3
The correct answer is Option (3) → (D), (A), (B), (C)
A chart is drawn from data, so the data comes first and saving comes last; the layout of the chart is worked on in between. The book prints the steps in this order:
(D) Enter data in a worksheet with proper column and row titles
(A) Create a basic chart using the pattern from the panel available on top of worksheet in Chart groups' option.
(B) Display or hide chart axes or gridlines
(C) Save a chart
NCERT (2026-27 edition):
|
