Chapter 6 Study Guide

All template files have a(n) ____ extension. A.) .xltx B.) .xldx C.) .xlsx D.) .xtpl

A.) .xltx

The worksheet range ____ references the worksheets, "Sheet1," "Sheet2," "Sheet3," and "Sheet4." A.) Sheet1:Sheet4 B.) Sheet1/Sheet4 C.) Sheet1_Sheet4 D.) Sheet1-Sheet4

A.) Sheet1:Sheet4

Jared wants to create a hyperlink to link to new a document. What should he click in the Link to list? A.) Existing File or Web Page B.) Create New Document C.) E-Mail Address D.) Place in This Document

B.) Create New Document

When you save a workbook that contains external reference formulas Excel stores the most recent results of those formulas in the ____ file. A.) Source B.) Destination C.) Both A and B D.) Neither A nor B

B.) Destination

A formula can include a reference to another workbook (called an ____ reference), which creates a set of linked workbooks. A.) Export B.) External C.) Import D.) Internal

B.) External

Which of the following is NOT a task-specific template available from the Microsoft Office Online Web site? A.) Family Budget B.) Fax Cover Sheet C.) Team Roster D.) Inventory List

B.) Fax Cover Sheet

When you click a(n) ____, the computer switches to the file or portion of the file that it references. A.) Icon B.) Hyperlink C.) Template D.) Index

B.) Hyperlink

____ are usually represented by words with colored letters and underlines or images. A.) Icons B.) Hyperlinks C.) Indices D.) Templates

B.) Hyperlinks

Which of the following is NOT an option for arranging your workbooks? A.) Horizontal B.) Lateral C.) Cascade D.) Tiled

B.) Lateral

The default template places the formula results aligned to the ____ of a cell. A.) Bottom B.) Right side C.) Top D.) Left side

B.) Right side

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. A.) Origin B.) Source C.) Key D.) Target

B.) Source

A ____ is a workbook that you can open with the text, formats, and formulas already built into it. A.) Summary sheet B.) Template C.) Range master D.) Boiler

B.) Template

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 ____. A.) Indices B.) Tabs C.) Icons D.) Keys

B.) tabs

When you reference a cell or range in a different worksheet, the ____ separates the sheet reference from the cell reference. A.) ; B.) " C.) ! D.) ?

C.) !

Formulas created using the point-and-click method contain ____ references. A.) Relative B.) Relational C.) Absolute D.) Mixed

C.) Absolute

If you receive a destination workbook but the source files are not included, click the ____ Link button in the Edit Links dialog box to replace the external references with the existing values. A.) Fix B.) Update C.) Break D.) Check

C.) Break

A worksheet ____ is a collection of two or more selected worksheets. A.) Index B.) Cluster C.) Group D.) Roster

C.) Group

To delete the hyperlink but keep the text, right-click the hyperlink cell, and then click ____ Hyperlink. A.) Delete B.) Erase C.) Remove D.) Archive

C.) Remove

When you reference cells and ranges in other worksheets, if the worksheet name contains spaces, you must enclose the sheet name in ____. A.) Parentheses B.) Brackets C.) Single quotation marks D.) Braces

C.) Single quotation marks

To ungroup worksheets, you can click a sheet ____ of a sheet not in the group. A.) Pane B.) Panel C.) Tab D.) Index

C.) Tab

The ____ template in Excel creates an online time card to track employees' work hours. A.) Employment Calculator B.) Payroll C.) Time Sheet D.) Personnel Statement

C.) Time Sheet

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. A.) Remove Group B.) No Group C.) Ungroup Sheets D.) Exit Group

C.) Ungroup Sheets

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. A.) Remove Group B.) No Group C.) Ungroup Sheets D.) Exit Group

C.) Ungroup Sheets

The default template contains the default formatting you start out with in every new workbook, including ____ 11-point font. A.) Helvetica B.) Geneva C.) Times New Roman D.) Calibri

D.) Calibri

The ____ arrangement option layers the open workbooks on the screen. A.) Lateral B.) Tiled C.) Horizontal D.) Cascade

D.) Cascade

You can create a(n) ____ reference by deleting the $ from the row reference in the cell reference $B$6. A.) Relative B.) Absolute C.) Indexed D.) Mixed

D.) Mixed

If Excel successfully accessed the link and updated the values from the source document, the status in the Edit Links dialog box will be ____. A.) Completed B.) Done C.) Good D.) OK

D.) OK

Like cell ____, a worksheet group can contain adjacent or nonadjacent sheets. A.) Groups B.) Tabs C.) Controls D.) Ranges

D.) Ranges

The ____ caption indicates a worksheet group. A.) [Selected Sheets] B.) [Workgroup] C.) [Worksheets] D.) [Group]

D.) [Group]

True or False: A workbook based on a specific template always displays the name of the template followed by the date.

False

True or False: To delete a hyperlink, right-click the hyperlink cell and then click clear value.

False

True or False: 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.

False

True or False: A(n) template is a workbook with labels, formats and formulas already built into it with data removed.

True

True or False: Excel, by default, looks for template files in the Templates folder, which is where custom template files are often stored.

True

True or False: Hyperlinks are usually represented by words with colored letters and underlines or images.

True

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

True

True or False: 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.

True

True or False: Once you group a collection of worksheets, any changes you make to one worksheet are applied to all sheets in the group.

True

True or False: When you create a new workbook from a template, an unnamed copy of the template opens.

True

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

True