Question 1

To insert content controls,which of the following tabs should be ensured to be displayed?

Accepted Answer

A)  References tab 
B)  Review tab 
C)  Add-ins tab 
D)  Developer tab 
A)  References tab 
B)  Review tab 
C)  Add-ins tab 
D)  Developer tab

Question 2

To add choices to a combo box content control,which of the following should be done?

Accepted Answer

A)  Modify the content control style. 
B)  Apply numbering to the content control. 
C)  Apply a text effect to the content control. 
D)  Modify the content control properties. 
A)  Modify the content control style. 
B)  Apply numbering to the content control. 
C)  Apply a text effect to the content control. 
D)  Modify the content control properties.

Question 3

To uniquely identify a content control in a document,modify the tag property.

Accepted Answer

A) True 
 B)False

Question 4

Katie needs to prevent people from editing a document.She should do which of the following?

Accepted Answer

A)  Enable document editing restrictions. 
B)  Enable document formatting restrictions. 
C)  Modify the document properties. 
D)  Disable macros. 
A)  Enable document editing restrictions. 
B)  Enable document formatting restrictions. 
C)  Modify the document properties. 
D)  Disable macros.

Question 5

Sue needs to add choices to a combo box content control.She should do which of the following?

Accepted Answer

A)  Modify the content control style. 
B)  Apply numbering to the content control. 
C)  Apply a text effect to the content control. 
D)  Modify the content control properties. 
A)  Modify the content control style. 
B)  Apply numbering to the content control. 
C)  Apply a text effect to the content control. 
D)  Modify the content control properties.

Question 6

Two pictures in a document are overlapping.To move the topmost picture behind the other picture,send the picture backward.

Accepted Answer

A) True 
 B)False

Question 7

To restrict editing to comments,which type of editing after applying editing restrictions should be allowed?

Accepted Answer

A)  tracked changes 
B)  comments 
C)  filling in forms 
D)  no changes (read only) 
A)  tracked changes 
B)  comments 
C)  filling in forms 
D)  no changes (read only)

Question 8

To edit the placeholder text of a rich text content control,which of the following should be done?

Accepted Answer

A)  Modify the content control properties. 
B)  Group the content control. 
C)  Enter text in the content control. 
D)  Enter design mode and modify the placeholder text directly. 
A)  Modify the content control properties. 
B)  Group the content control. 
C)  Enter text in the content control. 
D)  Enter design mode and modify the placeholder text directly.

To insert content controls,which of the following tabs should be ensured to be displayed?

To add choices to a combo box content control,which of the following should be done?

To uniquely identify a content control in a document,modify the tag property.

Katie needs to prevent people from editing a document.She should do which of the following?

Sue needs to add choices to a combo box content control.She should do which of the following?

Two pictures in a document are overlapping.To move the topmost picture behind the other picture,send the picture backward.

To restrict editing to comments,which type of editing after applying editing restrictions should be allowed?

To edit the placeholder text of a rich text content control,which of the following should be done?

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

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

Financial Functions, Data Tables, and Amortization Schedules

Working With Multiple Worksheets and Workbooks

Creating, Sorting, and Querying a Table

Creating Templates, Importing Data, and Working With Smartart, Images, and Screenshots

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

Formula Auditing, Data Validation, and Complex Problem Solving

User Interfaces, Visual Basic for Applications Vba, and Collaboration Features in Excel

Filters

Exam 10: Data Analysis With Power Tools and Creating Macros

To insert content controls,which of the following tabs should be ensured to be displayed?

To add choices to a combo box content control,which of the following should be done?

To uniquely identify a content control in a document,modify the tag property.

Katie needs to prevent people from editing a document.She should do which of the following?

Sue needs to add choices to a combo box content control.She should do which of the following?

Two pictures in a document are overlapping.To move the topmost picture behind the other picture,send the picture backward.

To restrict editing to comments,which type of editing after applying editing restrictions should be allowed?

To edit the placeholder text of a rich text content control,which of the following should be done?

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

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

Financial Functions, Data Tables, and Amortization Schedules

Working With Multiple Worksheets and Workbooks

Creating, Sorting, and Querying a Table

Creating Templates, Importing Data, and Working With Smartart, Images, and Screenshots

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

Formula Auditing, Data Validation, and Complex Problem Solving

User Interfaces, Visual Basic for Applications Vba, and Collaboration Features in Excel

Filters