Click on the correct response for each question below.

1		This worksheet provides an outline listing the total sales for the year or the total sales by quarter.
			A)	Summary
			B)	Grand total
			C)	Index
			D)	Comprehensive
2		In the Move or Copy dialog box, the To book: names the
			A)	referenced workbook.
			B)	source worksheet.
			C)	destination worksheet.
			D)	target workbook.
3		This is the menu command used to add a new worksheet to a workbook.
			A)	Format, Worksheet
			B)	Tools, Worksheet
			C)	File, Worksheet
			D)	Insert, Worksheet
4		To select the worksheets for grouping, use this key.
			A)	SHIFT
			B)	ALT
			C)	CTRL
			D)	ENTER
5		This is the best way to copy one or more formulas to more than one worksheet.
			A)	Copy the formulas to open worksheets.
			B)	Use the Insert feature on the menu bar.
			C)	Copy the formulas to grouped worksheets.
			D)	Use the Tools feature on the menu bar.
6		This is the menu command used to remove page breaks in a worksheet.
			A)	View, Options, View
			B)	Format, Options, View
			C)	Window, Options, View
			D)	Tools, Options, View
7		In the 3-D expression, =SUM (West Lafayette !B2:E14), there needs to be
			A)	apostrophes placed around the West Lafayette name.
			B)	a space between the = and SUM.
			C)	a space between the ( and West, as well as 14 and ).
			D)	an exclamation point after E14.
8		In the expression, =SUM ('Ford:West Lafayette' !B2:B14), the B2:B14 is
			A)	a summary of cells.
			B)	a range of cells in a range of worksheets.
			C)	an absolute reference to all worksheets.
			D)	a reference to the Ford worksheet.
9		To print all worksheets in a workbook,
			A)	click the Entire workbook option in the Print what panel.
			B)	group the worksheets and then select the Entire workbook in the Print what panel.
			C)	open all worksheets and then select the Entire workbook in the Print what panel.
			D)	close all worksheets and then select the Entire workbook in the Print what panel.
10		You do this to a workbook name to distinguish the workbook name from both the path preceding it and the worksheet name that follows it.
			A)	Use brackets
			B)	Use parentheses
			C)	Use exclamation points
			D)	Use apostrophes
11		When formulas are created that reference cells in other worksheets, the referenced workbooks are linked to the worksheet containing the reference to other workbooks.
			A)	True
			B)	False
12		Each worksheet in a workbook can have its own margin settings, page header and footer, print area, and other worksheet-specific settings.
			A)	True
			B)	False
13		In the Move or Copy dialog box, selecting Create a Copy will ensure that the worksheet is copied, not moved, from the original workbook.
			A)	True
			B)	False
14		Worksheets can be grouped before you enter information that is common to multiple sheets so that when the information is entered, it is entered in one operation.
			A)	True
			B)	False
15		The ALT key is used to select noncontiguous worksheets for grouping.
			A)	True
			B)	False
16		Formatting a cell or cell range in the active worksheet of a group of worksheets will also format the same cell or cell range in all group worksheets.
			A)	True
			B)	False
17		The cell-naming technique is particularly useful for workbooks with large numbers of worksheets.
			A)	True
			B)	False
18		The AutoSum button on the Standard toolbar can be used to create totals in both columns and rows.
			A)	True
			B)	False
19		To print all worksheets in a workbook, group the worksheets first.
			A)	True
			B)	False
20		If you open a supporting workbook after closing a dependent workbook and make changes to various cells, the values of the dependent workbook are not updated.
			A)	True
			B)	False