Excel Lesson 12 Pt.1

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

• style
• design
• layout
• format

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

• Total field
• AutoSum
• Calculated field
• Analyzed field

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

• gridlines
• arrows
• pictures
• labels

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

• silvers
• partials
• slicers
• movers

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

• slicer
• cutter
• division
• sliver

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 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

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

• count
• average
• max
• sum

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?

• report filter
• legend fields
• axis fields
• values

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

• records
• fields
• cells
• ranges