Excel Chart Lesson

Charts in Excel

Write the following slide

Chart Types

​Chart Elements

Answer these questions

Multiple Choice

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

• Format the chart

• Select the data to include in the chart

• Close the Excel program

• Save the chart

Multiple Choice

John wants to identify the exact value that each column in his chart represents. Which option should he choose?

• Gridelines
• Arrows
• Pictures
• Labels

Multiple Choice

What should Steffon and Xena do if they want to change the chart type in Microsoft Excel?

• Select Data > Sort

• Select Chart Design > Change Chart Type

• Select Home > Conditional Formatting

• Select Review > Thesaurus

Multiple Choice

Looking at the image, what is the Vertical Axis Title?

• Score

• There's a Vertical Axis?

• Blue

• Banana

Fill in the Blanks

Looking at the image, what range of data was used to make this chart?

Multiple Choice

A chart can be moved to a separate sheet.

• True
• False

Multiple Choice

What ribbon contains the commands used to create a chart in Excel?

• Home Ribbon
• Insert Ribbon
• Formulas Ribbon
• Data Ribbon

Multiple Choice

Which Chart Tools Ribbon tab enables a user to apply a style to the selected chart?

• Style
• Design
• Format
• Layout

Multiple Choice

Explain the steps to insert a chart into an Excel worksheet.

• Select the data, go to the 'Format' tab, click on 'Chart', and customize as needed

• Right-click on the data, select 'Copy', go to the 'Insert' tab, and click on 'Chart'

• Open a new worksheet, paste the data, and then click on 'Chart' in the 'Insert' tab

• Select the data, go to the 'Insert' tab, click on 'Chart', and customize as needed

Multiple Choice

Edward would like to create a chart that shows the trend in iPod sales over the past 2 years. Which chart type should he create?

• Bar
• Column
• Line
• Pie

Multiple Choice

Edward would like to create a chart that uses vertical rectangles to compare iPod and iPad sales. Which chart type would he create?

• Bar
• Column
• Line
• Pie

Multiple Choice

What is typically included in the range of data selected to create a chart?

• Titles only
• Numeric data and totals only
• Numeric data, totals, and titles
• Numeric data and titles

Multiple Choice

Leigh Ann designed a bar chart and would like to add an element to the right of the chart that identifies each bar's color. Which chart feature would she need to include?

• Axis
• Chart Title
• Data Label
• Legend

Multiple Choice

Name three types of charts that can be created in Excel.

• Column Chart, Line Chart, Pie Chart

• Histogram, Box Plot, Waterfall Chart

• Line Chart, Radar Chart, Bubble Chart

• Bar Chart, Scatter Chart, Area Chart

Multiple Choice

What is the difference between a bar chart and a column chart in Excel?

• A bar chart has diagonal bars, while a column chart has vertical bars.

• A bar chart has wavy bars, while a column chart has zigzag bars.

• A bar chart has horizontal bars, while a column chart has vertical bars.

• A bar chart has circular bars, while a column chart has square bars.

Multiple Choice

What is the significance of adding a chart title and axis labels in Excel?

• It provides context and clarity to the data being presented in the chart.

• It allows for easier data entry into the chart

• It helps in reducing the file size of the Excel document

• It makes the chart look more colorful and attractive