Question 1

To hide text from a document,apply a text effect.

Accepted Answer

A) True 
 B)False

Question 2

To make a picture in a document appear as if it was painted using a brush,which of the following should be done?

Accepted Answer

A)  Apply a correction to the picture. 
B)  Modify the picture color. 
C)  Apply a picture style. 
D)  Apply an artistic effect. 
A)  Apply a correction to the picture. 
B)  Modify the picture color. 
C)  Apply a picture style. 
D)  Apply an artistic effect.

Question 3

Word enables you to customize the status bar to display a variety of information.

Accepted Answer

A) True 
 B)False

Question 4

To allow people to sign a document,which of the following should be done?

Accepted Answer

A)  Add a document header. 
B)  Add a digital signature to the document. 
C)  Add a hyperlink to the document. 
D)  Add a signature line to the document. 
A)  Add a document header. 
B)  Add a digital signature to the document. 
C)  Add a hyperlink to the document. 
D)  Add a signature line to the document.

Question 5

To change the color saturation of a picture,which of the following should be done?

Accepted Answer

A)  Click the Color button and select the desired option. 
B)  Click the Corrections button and select the desired option. 
C)  Click the Artistic Effects button and select the desired option. 
D)  Click the Picture Layout button and select the desired option. 
A)  Click the Color button and select the desired option. 
B)  Click the Corrections button and select the desired option. 
C)  Click the Artistic Effects button and select the desired option. 
D)  Click the Picture Layout button and select the desired option.

Question 6

To prompt the user for input after creating a document from a template,which of the following should be done?

Accepted Answer

A)  Insert a text box. 
B)  Insert a plain text content control. 
C)  Insert a comment. 
D)  Insert a fill-in field in the document. 
A)  Insert a text box. 
B)  Insert a plain text content control. 
C)  Insert a comment. 
D)  Insert a fill-in field in the document.

Question 7

To prompt the user for input after creating a document from a template,make sure the template contains a fill-in field.

Accepted Answer

A) True 
 B)False

Question 8

To make a picture appear grayscale,which of the following should be done?

Accepted Answer

A)  Change the color saturation to 0%. 
B)  Change the color saturation to 50%. 
C)  Change the color saturation to 100%. 
D)  Change the color saturation to 400%. 
A)  Change the color saturation to 0%. 
B)  Change the color saturation to 50%. 
C)  Change the color saturation to 100%. 
D)  Change the color saturation to 400%.

Question 9

Samantha needs to create a style that specifies the font color and size of text.She should create which of the following?

Accepted Answer

A)  A character style. 
B)  A paragraph style. 
C)  A document theme. 
D)  A document watermark. 
A)  A character style. 
B)  A paragraph style. 
C)  A document theme. 
D)  A document watermark.

Question 10

To transfer all data in a table to text separated by tabs,which of the following should be done?

Accepted Answer

A)  Change the alignment of the table. 
B)  Apply a table style to the table. 
C)  Convert the table to text. 
D)  Apply shading to the table. 
A)  Change the alignment of the table. 
B)  Apply a table style to the table. 
C)  Convert the table to text. 
D)  Apply shading to the table.

Question 11

Darren needs a picture in his document to appear as if it was painted using a brush.He should do which of the following?

Accepted Answer

A)  Modify the picture color. 
B)  Apply a correction to the picture. 
C)  Apply an artistic effect. 
D)  Apply a picture style. 
A)  Modify the picture color. 
B)  Apply a correction to the picture. 
C)  Apply an artistic effect. 
D)  Apply a picture style.

Question 12

To apply a macro to a document,which of the following should be done?

Accepted Answer

A)  Add the macro to the Quick Access Toolbar. 
B)  View the macro in the Visual Basic window. 
C)  Run the macro. 
D)  Insert a rich text content control. 
A)  Add the macro to the Quick Access Toolbar. 
B)  View the macro in the Visual Basic window. 
C)  Run the macro. 
D)  Insert a rich text content control.

Question 13

To change the color saturation of a picture,use Word's Color function.

Accepted Answer

A) True 
 B)False

Question 14

Amanda found code that she wants to use for a macro in one of her textbooks.She should do which of the following?

Accepted Answer

A)  Modify the document header. 
B)  Modify the document properties. 
C)  Record a macro. 
D)  Enter the code into a macro using the Visual Basic window. 
A)  Modify the document header. 
B)  Modify the document properties. 
C)  Record a macro. 
D)  Enter the code into a macro using the Visual Basic window.

Question 15

Aaron needs to create a style that specifies the indentation of text.He should create a character style.

Accepted Answer

A) True 
 B)False

Question 16

Karen needs to replace a picture in a document with an updated version of the picture? She should do which of the following?

Accepted Answer

A)  Remove the picture background. 
B)  Reset the picture. 
C)  Change the picture. 
D)  Compress the picture. 
A)  Remove the picture background. 
B)  Reset the picture. 
C)  Change the picture. 
D)  Compress the picture.

To hide text from a document,apply a text effect.

To make a picture in a document appear as if it was painted using a brush,which of the following should be done?

Word enables you to customize the status bar to display a variety of information.

To allow people to sign a document,which of the following should be done?

To change the color saturation of a picture,which of the following should be done?

To prompt the user for input after creating a document from a template,which of the following should be done?

To prompt the user for input after creating a document from a template,make sure the template contains a fill-in field.

To make a picture appear grayscale,which of the following should be done?

Samantha needs to create a style that specifies the font color and size of text.She should create which of the following?

To transfer all data in a table to text separated by tabs,which of the following should be done?

Darren needs a picture in his document to appear as if it was painted using a brush.He should do which of the following?

To apply a macro to a document,which of the following should be done?

To change the color saturation of a picture,use Word's Color function.

Amanda found code that she wants to use for a macro in one of her textbooks.She should do which of the following?

Aaron needs to create a style that specifies the indentation of text.He should create a character style.

Karen needs to replace a picture in a document with an updated version of the picture? She should do which of the following?

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

Data Analysis With Power Tools and Creating Macros

Filters

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

To hide text from a document,apply a text effect.

To make a picture in a document appear as if it was painted using a brush,which of the following should be done?

Word enables you to customize the status bar to display a variety of information.

To allow people to sign a document,which of the following should be done?

To change the color saturation of a picture,which of the following should be done?

To prompt the user for input after creating a document from a template,which of the following should be done?

To prompt the user for input after creating a document from a template,make sure the template contains a fill-in field.

To make a picture appear grayscale,which of the following should be done?

Samantha needs to create a style that specifies the font color and size of text.She should create which of the following?

To transfer all data in a table to text separated by tabs,which of the following should be done?

Darren needs a picture in his document to appear as if it was painted using a brush.He should do which of the following?

To apply a macro to a document,which of the following should be done?

To change the color saturation of a picture,use Word's Color function.

Amanda found code that she wants to use for a macro in one of her textbooks.She should do which of the following?

Aaron needs to create a style that specifies the indentation of text.He should create a character style.

Karen needs to replace a picture in a document with an updated version of the picture? She should do which of the following?

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

Data Analysis With Power Tools and Creating Macros

Filters