Exam 6: Excel: Managing Multiple Worksheets and Workbooks

You can insert a ____ directly in a workbook file.

When you open a(n)____________________ Excel opens a blank workbook with all the contents and formatting applied to the file.

If you use the mouse to enter a 3-D reference you must first select the cell range followed by the sheet range.

Which of the following adds the values in cell B21 on the worksheets between Sheet1 and Sheet4?

____________________ appear whenever you place the pointer over a hyperlink.

If you delete a value from one cell values in that cell will be deleted in all sheets in the group.

The ____ template in Excel creates an online time card to track employees' work hours.

You can do all of the following in the Publish as section of the Publish as Web Page dialog box EXCEPT ____.

To use a template that you create the template file is typically placed in the ____________________ folder.

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

In Excel 2007 if you want to publish interactive versions of your workbook or items from the worksheet as a Web page with spreadsheet functionality you need to use a component of Microsoft Office Share-Point Server called MHTML Services.

A workspace saves all of the following information about the currently opened workbooks EXCEPT ____.

When two workbooks are ____ it is important that the data in the destination file accurately reflects the contents of the source file.

In the Edit Links dialog box in the accompanying figure ____ indicates that a link has to be updated manually by the user.

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

Which caption indicates a worksheet group?

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

Click the button marked ____ in the accompanying figure if you want to locate the source file and repair broken links.