While preparing chart on excel, arrange the following steps in the correct order.
A) Add or remove titles or data labels
B) Show or hide a legend and chart axis
C) Create a basic chart using the pattern from the panel
D) Enter the data in worksheet with proper column and row titles
E) Save the chart
Choose the correct answer from the options given below-
Answer & explanation
Correct answer: option 1
The correct answer is Option (1) → D, C, A, B, E
A chart is built from data already entered, then refined, then saved last. The book’s steps:
(D) Enter the data in the worksheet with proper column and row titles
(C) Create a basic chart using the pattern from the panel
(A) Add or remove titles or data labels
(B) Show or hide a legend and chart axis
(E) Save the chart
NCERT (2026-27 edition):
|
