Exam 6: Managing Multiple Worksheets and Workbooks

To select nonadjacent worksheets,you use the ____ key.

Case-Based Critical Thinking Questions Case 6-2 Telden has discovered the power of creating a workspace that allows her to access a collection of workbooks at the same time. -When Telden goes to save the workspace,what is the required file extension?

-In the figure above,cell A8 contains a hyperlink._________________________

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.

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

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

You can insert a ____ directly in a workbook file.

In Backstage view,the New from existing button opens a copy of the selected file,not the selected file.

When creating and saving a custom template,you may find it helpful to replace variable data values with ____________________,which will help you recognize the cells in which to enter new data.

Each time you start Excel,a blank ____ workbook opens.

A(n)____ cell reference specifies not only the rows and columns of a cell range,but also the names of the worksheets on which the cells appear.

To select adjacent worksheets,you use the ____ key.

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Indicates a link that is updated automatically

What are the steps to inserting a hyperlink and linking to: a file or Web page,a location in the current workbook,a new document,and an e-mail address.

Case-Based Critical Thinking Questions Case 6-2 Telden has discovered the power of creating a workspace that allows her to access a collection of workbooks at the same time. -In creating the workspace,Telden wants to use a layout in which the workbooks overlap each other with all the title bars visible.Telden opens all of the workbooks,and then she clicks the View tab on the Ribbon and clicks the Arrange All button.What should she do next to obtain the desired layout?

When you start Excel and use the blank workbook that displays,you are actually using a workbook based on a template known as the ___ template.

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

The default template contains the default formatting you start out with in every new workbook,including labels aligned to the right side of a cell._________________________

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