Exam 6: Managing Multiple Worksheets and Workbooks

When you use the point-and-click method to build formulas with external references,Excel enters all of the required punctuation,except quotation marks._________________________

The default ____ for a hyperlink is the folder location and the name of the file to which you will link.

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 a worksheet group includes all the worksheets in a workbook,you can edit only the active worksheet.

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

A(n)____________________ is a link in a file,such as a workbook,to information within that file or another file.

Which of the following is NOT an option for arranging your workbooks?

Rather than retyping the same formulas across a series of worksheets,you can enter them all at once by creating a worksheet ____.

After you have saved a template,you can access the template from the New tab in ________________ view.

Once you group a collection of worksheets,any changes you make to one worksheet are applied to all sheets in the group.

All template files have the .xlts file extension.

Which of the following formulas is correct,given a sheet named Sales Data?

Case-Based Critical Thinking Questions Case 6-2 Telden has discovered the power of creating a workspace that allows her to access a collection of workbooks at the same time. -Which of the following statements about workspaces is NOT correct?

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.

-The Security Warning shown in the accompanying figure appears in the Security Bar._________________________

If you cannot see the sheet tab of a worksheet you want to include in a group,use the sheet ____ controls to display it.

All template files have a(n)____ extension.

Choosing to ____ update values is useful when you want to see the older data values before updating to the new data.

If you want to create a cell reference to the B6 on the Summary Info worksheet of the Sales.xls workbook,you would use the following external reference: ____.

If you receive a destination workbook but the source files are not included,click the ____ Link button in the Edit Links dialog box to replace the external references with the existing values.