The correct answer is option 1- D, C, A, B, E.
The steps to prepare a chart are as follows :
Step 1 (D)- Begin by inputting the data into a worksheet, ensuring that you have appropriate column and row titles.
Step 2 (C) - 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 (A) - 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 (B)- 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 (E) - Don't forget to save the chart to preserve your work. |
