Student Resources: Lesson Quizzes

Lesson 16: Using Data Consolidation and Linking

	1.	You can consolidate data by position when the values are in the same locations on each worksheet.

		a.	TRUE
		b.	FALSE

	2.	You can open the Consolidate dialog box by choosing Consolidate from the __________ menu.

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

	3.	A dynamic consolidation summarizes the values and enters a resulting value.

		a.	TRUE
		b.	FALSE

	4.	You can display formulas by pressing

		a.	Alt + ~
		b.	Ctrl + ~
		c.	Ctrl + Alt + ~
		d.	Shift + ~

	5.	The dependent workbook is the file containing information obtained from other workbooks.

		a.	TRUE
		b.	FALSE