Exam 6: Managing Multiple Worksheets and Workbooks

The ____ arrangement option layers the open workbooks on the screen.

____________________ appear whenever you place the pointer over a hyperlink.

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.

Your friend Jared asks you to help him learn more about using hyperlinks in an Excel workbook file. -Jared has heard that ScreenTips can be used in conjunction with hyperlinks.Which of the following statements about ScreenTips is correct?

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

What is an example of when you would use a template? Name at least three benefits of using a workbook template.

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.

-In the Edit Links dialog box in the accompanying figure,____ in the Update column indicates that links are updated automatically.

If you delete a value from one cell in a worksheet group,the content is also deleted from the same cell in all the worksheets in the group.

Your friend Jared asks you to help him learn more about using hyperlinks in an Excel workbook file. -Jared wants to create a hyperlink to link to new a document.What should he click in the Link to list?

When the source and destination workbooks are stored in the same folder,you still need to include the location information in the workbook reference that links the two files.

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

The worksheet range ____ references the worksheets,"Sheet1," "Sheet2," "Sheet3," and "Sheet4."

In order to reference data located in one workbook in another workbook,you have to create a(n) $\underline { \text { dialog } }$ between the two workbooks._________________________

If a worksheet group includes all the worksheets in a workbook,you can edit only the active worksheet.

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

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.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Divides the open workbooks evenly on the screen

If Excel successfully accessed the link and updated the values from the source document,the status in the Edit Links dialog box will be ____.

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.