Exam 6: Excel: Managing Multiple Worksheets and Workbooks

A(n)dialog is a connection between two files allowing information to be transferred from one file to the other.

If you trust the provider of source files you can choose to ____ the content which allows the external reference formulas to function and updates the links in the destination workbook.

The default template has column widths is set to ____ characters.

When two files are linked together the ____________________ file receives the information.

If you need to use data located in one workbook in the other workbook you have to create a(n)____ between the two workbooks.

All template files have a(n)____ extension.

A ____ is a blank workbook that you can open with the text formats and formulas already built into it.

To ungroup worksheets you can click a sheet ____ of a sheet not in the group.

When two files are linked together the workbook that contains the information is the ____________________ file.

Each time you start Excel a blank ____ workbook opens.

If the destination file is closed when you make a change in the ____ file you can choose whether to update the link to display the current values when you open the destination file.

As with inserting formulas and text any formatting changes you make to a single sheet in a(n)group are applied to all sheets.

To remove a worksheet group you can right-click the sheet tab of a sheet in the group and then click ____ on the shortcut menu.

A(n)____ cell reference specifies not only the rows and columns of a cell range but also the names of the worksheets on which the cells appear.

You copy formulas with 3-D references the same way you copy other formulas-using copy and paste or AutoFill.

Formulas created using the point-and-click method contains ____ references.

The workspace file contains the location and name of the file as well as the actual workbooks and worksheets.

In order to reference data located in one workbook in another workbook you have to create a(n)dialog between the two workbooks.

When using 3-D formulas to summarize data across worksheets if you change the value in one worksheet the result of the formulas that reference that cell will automatically show the result of the change.