While preparing chart on excel, arrange the following steps in the correct order.
A. Add or remove titles or data lables
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 can be built only on data that is already in the worksheet, and it is saved once its elements are set.
D. Enter the data in worksheet with proper column and row titles. — Step 1.
C. Create a basic chart using the pattern from the panel — Step 2.
A. Add or remove titles or data lables — Step 4, after the layout or style is chosen.
B. Show or hide a legend and chart axis — Steps 5 and 6.
E. Save the chart — the last step.
NCERT (2026-27 edition):
|
