Exam 6: Managing Multiple Worksheets and Workbooks

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Type of cell reference that refers to the same cell or range of cells on multiple worksheets in the same workbook

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

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.

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Contains the information when two files are linked

If you delete a value from one cell,the content is also deleted from the same cell in all the worksheets in the group.

To delete the data values,you can also click the Clear button in the Editing group on the Home tab,and then click Clear Contents.

-To open the dialog box in the accompanying figure,click the ____________________ tab on the Ribbon,and then,in the Links group,click the Hyperlink button.

As part of the Excel security system that attempts to protect against ____,links to other workbooks are not updated without your permission.

SkyDrive and Office Web Apps are static Web pages,and might change over time,._________________________

A(n)____________________ group is a collection of two or more selected worksheets.

In the Edit Links dialog box,____ indicates the file to which the link points.

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

Office Web Apps are a part of Windows ____,which is a collection of services and Web applications that you can use to be more productive.

You can view,but cannot edit,workbooks in the Excel Web App.

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

When a worksheet group is selected,the ____ includes text to indicate this.

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.

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

You can save your files directly from Microsoft Office 2010 onto SkyDrive from Worksheet view.