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 a filter to display the top five students based on their physics marks. It then demonstrates creating a 2D clustered column chart and formatting it by adding a title, moving the legend, adding axis and data labels, changing data bar colors, and adding a trendline. The tutorial concludes with a step-by-step demonstration of these tasks.

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

• Add a trend line

• Apply a filter to the data

• Create a 2D clustered column chart

• Format the data as a table

How do you filter the data to show only the top five students?

• Use the top ten filter and adjust to five

• Manually select the top five rows

• Sort the data in descending order

• Use a custom filter for top five

Where should the legend be placed in the chart?

• On the right side

• At the top, under the title

• At the bottom

• On the left side

What is the purpose of adding data labels to the chart?

• To change the color of the bars

• To display the exact values on the chart

• To add a trend line

• To move the legend

What is the final step in the chart creation process?

• Change the color of the data bars

• Move the legend

• Add a trend line

• Add axis labels