What ribbon contains the commands for creating charts in Microsoft Excel?

John wants to change the chart style on his PivotTable. Which PivotTable chart tools tab would he create?

NCCTE.9_12.BE.BM20.1.12

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?

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

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

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

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 has created a PivotChart 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?

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

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?

Which tab in the PivotChart Tools Ribbon allows a user to apply chart style to the PivotChart?

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

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

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

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

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

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?

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

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

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

What can you use to easily filter PivotTables and cube functions interactively in a worksheet?

Dorothy designed a column chart and would like to add an element that will help lead the eye and improve readability of the chart. Which chart feature should she include?

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

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

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

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

What term refers to an Excel Chart with offset pieces?

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?

What are graphical objects that contain buttons a user can click to filter the data in PivotTables and PivotCharts?

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?

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

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

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

In Microsoft Excel, which tab is used to add shape effects to a chart?