Practicing Success

Target Exam

CUET

Subject

Accountancy

Chapter

Graphs and Charts for Business Data

Question:

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:

Options:

(A), (B), (C), (D), (E)

(A), (B), (D), (C), (E)

(A), (B), (C), (E), (D)

(A), (B), (E), (C), (D)

Correct Answer:

(A), (B), (E), (C), (D)

Explanation:

Following are the steps prepare a chart:

Step – 1: Enter data in a worksheet with proper column and row titles.

Step – 2: Create a basic chart using the pattern from the panel available on top of worksheet in Chart groups’ option.

Step – 3: Change the layout or style of chart.
               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

Step – 8: Save a chart