excel class quiz

To set up a Pivot Table with years listed vertically as shown above, the Year field should be dragged into the following Pivot Area:

• 
  

  FILTERS

• COLUMNS

• 
  

  ROWS

• VALUES

To set up a Pivot Table with years listed horizontally as shown above, the Year field should be dragged into the following Pivot Area:

• FILTERS

• COLUMNS

• ROWS

• VALUES

In 2008, how many medals were won by women athletes?

The Line Chart above shows the data trends for three different datasets. Which dataset has the highest values for the months in the 3rd quarter of the year (months 7, 8, and 9)?

• Dataset A

• 
  

  Dataset B

• Dataset C

• No data is shown for the 3rd quarter of the year

Which function allows you to perform calculations on the values in a pivot table?

• SUMIF

• VLOOKUP

• PivotTable Function

• None of the above

What is the primary purpose of a pivot table in Excel?

• To create charts and graphs

• To sort and filter data

• To summarize and analyze data

• To calculate complex mathematical formulas

In a pivot table, which area is used to define the row labels or categories for your analysis?

• Values area

• Columns area

• Rows area

• Filters area

When you want to filter the data in a pivot table to show only specific items, where do you apply the filters?

• Rows area

• Values area

• Filters area

• Columns area

What is the purpose of the "Column Labels" area in a pivot table?

• To display the grand total of the data

• To arrange the column headings

• To apply conditional formatting

• To filter data

In a pivot table, what is the purpose of the "Values" area?

• To apply number formatting

• To arrange the row labels

• To display summary values or calculations

• To filter data