Exam 7: Multiple Worksheets workbooks and Templates

A data consolidation that contains links to source data includes the cell references for cells from other worksheets that contributed to a consolidated data result.

A(n)________ references the same cell,or range of cells,across multiple worksheets in a workbook.

A template is a special file type that identifies multiple workbooks and remembers the manner in which the workbooks should be arranged.

Which of the following statements regarding worksheet data consolidation is NOT TRUE?

Each of the following statements is TRUE regarding grouping worksheets EXCEPT:

Any workbook can be used as a template for another workbook by simply opening that workbook and saving it with the template extension.

Which of the following features of Excel is available when worksheets are grouped?

The ________ feature of Excel greatly increases user efficiency by enabling actions such as data entry to be performed on multiple worksheets at one time.

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

A(n)3-D ________ references the same cell,or range of cells,across multiple worksheets in a workbook.

To enter unique data,formulas and information in worksheets,the worksheets cannot be grouped.

Any Ribbon tools not available when worksheets are grouped will be ________.

The ________ error will appear if VLOOKUP attempts to reference linked table data in another workbook that is NOT open.

A worksheet can store ________ consolidation(s).

An Excel template is saved with the ________ extension.

All of the following statements are TRUE about tracking changes EXCEPT:

When data is consolidated and links to the source data are included,the consolidation will not be automatically updated when changes are made to the source data.

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

Templates are readily available through the ________ tab when creating a new workbook.

Excel addresses linked workbooks by using ________ addresses.