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?

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

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

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

When creating a PivotTable, which are drawn in columns in the worksheet data?

John wants to add text effects to his PivotChart. Which PivotTable Chart Tools tab would he use?

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

Which of the following is the default method for summarizing data in a PivotTable?

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

In order to directly report the data, what must a PivotChart always be associated with?

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

What is the process of viewing a PivotTable report for a subset that meets the criterion only?

Which ribbon is visible when a PivotTable is selected, and allows a user to apply various styles to the PivotTable?

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

Which Chart Tools Ribbon tab allows a user to insert various labels on the chart?

On a PivotTable, what is a field with values not entered as data but determined by a computation involving data in other fields called?

John wants to be able to view his monthly sales chart as well as his data on the same worksheet. What type of chart should he create?