Question 1

To ensure a document can only be viewed by people with an access password,which of the following should be done?

Accepted Answer

A)  Enable track changes. 
B)  Encrypt the document with a password. 
C)  Apply formatting restrictions. 
D)  Apply editing restrictions. 
A)  Enable track changes. 
B)  Encrypt the document with a password. 
C)  Apply formatting restrictions. 
D)  Apply editing restrictions.

Question 2

To remove restrictions from a document,which of the following should be done?

Accepted Answer

A)  Stop protection. 
B)  Disable macros. 
C)  Apply editing restrictions. 
D)  Apply formatting restrictions. 
A)  Stop protection. 
B)  Disable macros. 
C)  Apply editing restrictions. 
D)  Apply formatting restrictions.

Question 3

Aaron needs to create a document that is 17" wide and 11" tall.He should change the paper size.

Accepted Answer

A) True 
 B)False

Question 4

To allow a person viewing a document to insert a picture,which of the following kinds of content control should be inserted?

Accepted Answer

A)  A plain text content control 
B)  A building block content control 
C)  A combo box content control 
D)  A picture content control 
A)  A plain text content control 
B)  A building block content control 
C)  A combo box content control 
D)  A picture content control

Question 5

To ensure a document can only be viewed by people with an access password,use the restrict editing function.

Accepted Answer

A) True 
 B)False

Question 6

Which of the following describes the purpose of Design mode?

Accepted Answer

A)  Design mode is optimized to help you organize headings in a document. 
B)  Design mode is optimized to help you create a webpage. 
C)  Design mode is optimized to help you arrange objects on a page. 
D)  Design mode is optimized to help you create a fillable form. 
A)  Design mode is optimized to help you organize headings in a document. 
B)  Design mode is optimized to help you create a webpage. 
C)  Design mode is optimized to help you arrange objects on a page. 
D)  Design mode is optimized to help you create a fillable form.

Question 7

Caitlin wants her document to have a yellow background.She should do which of the following?

Accepted Answer

A)  Change the page border. 
B)  Change the document colors. 
C)  Change the page color. 
D)  Change the document theme. 
A)  Change the page border. 
B)  Change the document colors. 
C)  Change the page color. 
D)  Change the document theme.

Question 8

To prevent a content control from being deleted,which of the following should be done?

Accepted Answer

A)  Record a macro. 
B)  Add formatting restrictions to the document. 
C)  Modify the content control properties. 
D)  Turn on track changes. 
A)  Record a macro. 
B)  Add formatting restrictions to the document. 
C)  Modify the content control properties. 
D)  Turn on track changes.

Question 9

To change the format of a date picker content control,which of the following should be done?

Accepted Answer

A)  Change the content control properties. 
B)  Apply a paragraph style to the content control. 
C)  Group the content control. 
D)  Modify the content control in Design Mode. 
A)  Change the content control properties. 
B)  Apply a paragraph style to the content control. 
C)  Group the content control. 
D)  Modify the content control in Design Mode.

Question 10

To create a content control that allows people to enter plain,unformatted text,which of the following should be done?

Accepted Answer

A)  Insert a plain text content control. 
B)  Insert a rich text content control. 
C)  Insert a date picker content control. 
D)  Insert a check box content control. 
A)  Insert a plain text content control. 
B)  Insert a rich text content control. 
C)  Insert a date picker content control. 
D)  Insert a check box content control.

Question 11

To allow a person viewing a document to enter a date using a pop-up calendar,which of the following kinds of content control should be inserted?

Accepted Answer

A)  A plain text content control 
B)  A combo box content control 
C)  A date picker content control 
D)  A building block content control 
A)  A plain text content control 
B)  A combo box content control 
C)  A date picker content control 
D)  A building block content control

Question 12

To create a dashed line around a shape,modify the shape outline style.

Accepted Answer

A) True 
 B)False

Question 13

To add repeating pieces of information to a form,which of the following should be inserted?

Accepted Answer

A)  A combo box content control 
B)  A building block content control 
C)  A repeating section content control 
D)  A plain text content control 
A)  A combo box content control 
B)  A building block content control 
C)  A repeating section content control 
D)  A plain text content control

Question 14

To set the style for text typed into a content control,which of the following should be done?

Accepted Answer

