Exam 12: Collaboration Features for Workbooks

Case 11-2 At last! Copies of the next year's branch office budget workbook are ready for distribution to all the branch office managers. Each manager will edit next year's budget projections for their office's operations, as necessary, and then return his or her edited copy of the workbook to you. The branch offices are located around the country; two branch office managers have resource limitations that determine which distribution method you must use. -The branch manager in Bangor, Maine calls to tell you that he is snowed in at home! He spent the weekend developing his office's budget numbers, but for the next few days he will not be able to get to the office to access the network or his office email account. He does have a home computer with Excel 2013 installed and Internet access. Unfortunately, the email provider he uses at home restricts the size of email attachments, and the budget workbook is enormous. You decide that the best approach is to ____.

(Multiple Choice)

4.8/5

(42)

Question 21

When Excel merges workbooks, both data and ____________________ are merged.

(Short Answer)

4.9/5

(33)

Question 22

You can press ____ to add a new comment to a worksheet.

(Multiple Choice)

4.8/5

(41)

Question 23

Which of the following is the path to the 'View Side by Side' button?

(Multiple Choice)

4.9/5

(31)

Question 24

Comments added by each user are identified by a name in the comment, set by the user.

(True/False)

4.9/5

(42)

Question 25

You cannot review changes when you click the Accept All button in the Accept or Reject Changes dialog box.

(True/False)

4.9/5

(38)

Question 26

Which of the following is the path to the Track Changes button?

(Multiple Choice)

4.9/5

(33)

Question 27

You can quickly read a hidden comment by pointing to a cell's comment indicator.

(True/False)

4.8/5

(30)

Question 28

You can import an XML file into a workbook by clicking the Import button ____.

(Multiple Choice)

4.8/5

(41)

Question 29

If Excel cannot merge workbooks, information from one workbook still can be incorporated into another workbook by ____________________ the information from one workbook to another.

(Short Answer)

4.9/5

(33)

Question 30

By default, Excel keeps a change history of ____ days for a shared workbook.

(Multiple Choice)

4.9/5

(47)

Question 31

Tracking and formatting work together.

(True/False)

4.7/5

(43)

Question 32

Which of the following is the path to the Delete Comment button?

(Multiple Choice)

4.9/5

(35)

Question 33

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Allows users to bring together copies of workbooks that others have worked on independently.

(Multiple Choice)

4.9/5

(41)

Question 34

You can click the ____ button to turn on/off the view of all comments.

(Multiple Choice)

4.8/5

(38)

Question 35

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A special type of XML file used to describe the layout of data in other XML files.

(Multiple Choice)

4.9/5

(43)

Question 36

Sharing workbooks allows users to view and scroll worksheets side by side.

(True/False)

4.9/5

(43)

Question 37

Excel has the capability to mark who changed what data, in which cell, and when.

(True/False)

4.9/5

(35)

Question 38

The 'Accept/Reject Changes' command is located on the ____ menu.

(Multiple Choice)

4.8/5

(34)

Question 39

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Used in XML files to describe data items.

(Multiple Choice)

4.9/5

(34)

Question 40

Showing 21 - 40 of 112

When Excel merges workbooks, both data and ____________________ are merged.

You can press ____ to add a new comment to a worksheet.

Which of the following is the path to the 'View Side by Side' button?

Comments added by each user are identified by a name in the comment, set by the user.

You cannot review changes when you click the Accept All button in the Accept or Reject Changes dialog box.

Which of the following is the path to the Track Changes button?

You can quickly read a hidden comment by pointing to a cell's comment indicator.

You can import an XML file into a workbook by clicking the Import button ____.

If Excel cannot merge workbooks, information from one workbook still can be incorporated into another workbook by ____________________ the information from one workbook to another.

By default, Excel keeps a change history of ____ days for a shared workbook.

Tracking and formatting work together.

Which of the following is the path to the Delete Comment button?

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Allows users to bring together copies of workbooks that others have worked on independently.

You can click the ____ button to turn on/off the view of all comments.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A special type of XML file used to describe the layout of data in other XML files.

Sharing workbooks allows users to view and scroll worksheets side by side.

Excel has the capability to mark who changed what data, in which cell, and when.

The 'Accept/Reject Changes' command is located on the ____ menu.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Used in XML files to describe data items.

Essential Concepts and Skills

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

Working With Large Worksheets, Charting, and What-If Analysis

Working With Multiple Worksheets and Workbooks

Financial Functions, Data Tables, and Amortization Schedules

Creating, Sorting, and Querying a Table

Creating Templates, Manipulating Data, and Adding Additional Enhancements to a Worksheet

Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers

Formula Auditing, Data Validation, and Complex Problem Solving

Using Macros and Visual Basic for Applications Vba With Excel

Filters