MIS Test Chapter 6

When you reference a cell or range in a different worksheet, the ____ separates the sheet reference from the cell reference.

!

When Ryder goes to save the workbooks, what is the required file extension?

.xlsx

All template files have a(n) ____ extension.

.xltx

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

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.

Break

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

Calibri

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

Cascade

Ryder wants to use a layout in which the workbooks overlap each other with all the title bars visible. Ryder opens all of the workbooks, and then he clicks the View tab on the Ribbon and clicks the Arrange All button. What should he do next to obtain the desired layout?

Click the Cascade option button

Jared wants to create a hyperlink to link to new a document. What should he click in the Link to list?

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

Destination

Which of the following is NOT a task-specific template available from the Microsoft Office Online Web site?

Fax Cover Sheet

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?

He can open the workbook and click the Continue button in the Edit Links dialog box.

____ are usually represented by words with colored letters and underlines or images.

Hyperlinks

Finally, Simon asks Brooke what steps (if any) need to be taken to keep a destination file up-to-date if he updates a value in one of the source files. Which of the following statements by Brooke would be correct?

If a destination file is open when a source file is changed, the destination file will be updated automatically.

If Excel successfully accessed the link and updated the values from the source document, the status in the Edit Links dialog box will be ____.

OK

Jared wants to create a hyperlink to a location in his current workbook. He clicks the Hyperlink button in the Links group on the Insert tab. What option should he select from the Link to list?

Place in This Document

To delete the hyperlink but keep the text, right-click the hyperlink cell, and then click ____ Hyperlink.

Remove

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

ScreenTip

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

Sheet1:Sheet4

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.

Source

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

Tab

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 ____.

Tabs

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

Templet

Which of the following statements about hyperlinks in Excel workbooks is correct?

They can be used to jump to a specific cell or range within the active worksheet, another worksheet, or another workbook

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.

Ungroup Sheets

Jared has heard that ScreenTips can be used in conjunction with hyperlinks. Which of the following statements about ScreenTips is correct?

You can specify the contents of a ScreenTip when you create a hyperlink.

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

external

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

group

The ____ caption indicates a worksheet group

group

When you click a(n) ____, the computer switches to the file or portion of the file that it references

hyperlink

Which of the following is NOT an option for arranging your workbooks?

lateral

You can create a(n) ____ reference by deleting the $ from the row reference in the cell reference $B$6.

mixed

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

ranges

The default template places the formula results aligned to the ____ of a cell.

right side

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

single quotation marks

Simon tells Brooke that when he attempts to open a workbook, the Edit Links dialog box appears with the message "This workbook contains one or more links that cannot be updated." Brooke suggests several possible causes of this error message. Which of the following is a possible cause?

the workbook was sent to him without links

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

timesheet