Exam 6: Excel: Managing Multiple Worksheets and Workbooks

A link is a connection between two ____ allowing information to be transferred from one to the other.

When a worksheet group is selected the ____ includes text to indicate this.

The name of the sheet range is a required component in 3-D cell references.

Click the button marked ____ in the accompanying figure to replace the link to a source file with the current values for the linked cells.

The Edit Links list in the accompanying figure indicates the type of each ____ file.

Which of the following is NOT a task-specific template available from the Microsoft Office Online Web site?

To change the default behavior of disabling automatic links click the Office Button click the Excel Options button click ____________________ and in the General section uncheck the Ask to update automatic links check box and then click the OK button.

A workbook based on a specific template always displays the name of the template followed by a sequential number.

The item indicated in the accompanying figure is the Security Bar .

A(n)____________________ is an Excel file that saves information about all of the currently opened workbooks.

The Single File Web Page format saves all the elements of the Web page in a single file in the ____ format.

The general form of an external reference is ____ where Path is the path of the workbook file on the computer or network Workbook Name is the filename of the workbook and Sheet Range and Cell Range are worksheets and cells in the workbook respectively.

If Excel has not attempted to update the links in a given session the Edit Links dialog box will show the status of the links as not checked .

The ____ dialog box lists all of the links in the current workbook.

When you apply the Comma Style number format to a cell range the values in the range will appear with a(n)decimal point and no comma .

If both the ____________________ and source files are open Excel will update the link between them automatically whenever a value in the source file is changed.

When you start Excel and see the blank workbook called Book1 you are actually using the ____________________ template.

To update all of the M links in a workbook select the links in the Edit Links dialog box and click the button marked ____ in the accompanying figure.