Exam 7: Multiple Worksheets workbooks and Templates

To arrange the data in all the worksheets in identical order and location,use the consolidate by position option.

Consolidation by ________ is more flexible than consolidation by position.

If you want to summarize data from multiple places and want to arrange the data in all the worksheets in identical order and location,you would use the ________ option.

Excel 2013 addresses linked workbooks using absolute addresses,where prior versions of Excel used relative addresses.

3-D references allow formulas and functions to utilize data from cells and cell ranges across ________.

The ________ command will compare the changes made in each shared workbook and then provide you with the option to update the workbook with those changes.

Although it is possible for multiple users to collaborate in creating a workbook,it is more common for users to collaborate in keeping ________ in a workbook up-to-date once the workbook has been developed.

Built-in templates are accessed from the Home tab by clicking the New tab.

When using Fill Across Worksheets,the user can fill by one of two options,Contents or Format.

A primary advantage of the ability to reference data in multiple workbooks is that you can access data at its source in its ________ location.

Which of the following CANNOT be performed on grouped worksheets sharing similar structures?

A(n)________ named range cannot be defined in the Name box.

The Excel template extension is .xlt.

An Excel ________ is a workbook that provides a starting point for building other similar workbooks.

________ are generally used to create worksheets or workbooks with consistent structure and format.

Filling formats across ________ should be used when the target worksheet(s)contain(s)content that the user does not want to overwrite.

Match the following terms with their description. I.Consolidate by position II.Consolidate by category III.Workspace IV.Template V.Built-in templates A.Special file type that identifies multiple workbooks and remembers the manner in which you want them arranged B.Workbook that provides a starting point for building other similar workbooks C.Aggregates relative data in the same position in multiple worksheets D.Templates provided with the installation of Microsoft Office E.Aggregates data in cells with matching row and/or column labels

If you want to summarize data from multiple places and want to use formulas with cell references or 3-D references to the other worksheets that you are combining because you do not have a consistent position or category of data to use,you would use the ________ option.

Any ________ tools that are not available when worksheets are grouped will be grayed out.

________ is a command that can be used to copy cell contents,formats,or both contents and formats to worksheets in a group.