Microsoft Excel 2021365 - Beginner to Advanced - Exercise 10 - create and edit a chart

The video tutorial guides viewers through formatting data as a table, naming it, and applying filters to display the top five students in physics. It then instructs on creating a 2D clustered column chart and customizing it by adding a title, moving the legend, adding axis and data labels, changing bar colors, and adding a trend line. A practical demonstration follows, showing each step in detail.

What is the first step in preparing the data for chart creation?

• Format the data as a table

• Create a pie chart

• Change the color of the data bars

• Add a trend line

After creating a 2D clustered column chart, what is the next formatting step?

• Apply a filter

• Change the color of the data bars

• Add a trend line

• Add a chart title

Where should the legend be moved in the chart?

• To the bottom

• To the left

• To the right

• To the top

What should be added to the chart to indicate the trend of the physics marks?

• A scatter plot

• A pie chart

• A trend line

• A new data series

Which of the following is NOT a step in the advanced chart formatting section?

• Creating a table

• Changing the color of data bars

• Adding axis labels

• Adding data labels