Question 1

To have shapes in a document behave as a single object,group the shapes.

Accepted Answer

A) True 
 B)False  True

Question 2

Which of the following styles is a character style?

Accepted Answer

A)  A style that defines indentation and font size 
B)  A style that defines indentation and paragraph alignment 
C)  A style that defines font color and font size 
D)  A style that defines font color and paragraph alignment 
A)  A style that defines indentation and font size 
B)  A style that defines indentation and paragraph alignment 
C)  A style that defines font color and font size 
D)  A style that defines font color and paragraph alignment C

Question 3

To copy styles from one document to another,which of the following should be done?

Accepted Answer

A)  Use the Manage Styles command. 
B)  Use the Style Inspector command. 
C)  Use the Styles pane. 
D)  Use the Navigation pane. 
A)  Use the Manage Styles command. 
B)  Use the Style Inspector command. 
C)  Use the Styles pane. 
D)  Use the Navigation pane. A

Question 4

To change the color tone of a picture,apply a picture effect to the picture.

Accepted Answer

A) True 
 B)False

Question 5

Adrian needs to create a style that specifies the font and character spacing of text.She should create which of the following?

Accepted Answer

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

Question 6

Kim wants a picture in a document to appear as if it was drawn using chalk.She should do which of the following?

Accepted Answer

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

Question 7

To replace a picture in a document with another picture,which of the following should be done?

Accepted Answer

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

Question 8

To guarantee that the individual sending a document really is who he or she claims to be,which of the following should be done?

Accepted Answer

A)  Add a watermark. 
B)  Add a digital signature. 
C)  Add a header. 
D)  Check the document for accessibility. 
A)  Add a watermark. 
B)  Add a digital signature. 
C)  Add a header. 
D)  Check the document for accessibility.

Question 9

To create a macro by writing the computer code directly,which of the following should be done?

Accepted Answer

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

Question 10

To make changes to a preexisting macro,which of the following should be done?

Accepted Answer

A)  Edit the macro in the Visual Basic window. 
B)  Record the macro. 
C)  Modify the document properties. 
D)  Enter Design Mode. 
A)  Edit the macro in the Visual Basic window. 
B)  Record the macro. 
C)  Modify the document properties. 
D)  Enter Design Mode.

Question 11

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

Accepted Answer

A)  Click the Picture Layout 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 Color button and select the desired option. 
A)  Click the Picture Layout 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 Color button and select the desired option.

Question 12

To add an electronic,encrypted,stamp of authentication to a Word document,which of the following should be done?

Accepted Answer

A)  Add a watermark. 
B)  Add a digital signature. 
C)  Add a signature line. 
D)  Add a header. 
A)  Add a watermark. 
B)  Add a digital signature. 
C)  Add a signature line. 
D)  Add a header.

Question 13

When checking spelling and grammar in a document written using a language other than English,make sure to do which of the following?

Accepted Answer

A)  Check the document for accessibility. 
B)  Use the thesaurus. 
C)  Enable tracked changes. 
D)  Set the proofing language. 
A)  Check the document for accessibility. 
B)  Use the thesaurus. 
C)  Enable tracked changes. 
D)  Set the proofing language.

Question 14

A character style includes text formatting information but not paragraph formatting information.

Accepted Answer

A) True 
 B)False

Question 15

To temporarily suspend recording steps into a macro,which of the following should be done?

Accepted Answer

A)  Pause recording. 
B)  Enter Design Mode. 
C)  Open the XML Mapping pane. 
D)  Open the Visual Basic window. 
A)  Pause recording. 
B)  Enter Design Mode. 
C)  Open the XML Mapping pane. 
D)  Open the Visual Basic window.

Question 16

To make a picture in a document appear as if it were sketched using pencils,apply a picture style to the picture.

Accepted Answer

A) True 
 B)False

Question 17

To have multiple shapes in a document behave like a single object,which of the following should be done?

Accepted Answer

