What Does the Filters Area of a PivotTable Do

question 48

Multiple Choice

What does the Filters Area of a PivotTable do?

• A)Subdivides data into one or more additional categories
• B)Filters the data to display results based on particular conditions you set
• C)Organizes and groups data into categories on the left side.Each group
• Name occupies a single row
• D)Displays summary statistics,such as totals or averages

---

Definitions:

Direct Labor Standards

The expected labor time and cost that should be incurred under normal conditions to produce a unit of output.

Labor Rate Variance

The difference between the actual cost of direct labor and the estimated cost of direct labor at standard rates for the production achieved.

Labor Efficiency Variance

The difference between the actual hours worked to produce goods and the standard hours expected, multiplied by the standard labor rate, indicating efficiency in labor use.

Material Price Variance

The variance between the real price paid for materials and their anticipated (standard) price.