Exam 6: Excel: Managing Multiple Worksheets and Workbooks

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

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

If you use a template once when you next open a blank workbook based on the template its original settings will still be present.

The general format of a 3-D cell reference is ____.

To open the dialog box in the accompanying figure click the ____________________ tab on the Ribbon and then in the Links group click the Hyperlink button.

You can use the ____________________ dialog box to break links between workbooks.

When you save a worksheet as a Web page it is converted to ____________________ a language used to write Web pages.

Once a file has been stored in the Templates folder it becomes available when you click ____ in the New Workbook dialog box.

Excel will prompt you to update the source file link when you initially open the destination file.

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

To add total sales from two worksheets-cell B10 of the Domestic worksheet and cell B8 of the International worksheet-you would enter the formula ____.

The default template contains the default formatting you start out with in every new workbook including the ____ number format.

The default template contains the default formatting you start out with in every new workbook including ____ 11-point font.

When the destination file is closed and the source files are closed the complete file path is included as part of the external reference formula that appears in the formula bar.

If the destination file is closed when you make a change in the source file you choose whether to update the link to display the current values when you open the destination file or continue to display the older values from the destination file.

____________________ provide additional information about the target of a link.

Hyperlinks like the ones created with the dialog box in the accompanying figure can be used to quickly jump to a specific cell or range within ____.