Microsoft Excel 2021365 - Beginner to Advanced - Highlighting Cell Values

The video tutorial guides viewers through formatting data as a table, naming it, and applying filters to display the top five physics students. 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 trendline. The tutorial provides a step-by-step approach to ensure the chart is visually informative and accurately represents the data.

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 data bars

• Add a trend line

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

• Use a text filter

• Sort the data alphabetically

• Apply a number filter for the top five

• Remove all filters

What type of chart is created to display the top five students?

• 2D clustered column chart

• Bar chart

• 3D pie chart

• Line chart

Where should the legend be positioned in the chart?

• At the top, under the title

• At the bottom

• On the left side

• On the right side

What is the purpose of adding a trend line to the chart?

• To change the color of the bars

• To show the trend of the physics marks

• To add more data labels

• To move the legend