Student Resources: Lesson Quizzes

Lesson 20: Using Data and Pivot Tables

	1.	A PivotTable report is a summary table that combines and compares data from a list.

		a.	TRUE
		b.	FALSE

	2.	Excel uses the __________ function when creating a data table.

		a.	AVERAGE
		b.	COUNT
		c.	SUM
		d.	TABLE

	3.	What PivotTable toolbar button updates the data in a PivotTable or PivotChart report if the source data has changed?

		a.	Format Report
		b.	PivotTable
		c.	Refresh Data
		d.	Show Detail

	4.	You can save memory by basing a new PivotTable on an existing one.

		a.	TRUE
		b.	FALSE

	5.	To create an interactive PivotTable for the Web, you use a Microsoft Office Web component called

		a.	HTML
		b.	PivotTable Field list
		c.	PivotTable List
		d.	PivotTable report