Filters
Question type

Study Flashcards

Case-Based Critical Thinking Questions Case 6-1 Simon is having trouble using linked workbooks, so he consults his colleague Brooke for help. 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?


A) one of the workbook's source files was edited
B) one of the workbook's source files was copied to a different folder
C) one of the workbook's source files was replaced with an updated file of the same name
D) the workbook was sent to him without links

E) None of the above
F) C) and D)

Correct Answer

verifed

verified

Identify the letter of the choice that best matches the phrase or definition.

Premises
A connection between two files allowing information to be transferred from one file to the other
Responses
3-D
hyperlink
source
destination
worksheet group
link

Correct Answer

3-D
hyperlink
source
destination
worksheet group
link

After you have saved a template, you can access the template from the New screen in ____________________ view.

Correct Answer

verifed

verified

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) target
B) origin
C) source
D) key

E) B) and C)
F) B) and D)

Correct Answer

verifed

verified

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) True
B) False

Correct Answer

verifed

verified

False

All template files have a(n) ____ extension.


A) .xlsx
B) .xltx
C) .xldx
D) .xtpl

E) A) and B)
F) A) and C)

Correct Answer

verifed

verified

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


A) Cascade
B) Horizontal
C) Tiled
D) Lateral

E) B) and C)
F) A) and C)

Correct Answer

verifed

verified

A

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


A) Existing File
B) Place in This Document
C) Create New Document
D) E-mail Address

E) A) and B)
F) B) and C)

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

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


A) Indices
B) Hyperlinks
C) Templates
D) Icons

E) B) and D)
F) None of the above

Correct Answer

verifed

verified

Identify the letter of the choice that best matches the phrase or definition.

Premises
Receives the information when two files are linked
Responses
hyperlink
3-D
worksheet group
link
source
destination

Correct Answer

hyperlink
3-D
worksheet group
link
source
destination

All template files have the .xlts file extension.

A) True
B) False

Correct Answer

verifed

verified

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.

E) A) and D)
F) B) and C)

Correct Answer

verifed

verified

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) Done
B) Completed
C) OK
D) Good

E) None of the above
F) A) and D)

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

When two files are linked together, the ____________________ file receives the information.

Correct Answer

verifed

verified

In order to reference data located in one workbook in another workbook, you have to create a(n)dialog between the two workbooks. _________________________

A) True
B) False

Correct Answer

verifed

verified

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


A) (?)
B) !
C) "
D) ;

E) None of the above
F) A) and B)

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

True

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.

A) True
B) False

Correct Answer

verifed

verified

Showing 1 - 20 of 75

Related Exams

Show Answer