Charts & Graphs in Spreadsheet

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

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

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

• Gridelines
• Arrows
• Pictures
• Labels

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

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

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

This part of the chart is usually vertical and contains data.

• Y axis

• X axis

• Legend

• Chart title

This part of the chart is usually horizontal and contains categories.

• X axis

• Y axis

• Legend

• Chart title

If you want to select two columns that are NOT next to each other to create a chart, hold down the ____ key on your keyboard.

• Ctrl (Control)

• Alt (Alternate)

• Shift

• Fn (Function)

According to this chart, which type of pork do people prefer most?

• Bacon

• Ribs

• Ham

• Other