Excel Lesson 12

John wants to add text effects to his PivotChart Tools tab would he use?

• Design
• Layout
• Format
• Analyze

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

• Home Ribbon
• Insert Ribbon
• Formula Ribbon
• Data Ribbon

Which Chart Tools Ribbon tab allows a user to select from a gallery of chart styles?

• Style
• Design
• Layout
• Format

John would like to display the count of employee last names in the Y-axis of a PivotChart. What area would he drag this information to in order to display correctly?

• Report Filter
• Legend Fields
• Axis Field
• Values

John has created a Pivot chart and would like to include a guide that would display the names of the series of data included on the chart. Which option would allow him to do this?

• Report Filter
• Legend Fields
• Axis Field
• Values

What term refers to an Excel Chart with offset pieces for emphasis?

• Exploded
• Shattered
• Separated
• Detached

Which is a tiny chart that provides a visual representation of data in a worksheet cell?

• Trendline
• Sparkline
• Dataline
• Flashpoint

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

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

Which is an interactive view of worksheet data that gives a user the ability to summarize the data by selecting categories for grouping?

• PivotChart
• PivotTable
• Pivotdate
• Rotate Table