Question 1

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.

Accepted Answer

The answer of The ________ command will compare the changes...

Question 2

It is considered good practice to store all workbooks in a linked relationship together in the same ________.

Accepted Answer

The answer of It is considered good practice to store...

Question 3

Consolidating by category is more ________ than consolidating by position.

Accepted Answer

The answer of Consolidating by category is more ________ than...

Question 4

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.

Accepted Answer

The answer of Although it is possible for multiple users...

Question 5

________ templates are stored in the Program Files\Microsoft Office\Templates\1033 folder.

Accepted Answer

The answer of ________ templates are stored in the Program...

Question 6

You can select multiple files to compare and merge by using the ________ key when selecting file names.

Accepted Answer

The answer of You can select multiple files to compare...

Question 7

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

Accepted Answer

The answer of ________ are generally used to create worksheets...

Question 8

An Excel template is saved with the ________ extension.

Accepted Answer

The answer of An Excel template is saved with the...

Question 9

Microsoft users,through its template site at Office.com,can rate templates on a scale of 1 to 5 ________.

Accepted Answer

The answer of Microsoft users,through its template site at Office.com,can...

Question 10

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

Accepted Answer

The answer of Match the following terms with their description.
I.Consolidate...

Question 11

Microsoft,through its template site at Office.com,fosters a(n)________ of Office users who download templates posted by other users.

Accepted Answer

The answer of Microsoft,through its template site at Office.com,fosters a(n)________...

Question 12

The Consolidate feature cannot create ________ to the worksheet that contains the consolidation.

Accepted Answer

The answer of The Consolidate feature cannot create ________ to...

Question 13

Excel 2013 addresses linked workbooks using ________ addresses.

Accepted Answer

The answer of Excel 2013 addresses linked workbooks using ________...

Question 14

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

Accepted Answer

The answer of An Excel ________ is a workbook that...

Question 15

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

Accepted Answer

The answer of A primary advantage of the ability to...

Question 16

Local templates are accessed from the ________ tab.

Accepted Answer

The answer of Local templates are accessed from the ________...

Question 17

A worksheet can store only ________ consolidation(s).

Accepted Answer

The answer of A worksheet can store only ________ consolidation(s)....

Question 18

When Excel displays ________ in a cell,this generally means that the reference to a value could not be found,such as a matching result in a VLOOKUP function.

Accepted Answer

The answer of When Excel displays ________ in a cell,this...

Question 19

Match between columns
                        Premises: 3-D references
Conditional formatting
Grouping
Data
Shift

Accepted Answer

The Answer of Multiple worksheets selected at the same time is...

Question 20

Match between columns
                        Premises: Name Box arrow
Worksheet
Fill Across Worksheets
3-D named range
Multiple worksheets in a workbook

Accepted Answer

The Answer of References the same cell,or range of cells,across is...

Quiz 7: Multiple Worksheets workbooks and Templates