Exam 7: Multiple Worksheets workbooks and Templates

Change history is information that is maintained about all changes made in past editing sessions to the shared workbooks.

Conditional formatting cannot be directly applied to grouped worksheets.

A 3-D reference has the following structure: ='worksheet name!'cell reference.

Fill Across Worksheets ________ should be used when the target worksheet(s)contain(s)contents the user does not want to overwrite.

Ungrouping worksheets is accomplished by either right-clicking a grouped worksheet tab and selecting Ungroup Sheets from the shortcut menu,or by clicking the [Group] tag on the title bar.

The Fill Across Worksheets feature of Excel is located on the HOME tab in the ________ group.

All of the following statements are TRUE regarding linked workbooks EXCEPT:

A 3-D range can be defined by clicking Define Name in the Defined Names group of the ________ tab.

A worksheet can store only ________ consolidation(s).

If you want to summarize data from multiple places and want to organize the data differently than how it is presented in the separate worksheets,but use the same row and column labels so the consolidated worksheet matches the data,you would use the ________ option.

Multiple worksheets can be selected at the same time and actions such as data entry and formatting can affect all the worksheets in the group at once,greatly increasing efficiency.

Consolidating by category is more ________ than consolidating by position.

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

Consolidate by ________ can be used to create a summary worksheet when the source worksheets all have an identical structure.

Multiple worksheets can be selected at the same time and actions such as data entry and formatting can affect all the worksheets in the group at once,greatly increasing ________.

The entire ________ tab is NOT available when worksheets are grouped.

Local templates are accessed from the ________ tab.

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

Each of the following statements is TRUE regarding filling contents across worksheets EXCEPT:

While VLOOKUP can reference linked table data in another workbook,it cannot do so unless the workbook that contains the table is closed.