Practicing Success

Target Exam

CUET

Subject

Accountancy

Chapter

Graphs and Charts for Business Data

Question:

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-

Options:

D, C, A, B, E

D, A, C, B, E

D, C, A, E, B

D, C, E, A, B

Correct Answer:

D, C, A, B, E

Explanation:

The steps to prepare a chart are as follows :
Step 1 - Begin by inputting the data into a worksheet, ensuring that you have appropriate column and row titles.
Step 2 - Create the foundational chart by selecting a pattern from the chart groups' options located at the top of the worksheet.
Step 3 - Customize the chart's appearance and style. Apply a predefined chart layout and style. Adjust the layout of chart elements and modify their formatting.
Step 4 - Add or remove titles and data labels as needed. This includes adding or removing a chart title, axis titles, and linking a title to a cell in the worksheet. You can also add or remove data labels.
Step 5 - Decide whether to display or hide a legend.
Step 6 - Choose to show or hide chart axes and gridlines. You can opt to display or hide primary and secondary axes as well as gridlines.
Step 7 - Arrange the chart by moving or resizing it to fit your desired location.
Step 8 - Don't forget to save the chart to preserve your work.