Question 1

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. 
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 2

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 3

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 4

To resize a shape nonproportionally,which of the following should be done?

Accepted Answer

A)  Click and drag the corner sizing handle. 
B)  Select the Lock aspect ratio check box and then enter values. 
C)  Click and drag a middle sizing handle. 
D)  ALT+SHIFT-Click and drag the corner sizing handle. 
A)  Click and drag the corner sizing handle. 
B)  Select the Lock aspect ratio check box and then enter values. 
C)  Click and drag a middle sizing handle. 
D)  ALT+SHIFT-Click and drag the corner sizing handle.

Question 5

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 6

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 7

David needs an oval to appear in his document.He should do which of the following?

Accepted Answer

A)  Click the Chart button and select the desired option. 
B)  Click the Shapes button and select the desired option. 
C)  Click the Table button and select the desired option. 
D)  Click the WordArt button and select the desired option. 
A)  Click the Chart button and select the desired option. 
B)  Click the Shapes button and select the desired option. 
C)  Click the Table button and select the desired option. 
D)  Click the WordArt button and select the desired option.

Question 8

Kayla wants light text to appear in the background of every page of a document,she should add a text watermark.

Accepted Answer

A) True 
 B)False

Question 9

To locate a tab character in a document,use the Find and Replace dialogue box and search for the appropriate special character.

Accepted Answer

A) True 
 B)False

Question 10

Katlyn needs to remove all tab characters from a document.She should locate the tab characters by doing which of the following?

Accepted Answer

A)  Use Go To to locate the desired text. 
B)  Manually locate tab characters by scrolling through the document. 
C)  Use the Find and Replace dialogue box to locate the tab characters. 
A)  Use Go To to locate the desired text. 
B)  Manually locate tab characters by scrolling through the document. 
C)  Use the Find and Replace dialogue box to locate the tab characters.

Question 11

Kyle needs the same text to appear at the top of each page in a document.Which of the following is the best method to achieve this?

Accepted Answer

A)  Edit the document header. 
B)  Manually enter the desired text at the top of each page. 
C)  Modify the Document Properties. 
D)  Add a comment at the top of each page. 
A)  Edit the document header. 
B)  Manually enter the desired text at the top of each page. 
C)  Modify the Document Properties. 
D)  Add a comment at the top of each page.

Question 12

To resize the width of a picture without changing the height,resize the picture nonproportionally.

Accepted Answer

A) True 
 B)False

Question 13

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 14

To have text appear in the background of every page in a document,which of the following should be done?

Accepted Answer

A)  Insert a Text Box. 
B)  Insert a text watermark. 
C)  Insert WordArt. 
D)  Insert SmartArt. 
A)  Insert a Text Box. 
B)  Insert a text watermark. 
C)  Insert WordArt. 
D)  Insert SmartArt.

Question 15

To add a Glow effect to a picture,which of the following do you do?

Accepted Answer

A)  Apply a Picture Effect. 
B)  Apply a Picture Border. 
C)  Change the Picture Layout. 
D)  Apply an Artistic Effect. 
A)  Apply a Picture Effect. 
B)  Apply a Picture Border. 
C)  Change the Picture Layout. 
D)  Apply an Artistic Effect.

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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. 
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 18

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 19

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. 
A)  Use the Go To command. 
B)  Customize the status bar. 
C)  Split the view. 
D)  Display the Developer tab.

Question 20

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

Accepted Answer

A) True 
 B)False

To create a macro by performing the steps,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.

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

To resize a shape nonproportionally,which of the following should be done?

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

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

David needs an oval to appear in his document.He should do which of the following?

Kayla wants light text to appear in the background of every page of a document,she should add a text watermark.

To locate a tab character in a document,use the Find and Replace dialogue box and search for the appropriate special character.

Katlyn needs to remove all tab characters from a document.She should locate the tab characters by doing which of the following?

Kyle needs the same text to appear at the top of each page in a document.Which of the following is the best method to achieve this?

To resize the width of a picture without changing the height,resize the picture nonproportionally.

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

To have text appear in the background of every page in a document,which of the following should be done?

To add a Glow effect to a picture,which of the following do you do?

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

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

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

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

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

Getting Started With Excel: Tracking Miscellaneous Expenses for a Conference

Formatting Workbook Text and Data: Creating a Sales Report

Performing Calculations With Formulas and Functions: Staffing a Call Center

Analyzing and Charting Financial Data: Preparing an Investment Report

Generating Reports From Multiple Worksheets and Workbooks: Summarizing Profit and Lo

Managing Data With Data Tools: Analyzing Employment Data

Summarizing Data With Pivottables: Preparing a Social Media Marketing Report

Exploring Financial Tools and Functions: Analyzing a Business Plan

Analyzing Data With Business Intelligence Tools: Presenting Sales and Revenue Data

Filters

Exam 8: Performing What-If Analyses: Maximizing Profits With the Right Product Mix

To create a macro by performing the steps,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.

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

To resize a shape nonproportionally,which of the following should be done?

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

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

David needs an oval to appear in his document.He should do which of the following?

Kayla wants light text to appear in the background of every page of a document,she should add a text watermark.

To locate a tab character in a document,use the Find and Replace dialogue box and search for the appropriate special character.

Katlyn needs to remove all tab characters from a document.She should locate the tab characters by doing which of the following?

Kyle needs the same text to appear at the top of each page in a document.Which of the following is the best method to achieve this?

To resize the width of a picture without changing the height,resize the picture nonproportionally.

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

To have text appear in the background of every page in a document,which of the following should be done?

To add a Glow effect to a picture,which of the following do you do?

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

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

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

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

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

Getting Started With Excel: Tracking Miscellaneous Expenses for a Conference

Formatting Workbook Text and Data: Creating a Sales Report

Performing Calculations With Formulas and Functions: Staffing a Call Center

Analyzing and Charting Financial Data: Preparing an Investment Report

Generating Reports From Multiple Worksheets and Workbooks: Summarizing Profit and Lo

Managing Data With Data Tools: Analyzing Employment Data

Summarizing Data With Pivottables: Preparing a Social Media Marketing Report

Exploring Financial Tools and Functions: Analyzing a Business Plan

Analyzing Data With Business Intelligence Tools: Presenting Sales and Revenue Data

Filters