Mastering Excel Charts

What is the first step in creating a bar chart in Excel 2019?

• Select the chart type from the Insert tab

• Highlight the data you want to include in the chart

• Click on the Chart Tools Design tab

• Adjust the chart layout

Which of the following chart types is best used to show proportions of a whole?

• Bar Chart

• Line Chart

• Pie Chart

• Scatter Plot

How can you change the color of a data series in a line chart?

• Use the Chart Styles option

• Right-click the data series and select Format Data Series

• Click on the Chart Elements button

• Adjust the chart layout

What is the purpose of the Chart Elements button in Excel 2019?

• To change the chart type

• To add or remove elements like titles, labels, and legends

• To format the data series

• To adjust the chart size

Which option allows you to quickly change the overall look of a chart?

• Chart Styles

• Chart Elements

• Format Data Series

• Chart Layouts

What is the best use of a sparkline?

• To compare different categories

• To show trends over time

• To display parts of a whole

• To show relationships between variables

How can you add data labels to a pie chart?

• Use the Chart Styles option

• Click on the Chart Elements button and select Data Labels

• Right-click the chart and select Format Chart Area

• Adjust the chart layout

What is the function of the Format Data Series option?

• To change the chart type

• To adjust the appearance of a specific data series

• To add chart elements

• To change the chart layout

Which of the following is NOT a chart element you can adjust in Excel 2019?

• Chart Title

• Data Table

• Axis Titles

• Worksheet Name

How do you change the layout of a chart in Excel 2019?

• Use the Chart Styles option

• Click on the Chart Elements button

• Select a layout from the Chart Layouts group

• Right-click the chart and select Format Chart Area