Excel - Lesson 12: Charts

John wants to create a chart that shows trends of sales for four quarters. What type of chart should he create?

• PivotChart
• Line Chart
• Embedded Chart
• Linked Chart

What is the purpose of the -/+ buttons that appear across the categories on a PivotTable?

• Decrease/Increase
• Collapse/Expand
• Reduce/Add
• Subtract/Add

Dorothy designed a column chart and would like to change the background color to yellow. Which chart feature would she modify?

• Axis Title
• Chart Title
• Gridlines
• Plot Area

What graphically represents trends in plotted data and predicts future values?

• Sparkline
• Trendline
• Chartline
• Error bar

Leigh Ann designed a bar chart and would like to add an element above the chart to make the data more meaningful. Which chart feature would she need to include?

• Axis
• Chart Title
• Data Label
• Legend

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

• Gridelines
• Arrows
• Pictures
• Labels

Which is the name of an interactive graphical representation of data that allows a user to change the groupings?

• PivotChart
• PivotTable
• PivotDate
• Rotate Table

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

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

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

• Style
• Design
• Format
• Layout

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