Target Exam

CUET

Subject

-- Accountancy Part C

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:

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)