Student Resources: Lesson Quizzes

Lesson 8: Building Charts

	1.	A chart that appears on the same sheet as the worksheet data is called an __________ chart.

		a.	Absolute
		b.	Automatic
		c.	Edited
		d.	Embedded

	2.	When you select a chart, the __________ menu is replaced by the Chart menu.

		a.	Insert
		b.	Format
		c.	Tools
		d.	Data

	3.	What Excel chart object is the rectangular area bounded by the category and value axes?

		a.	Chart area
		b.	Data point
		c.	Legend
		d.	Plot area

	4.	What Chart toolbar button opens the format dialog box for the selected object in the chart?

		a.	Chart Objects
		b.	Chart Type
		c.	Data Table
		d.	Format Object

	5.	What chart type shows trends in data over a period of time?

		a.	Bar
		b.	Column
		c.	Line
		d.	Surface