A)  Apply Shape Effects to the shapes. 
B)  Group the shapes. 
C)  Align the shapes. 
D)  Edit the shapes. 
A)  Apply Shape Effects to the shapes. 
B)  Group the shapes. 
C)  Align the shapes. 
D)  Edit the shapes.

Question 18

Nina needs a picture in a document to appear as if it were tilted in perspective.She should do which of the following?

Accepted Answer

A)  Apply a 3-D artistic effect. 
B)  Apply a 3-D picture effect. 
C)  Apply a 3-D picture layout. 
D)  Apply a 3-D correction. 
A)  Apply a 3-D artistic effect. 
B)  Apply a 3-D picture effect. 
C)  Apply a 3-D picture layout. 
D)  Apply a 3-D correction.

Question 19

To prevent people from making any changes to a document,which of the following should be done?

Accepted Answer

A)  Apply formatting restrictions. 
B)  Apply editing restrictions,and allow no changes. 
C)  Enable track changes. 
D)  Inspect the document. 
A)  Apply formatting restrictions. 
B)  Apply editing restrictions,and allow no changes. 
C)  Enable track changes. 
D)  Inspect the document.

Question 20

To check a document written in Spanish for spelling and grammar errors,first set the proofing language.

Accepted Answer

A) True 
 B)False

To have shapes in a document behave as a single object,group the shapes.

Which of the following styles is a character style?

To copy styles from one document to another,which of the following should be done?

To change the color tone of a picture,apply a picture effect to the picture.

Adrian needs to create a style that specifies the font and character spacing of text.She should create which of the following?

Kim wants a picture in a document to appear as if it was drawn using chalk.She should do which of the following?

To replace a picture in a document with another picture,which of the following should be done?

To guarantee that the individual sending a document really is who he or she claims to be,which of the following should be done?

To create a macro by writing the computer code directly,which of the following should be done?

To make changes to a preexisting macro,which of the following should be done?

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

To add an electronic,encrypted,stamp of authentication to a Word document,which of the following should be done?

When checking spelling and grammar in a document written using a language other than English,make sure to do which of the following?

A character style includes text formatting information but not paragraph formatting information.

To temporarily suspend recording steps into a macro,which of the following should be done?

To make a picture in a document appear as if it were sketched using pencils,apply a picture style to the picture.

To have multiple shapes in a document behave like a single object,which of the following should be done?

Nina needs a picture in a document to appear as if it were tilted in perspective.She should do which of the following?

To prevent people from making any changes to a document,which of the following should be done?

To check a document written in Spanish for spelling and grammar errors,first set the proofing language.

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 have shapes in a document behave as a single object,group the shapes.

Which of the following styles is a character style?

To copy styles from one document to another,which of the following should be done?

To change the color tone of a picture,apply a picture effect to the picture.

Adrian needs to create a style that specifies the font and character spacing of text.She should create which of the following?

Kim wants a picture in a document to appear as if it was drawn using chalk.She should do which of the following?

To replace a picture in a document with another picture,which of the following should be done?

To guarantee that the individual sending a document really is who he or she claims to be,which of the following should be done?

To create a macro by writing the computer code directly,which of the following should be done?

To make changes to a preexisting macro,which of the following should be done?

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

To add an electronic,encrypted,stamp of authentication to a Word document,which of the following should be done?

When checking spelling and grammar in a document written using a language other than English,make sure to do which of the following?

A character style includes text formatting information but not paragraph formatting information.

To temporarily suspend recording steps into a macro,which of the following should be done?

To make a picture in a document appear as if it were sketched using pencils,apply a picture style to the picture.

To have multiple shapes in a document behave like a single object,which of the following should be done?

Nina needs a picture in a document to appear as if it were tilted in perspective.She should do which of the following?

To prevent people from making any changes to a document,which of the following should be done?

To check a document written in Spanish for spelling and grammar errors,first set the proofing language.

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