A)  Modify the content control properties. 
B)  Group the content control. 
C)  Apply shading to the content control. 
D)  Modify the content control's tag. 
A)  Modify the content control properties. 
B)  Group the content control. 
C)  Apply shading to the content control. 
D)  Modify the content control's tag.

Question 15

To restrict editing to tracked changes,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 16

Adam needs to prevent people viewing a document from deleting a content control.He should do which of the following?

Accepted Answer

A)  Start a mail merge. 
B)  Turn on track changes. 
C)  Modify the content control properties. 
D)  Add formatting restrictions to the document. 
A)  Start a mail merge. 
B)  Turn on track changes. 
C)  Modify the content control properties. 
D)  Add formatting restrictions to the document.

Question 17

To remove the line around a table,modify the table shading.

Accepted Answer

A) True 
 B)False

Question 18

Aaron needs a drop-down list content control to be orange.He should do which of the following?

Accepted Answer

A)  Change the content control alignment. 
B)  Create a macro. 
C)  Change the page color. 
D)  Modify the content control properties. 
A)  Change the content control alignment. 
B)  Create a macro. 
C)  Change the page color. 
D)  Modify the content control properties.

Question 19

To modify the fill of a rich text content control,use the Content Control Properties dialogue box.

Accepted Answer

A) True 
 B)False

Question 20

To add a content control that allows users to select from a variety of AutoText options,which of the following should be done?

Accepted Answer

A)  Insert a plain text content control. 
B)  Insert a combo box content control. 
C)  Insert a date picker content control. 
D)  Insert a building block content control. 
A)  Insert a plain text content control. 
B)  Insert a combo box content control. 
C)  Insert a date picker content control. 
D)  Insert a building block content control.

To ensure a document can only be viewed by people with an access password,which of the following should be done?

To remove restrictions from a document,which of the following should be done?

Aaron needs to create a document that is 17" wide and 11" tall.He should change the paper size.

To allow a person viewing a document to insert a picture,which of the following kinds of content control should be inserted?

To ensure a document can only be viewed by people with an access password,use the restrict editing function.

Which of the following describes the purpose of Design mode?

Caitlin wants her document to have a yellow background.She should do which of the following?

To prevent a content control from being deleted,which of the following should be done?

To change the format of a date picker content control,which of the following should be done?

To create a content control that allows people to enter plain,unformatted text,which of the following should be done?

To allow a person viewing a document to enter a date using a pop-up calendar,which of the following kinds of content control should be inserted?

To create a dashed line around a shape,modify the shape outline style.

To add repeating pieces of information to a form,which of the following should be inserted?

To set the style for text typed into a content control,which of the following should be done?

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

Adam needs to prevent people viewing a document from deleting a content control.He should do which of the following?

To remove the line around a table,modify the table shading.

Aaron needs a drop-down list content control to be orange.He should do which of the following?

To modify the fill of a rich text content control,use the Content Control Properties dialogue box.

To add a content control that allows users to select from a variety of AutoText options,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 ensure a document can only be viewed by people with an access password,which of the following should be done?

To remove restrictions from a document,which of the following should be done?

Aaron needs to create a document that is 17" wide and 11" tall.He should change the paper size.

To allow a person viewing a document to insert a picture,which of the following kinds of content control should be inserted?

To ensure a document can only be viewed by people with an access password,use the restrict editing function.

Which of the following describes the purpose of Design mode?

Caitlin wants her document to have a yellow background.She should do which of the following?

To prevent a content control from being deleted,which of the following should be done?

To change the format of a date picker content control,which of the following should be done?

To create a content control that allows people to enter plain,unformatted text,which of the following should be done?

To allow a person viewing a document to enter a date using a pop-up calendar,which of the following kinds of content control should be inserted?

To create a dashed line around a shape,modify the shape outline style.

To add repeating pieces of information to a form,which of the following should be inserted?

To set the style for text typed into a content control,which of the following should be done?

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

Adam needs to prevent people viewing a document from deleting a content control.He should do which of the following?

To remove the line around a table,modify the table shading.

Aaron needs a drop-down list content control to be orange.He should do which of the following?

To modify the fill of a rich text content control,use the Content Control Properties dialogue box.

To add a content control that allows users to select from a variety of AutoText options,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