FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 6: Managing Multiple Worksheets and Workbooks

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 51

Multiple Choice

Review LaterAdd Note

Review Later

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Each worksheet functions independently again

A) 3-D
B) template
C) A
D) source
E) destination
F) link
G) M
H) workspace
I) hyperlink
J) ScreenTip
K) worksheet group
L) ungroup

M) C) and H)
N) B) and D)

Correct Answer

verified

Show Answer

Question 52

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

Show Answer

Question 53

Multiple Choice

Review LaterAdd Note

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

-Click the button marked ____ in the accompanying figure to replace the link to a source file with the current values for the linked cells.

Using multiple worksheets makes it more difficult for you to group your data.

If a sheet range includes more than one sheet,you specify the first and last sheet in the range separated by a ____.

When the destination file is ____________________,and the source files are closed,the complete file path is included as part of the external reference formula that appears in the formula bar.

To use a template that you create,the template file is typically placed in the ____________________ folder.

Provide at least two different examples of when to use a linked workbook.

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Saves information about currently opened workbooks

To manually update the link and see the new data values,click the Update Values button in the Edit Links dialog box.

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

Case-Based Critical Thinking Questions Case 6-3 Your friend Connor asks you to help him learn more about using hyperlinks in an Excel workbook file. -Connor 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?

In the Edit Links dialog box in the accompanying figure,____ indicates that a link has to be updated manually by the user.

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

To create a template,you simply save an Excel workbook in template format using the ____ dialog command.

____________________ appear whenever you place the pointer over a hyperlink.

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. -Telden wants to use the workspace she has created on another computer.What steps does she need to take?

A link is a connection between two ____ allowing information to be transferred from one to the other.