Question 1

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

Accepted Answer

A)  Align the pictures to the bottom. 
B)  Send the pictures to the front. 
C)  Change the text wrapping of the pictures. 
D)  Group the pictures.

Question 2

Amanda needs a picture to have a warmer color tone.She should do which of the following?

Accepted Answer

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

Question 3

Amy created a contract that she needs people to sign.She should do which of the following?

Accepted Answer

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

Question 4

Damien needs a line of text to be removed from a document on an as needed basis.He should do which of the following when he wants to remove the text?

Accepted Answer

A)  Format the text as hidden. 
B)  Format the text as small caps. 
C)  Format the text as superscript. 
D)  Format the text as subscript.

Question 5

Which of the following describes the results of hiding text in Word?

Accepted Answer

A)  The text is moved to the clipboard. 
B)  The text is deleted from the document. 
C)  The text does not appear in the document. 
D)  The text is moved to a comment.

Question 6

To group shapes,make sure their text wrapping is set to In Line with Text.

Accepted Answer

A) True 
 B)False

Question 7

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.

Question 8

To display section information in the status bar,which of the following should be done?

Accepted Answer

A)  Insert a section break. 
B)  Display the Developer tab. 
C)  Split the view. 
D)  Customize the status bar.

Question 9

Amanda wants to use styles she created in one document in another document.She should do which of the following?

Accepted Answer

A)  Copy the styles to the other document using the Manage Styles command. 
B)  Copy the styles to the other document using the Compare documents command. 
C)  Copy text from the source document and paste it in the destination document using the Keep Source Formatting option. 
D)  Copy text from the source document and paste it in the destination document using the Merge Formatting option.

Question 10

Sharon needs to view the document's character count in the status bar.She should do which of the following?

Accepted Answer

A)  Use the Go To command. 
B)  Customize the status bar. 
C)  Split the view. 
D)  Display the Developer tab.

Question 11

To apply a macro to a document,run the macro.

Accepted Answer

A) True 
 B)False

Question 12

To have a picture appear slightly rotated into the page,which of the following should be done?

Accepted Answer

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

Question 13

To replace a picture in a document,use the Change Picture function.

Accepted Answer

A) True 
 B)False

Question 14

Katie is working on a document written in German.She wants to check the document for spelling errors.Before running spell check,she should do which of the following?

Accepted Answer

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

Question 15

To have a picture appear slightly rotated into the page,apply a 3-D rotation picture effect.

Accepted Answer

A) True 
 B)False

Question 16

To create a macro by performing the steps,which of the following should be done?

Accepted Answer

A)  Create the macro by recording it. 
B)  Create the macro using the Visual Basic window. 
C)  Create the macro by modifying the document's macro security. 
D)  Create the macro by modifying the document properties.

Question 17

Erin needs to move multiple pictures around in a document as if they were a single object.She should do which of the following?

Accepted Answer

A)  Group the pictures. 
B)  Send the pictures to the front. 
C)  Align the pictures to the bottom. 
D)  Change the text wrapping of the pictures.

Question 18

To view a list of macros in a document,click the Macros button in the Developer tab.

Accepted Answer

A) True 
 B)False

Question 19

Tara needs to prevent people from making changes to a document that she plans to distribute.She should do which of the following?

Accepted Answer

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

Question 20

To transfer all data in a table to text separated by tabs,convert the table to text.

Accepted Answer

A) True 
 B)False

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

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

Amanda needs a picture to have a warmer color tone.She should do which of the following?

Amy created a contract that she needs people to sign.She should do which of the following?

Damien needs a line of text to be removed from a document on an as needed basis.He should do which of the following when he wants to remove the text?

Which of the following describes the results of hiding text in Word?

To group shapes,make sure their text wrapping is set to In Line with Text.

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

To display section information in the status bar,which of the following should be done?

Amanda wants to use styles she created in one document in another document.She should do which of the following?

Sharon needs to view the document's character count in the status bar.She should do which of the following?

To apply a macro to a document,run the macro.

To have a picture appear slightly rotated into the page,which of the following should be done?

To replace a picture in a document,use the Change Picture function.

Katie is working on a document written in German.She wants to check the document for spelling errors.Before running spell check,she should do which of the following?

To have a picture appear slightly rotated into the page,apply a 3-D rotation picture effect.

To create a macro by performing the steps,which of the following should be done?

Erin needs to move multiple pictures around in a document as if they were a single object.She should do which of the following?

To view a list of macros in a document,click the Macros button in the Developer tab.

Tara needs to prevent people from making changes to a document that she plans to distribute.She should do which of the following?

To transfer all data in a table to text separated by tabs,convert the table to text.