Exam 6: Managing Multiple Worksheets and Workbooks

Like cell ____,a worksheet group can contain adjacent or nonadjacent sheets.

A(n)____________________ is a connection between two files allowing information to be transferred from one file to the other.

Formulas created using the point-and-click method contain ____ references.

After Brooke has helped Simon to resolve his original problem,Simon asks her about another linked workbook he has received.The source files for this workbook have not been included,but Simon would like to use the workbook with the most recent values from the source files.What should Brooke tell him? 

Case 6-3 Your friend Jared asks you to help him learn more about using hyperlinks in an Excel workbook file. -Which of the following statements about hyperlinks in Excel workbooks is correct? 

A formula can include a reference to another workbook (called an ____ reference),which creates a set of linked workbooks.

The ____ caption indicates a worksheet group.

____________________ a worksheet duplicates all the values,formulas,and formats into the new worksheet,leaving the original worksheet intact.

A ____ is a workbook that you can open with the text,formats,and formulas already built into it.

After you have saved a template,you can access the template from the New screen in ____________________ view.

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

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

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

In the Links group,click the Hyperlink button and the _______ Hyperlink dialog box opens.

Case 6-3 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? 

Identify the letter of the choice that best matches the phrase or definition. -A collection of two or more selected worksheets

To manually ____________________ a link and see the new data values,click the Update Values button.

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

When you reference cells and ranges in other worksheets,if the worksheet name contains spaces,you must enclose the sheet name in ____.

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