Question 1

Calibrated changes are the electronic version of sticky notes.

Accepted Answer

A) True 
 B)False

Question 2

When a workbook is shared with other users, changes made and saved by the other users are visible only when you attempt to save changes.

Accepted Answer

A) True 
 B)False

Question 3

Which of the following is the path to opening the Page Setup dialog box?

Accepted Answer

A)  (FORMULAS tab | Page Setup Dialog Box Launcher) 
B)  (PAGE LAYOUT tab | Page Setup Dialog Box Launcher) 
C)  (INSERT tab | Page Setup Dialog Box Launcher) 
D)  (DEV 
A)  (FORMULAS tab | Page Setup Dialog Box Launcher) 
B)  (PAGE LAYOUT tab | Page Setup Dialog Box Launcher) 
C)  (INSERT tab | Page Setup Dialog Box Launcher) 
D)  (DEV

Question 4

Which of the following is the path to the Gridlines check box?

Accepted Answer

Question 5

You can ____ comments.

Accepted Answer

A)  format 
B)  resize 
C)  copy 
D)  move 
E)  None of the above 
A)  format 
B)  resize 
C)  copy 
D)  move 
E)  None of the above

Question 6

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Enables each user to view the worksheet in a familiar manner.

Accepted Answer

A) track changes 
B) merging 
C) custom view 
D) comments 
E) sharing a workbook
F)collaborating
G)exclusive workbook
H)tags
I)schema
J)XML map 
A) track changes 
B) merging 
C) custom view 
D) comments 
E) sharing a workbook
F)collaborating
G)exclusive workbook
H)tags
I)schema
J)XML map

Question 7

It is highly unusual to find different versions of software being used within the same company.

Accepted Answer

A) True 
 B)False

Question 8

____________________ allows users to bring together copies of workbooks that others have worked on independently.

Accepted Answer

The answer of ____________________ allows users to bring together copies...

Question 9

To share a workbook you must post it to a network server.

Accepted Answer

A) True 
 B)False

Question 10

-A(n) ____ like the one shown in the accompanying figure can be used to provide a reminder to the user.

Accepted Answer

A)  clone 
B)  watermark 
C)  formatted shape 
D)  indexed transparency 
A)  clone 
B)  watermark 
C)  formatted shape 
D)  indexed transparency

Question 11

A(n) ____________________ describes what information an XML file should contain, the order in which the elements should appear, the values allowed for each element, and a variety of other information.

Accepted Answer

The answer of A(n) ____________________ describes what information an XML...

Question 12

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 new branch office in Albuquerque, New Mexico is scheduled to be completely staffed and the office facilities ready for occupation in about three weeks. In the meantime, the branch office manager is working out of her hotel room with her laptop and limited Internet access, primarily for email. Because you need her budget data by next Monday, you decide that the most efficient and effective way to collaborate on the budget data with her is to ____.

Accepted Answer

A)  attach a copy of the budget workbook to an email message and request that she return her edited workbook as an email attachment by next Monday 
B)  place a copy of the budget workbook on a DVD and mail the DVD to her; ask her to mail the edited workbook DVD back to you by next Monday 
C)  share the workbook over the company network and ask her to access the workbook by logging on to the network 
D)  ask her to send the budget numbers to you in an email message; you will make the edits for her 
A)  attach a copy of the budget workbook to an email message and request that she return her edited workbook as an email attachment by next Monday 
B)  place a copy of the budget workbook on a DVD and mail the DVD to her; ask her to mail the edited workbook DVD back to you by next Monday 
C)  share the workbook over the company network and ask her to access the workbook by logging on to the network 
D)  ask her to send the budget numbers to you in an email message; you will make the edits for her

Calibrated changes are the electronic version of sticky notes.

When a workbook is shared with other users, changes made and saved by the other users are visible only when you attempt to save changes.

Which of the following is the path to opening the Page Setup dialog box?

Which of the following is the path to the Gridlines check box?

You can ____ comments.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Enables each user to view the worksheet in a familiar manner.

It is highly unusual to find different versions of software being used within the same company.

____________________ allows users to bring together copies of workbooks that others have worked on independently.

To share a workbook you must post it to a network server.

-A(n) ____ like the one shown in the accompanying figure can be used to provide a reminder to the user.

A(n) ____________________ describes what information an XML file should contain, the order in which the elements should appear, the values allowed for each element, and a variety of other information.

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

Exam 12: Collaboration Features for Workbooks

Calibrated changes are the electronic version of sticky notes.

When a workbook is shared with other users, changes made and saved by the other users are visible only when you attempt to save changes.

Which of the following is the path to opening the Page Setup dialog box?

Which of the following is the path to the Gridlines check box?

You can ____ comments.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Enables each user to view the worksheet in a familiar manner.

It is highly unusual to find different versions of software being used within the same company.

____________________ allows users to bring together copies of workbooks that others have worked on independently.

To share a workbook you must post it to a network server.

-A(n) ____ like the one shown in the accompanying figure can be used to provide a reminder to the user.

A(n) ____________________ describes what information an XML file should contain, the order in which the elements should appear, the values allowed for each element, and a variety of other information.

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