Exam 6: Excel: Managing Multiple Worksheets and Workbooks

In the Publish as section of the Publish as Web Page dialog box you can enable automatic ____________________ of the Web page every time a change is saved to the workbook.

Excel has some templates that are automatically installed on your hard disk.

A 3-D cell ____________________ specifies not only the rows and columns of a cell range but also the range of worksheet names that the cells appear on.

If you break a link how do you undo the action?

A worksheet ____ is a collection of two or more selected worksheets.

The worksheet that is active when you ____ a template workbook is the active worksheet when you create a new workbook based on the template.

A worksheet cluster is a collection of several worksheets.

To move a worksheet or worksheet group to another location in the same workbook select the worksheets and then drag and drop them by the selected sheet ____.

When the destination file is ____________________ 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.

The default template contains the default formatting you start out with in every new workbook including labels aligned to the left side of a cell.

A blank workbook you can open with the text formats and formulas already built into it is called a(n)spreadsheet .

If a sheet range includes more than one sheet you specify the first and last sheet in the range separated by a ____.

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

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

Click the item marked ____ in the accompanying figure to set the hyperlink text.

In the dialog box shown in the accompanying figure the source file type of the files is Excel worksheet .

You cannot move worksheets without making 3-D references inaccurate.

Once you update values in Excel the dialog box in the accompanying figure displays the text ____ for links that are acting correctly and that have been updated in this session.

You can set up the page layout and print area for all the worksheets in a workbook by selecting a worksheet group and then accessing the ____ dialog box.