FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 6: Excell: Managing Multiple Worksheets and Workbooks

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 51

Multiple Choice

Review LaterAdd Note

Review Later

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

A) Payroll
B) Personnel Statement
C) Time Sheet
D) Employment Calculator

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

Correct Answer

verified

Show Answer

Question 52

Short Answer

Review LaterAdd Note

Review Later

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.

Correct Answer

verified

Show Answer

Question 53

Essay

Review LaterAdd Note

What is an example of when you would use a template? Name at least three benefits of using a workbook template.

____________________ a worksheet duplicates all the values, formulas, and formats into the new worksheet, leaving the original worksheet intact.

____________________ appear whenever you place the pointer over a hyperlink.

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(n) asterisk separates the worksheet reference from the cell or range reference.

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

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

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

All template files have the .xlts file extension.

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?

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

If the destination file is closed when you make a change in the source file, you choose whether to update the link to display the current values when you open the destination file or continue to display the older values from the destination file.

When you use the point-and-click method to build formulas with external references, Excel enters all of the required punctuation, including quotation marks.

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

All template files have a(n) ____ extension.

Which of the following formulas is correct, given a sheet named Sales Data?

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

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