Arrange the following steps related to the preparation of a chart in sequence, in case of CAS.
(A) Enter data in a worksheet with proper column and row titles
(B) Create a basic chart using the pattern from the panel available
(C) Move (resize) a chart.
(D) Save a chart
(E) Change the layout or style of chart
Choose the correct answer from the options given below:
Answer & explanation
Correct answer: option 4
The correct answer is option 4- (A), (B), (E), (C), (D).
Following are the steps prepare a chart:
Step – 1: Enter data in a worksheet with proper column and row titles. (A)
Step – 2: Create a basic chart using the pattern from the panel available on top of worksheet in Chart groups’ option. (B)
Step – 3: Change the layout or style of chart. (E)
Apply a predefined chart layout.
Apply a predefined chart style.
Change the layout of chart elements.
Change the format of chart elements.
Step – 4: Add or remove titles or data labels.
Add (Remove) a chart title.
Add (Remove) axis titles.
Link a title to a worksheet cell.
Add (Remove) data labels.
Step – 5: Show or hide a legend.
Step – 6: Display or hide chart axes or gridlines.
Display (hide) primary axes
Display (hide) secondary axes
Display (hide) gridlines
Step – 7: Move (resize) a chart (C)
Step – 8: Save a chart (D)