Question 1

To create envelopes via mail merge, select the Letters option in the Mail Merge Wizard.

Accepted Answer

False - envelopes
False - Envelopes
False - ENVELOPES

Question 2

To enable people viewing a document to enter a date, which of the following should be done?

Accepted Answer

A)  Insert a Check Box content control. 
B)  Insert a Drop-Down List content control. 
C)  Insert a Picture content control. 
D)  Insert a Date Picker content control. 
A)  Insert a Check Box content control. 
B)  Insert a Drop-Down List content control. 
C)  Insert a Picture content control. 
D)  Insert a Date Picker content control. D

Question 3

Which of the following describes the purpose of adding a Greeting Line merge field to a document?

Accepted Answer

A)  Greeting lines add recipient address information to a document. 
B)  Greeting lines add a salutation and a recipient's name. 
C)  Greeting lines add postage information to a document. 
D)  Greeting lines add only preset greeting information to a document. 
A)  Greeting lines add recipient address information to a document. 
B)  Greeting lines add a salutation and a recipient's name. 
C)  Greeting lines add postage information to a document. 
D)  Greeting lines add only preset greeting information to a document. B

Question 4

Which of the following describes what happens when you preview a mail merge?

Accepted Answer

A)  PDFs are generated from the mail merge document. 
B)  Word files are generated from the mail merge document. 
C)  The merge fields are populated with data in the header. 
D)  The merge fields are populated with data in the recipient list. 
A)  PDFs are generated from the mail merge document. 
B)  Word files are generated from the mail merge document. 
C)  The merge fields are populated with data in the header. 
D)  The merge fields are populated with data in the recipient list.

Question 5

To add a mail merge field to a document, insert a citation.

Accepted Answer

A) True 
 B)False

Question 6

To add the text "To," followed by the recipient's name and a colon, which of the following should be done?

Accepted Answer

A)  Add a Title. 
B)  Add an Address Block. 
C)  Add labels. 
D)  Add a Greeting Line. 
A)  Add a Title. 
B)  Add an Address Block. 
C)  Add labels. 
D)  Add a Greeting Line.

Question 7

To set custom page margins, adjust the page size.

Accepted Answer

A) True 
 B)False

Question 8

Laura is working on a mail merge with hundreds of recipients. The address of one of the recipients needs to be corrected. She should locate the recipient by doing which of the following?

Accepted Answer

A)  Use the Find Recipient function. 
B)  Use the Check for Errors function. 
C)  Use the Match Fields function. 
D)  Use the Inspect Document function. 
A)  Use the Find Recipient function. 
B)  Use the Check for Errors function. 
C)  Use the Match Fields function. 
D)  Use the Inspect Document function.

Question 9

To arrange recipients in a mail merge alphabetically by last name, filter the recipients' list.

Accepted Answer

False - so

Question 10

Jared has envelopes that do not fit in his printer. He wants to automate adding addresses to the envelopes. He should do which of the following?

Accepted Answer

A)  Use mail merge to create mailing labels for the envelopes. 
B)  Create a table in a document with all the recipient information. 
C)  Save the recipient information to an HTML document. 
D)  Since his envelopes do not fit in his printer, he cannot automate the process. 
A)  Use mail merge to create mailing labels for the envelopes. 
B)  Create a table in a document with all the recipient information. 
C)  Save the recipient information to an HTML document. 
D)  Since his envelopes do not fit in his printer, he cannot automate the process.

Question 11

To individually modify the results of a mail merge, which of the following options should be selected?

Accepted Answer

A)  Edit individual documents. 
B)  Print documents. 
C)  Send email messages. 
D)  Merge to Adobe PDF. 
A)  Edit individual documents. 
B)  Print documents. 
C)  Send email messages. 
D)  Merge to Adobe PDF.

Question 12

Laila needs to correct an entry in the recipient list of a mail merge document. She should do which of the following?

Accepted Answer

A)  Edit the document's style set. 
B)  Edit the document's header. 
C)  Edit the document's properties. 
D)  Edit the document's recipient list. 
A)  Edit the document's style set. 
B)  Edit the document's header. 
C)  Edit the document's properties. 
D)  Edit the document's recipient list.

Question 13

Jordan has an open document that he needs to use in a mail merge. He should select which of the following options in the Mail Merge Wizard?

Accepted Answer

A)  Use the current document. 
B)  Start from a template. 
C)  Start from an existing document. 
A)  Use the current document. 
B)  Start from a template. 
C)  Start from an existing document.

Question 14

To enter a new recipient list for a mail merge, which of the following options should be selected?

Accepted Answer

A)  Use an Existing List. 
B)  Select from Outlook Contacts. 
C)  Type a New List. 
A)  Use an Existing List. 
B)  Select from Outlook Contacts. 
C)  Type a New List.

Question 15

Exit Word by opening the View menu and then selecting Close.

Accepted Answer

False - Fi

Question 16

Use the Combo Picker content control to allow people viewing a document to enter a date.

Accepted Answer

False - da

Question 17

To add recipient address information to a mail merge document, which of the following should be done?

Accepted Answer

A)  Add an address block. 
B)  Add a greeting line. 
C)  Add electronic postage. 
A)  Add an address block. 
B)  Add a greeting line. 
C)  Add electronic postage.

Question 18

Which of the following describes the purpose of inserting a Date Picker content control?

Accepted Answer

A)  Enable a person viewing a document to enter a date in the document. 
B)  Display the last-modified date in a document. 
C)  Specify the Created document property. 
D)  Establish a date on which the document will be destroyed. 
A)  Enable a person viewing a document to enter a date in the document. 
B)  Display the last-modified date in a document. 
C)  Specify the Created document property. 
D)  Establish a date on which the document will be destroyed.

Question 19

Amed needs his mail merge document to print alphabetically according to the City field. He should do which of the following?

Accepted Answer

A)  Filter the recipient list. 
B)  Sort the recipient list. 
C)  Edit the recipient list. 
A)  Filter the recipient list. 
B)  Sort the recipient list. 
C)  Edit the recipient list.

Question 20

To locate a recipient in a mail merge recipient list, click the Find Recipient button.

Accepted Answer

A) True 
 B)False

To create envelopes via mail merge, select the Letters option in the Mail Merge Wizard.

To enable people viewing a document to enter a date, which of the following should be done?

Which of the following describes the purpose of adding a Greeting Line merge field to a document?

Which of the following describes what happens when you preview a mail merge?

To add a mail merge field to a document, insert a citation.

To add the text "To," followed by the recipient's name and a colon, which of the following should be done?

To set custom page margins, adjust the page size.

Laura is working on a mail merge with hundreds of recipients. The address of one of the recipients needs to be corrected. She should locate the recipient by doing which of the following?

To arrange recipients in a mail merge alphabetically by last name, filter the recipients' list.

Jared has envelopes that do not fit in his printer. He wants to automate adding addresses to the envelopes. He should do which of the following?

To individually modify the results of a mail merge, which of the following options should be selected?

Laila needs to correct an entry in the recipient list of a mail merge document. She should do which of the following?

Jordan has an open document that he needs to use in a mail merge. He should select which of the following options in the Mail Merge Wizard?

To enter a new recipient list for a mail merge, which of the following options should be selected?

Exit Word by opening the View menu and then selecting Close.

Use the Combo Picker content control to allow people viewing a document to enter a date.

To add recipient address information to a mail merge document, which of the following should be done?

Which of the following describes the purpose of inserting a Date Picker content control?

Amed needs his mail merge document to print alphabetically according to the City field. He should do which of the following?

To locate a recipient in a mail merge recipient list, click the Find Recipient button.

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Generating Reports From Multiple Worksheets and Workbooks

Summarizing Data With Pivottables

Performing What-If Analyses

Exploring Financial Tools and Functions

Analyzing Data With Business Intelligence Tools

Filters

Exam 6: Managing Data With Data Tools

To create envelopes via mail merge, select the Letters option in the Mail Merge Wizard.

To enable people viewing a document to enter a date, which of the following should be done?

Which of the following describes the purpose of adding a Greeting Line merge field to a document?

Which of the following describes what happens when you preview a mail merge?

To add a mail merge field to a document, insert a citation.

To add the text "To," followed by the recipient's name and a colon, which of the following should be done?

To set custom page margins, adjust the page size.

Laura is working on a mail merge with hundreds of recipients. The address of one of the recipients needs to be corrected. She should locate the recipient by doing which of the following?

To arrange recipients in a mail merge alphabetically by last name, filter the recipients' list.

Jared has envelopes that do not fit in his printer. He wants to automate adding addresses to the envelopes. He should do which of the following?

To individually modify the results of a mail merge, which of the following options should be selected?

Laila needs to correct an entry in the recipient list of a mail merge document. She should do which of the following?

Jordan has an open document that he needs to use in a mail merge. He should select which of the following options in the Mail Merge Wizard?

To enter a new recipient list for a mail merge, which of the following options should be selected?

Exit Word by opening the View menu and then selecting Close.

Use the Combo Picker content control to allow people viewing a document to enter a date.

To add recipient address information to a mail merge document, which of the following should be done?

Which of the following describes the purpose of inserting a Date Picker content control?

Amed needs his mail merge document to print alphabetically according to the City field. He should do which of the following?

To locate a recipient in a mail merge recipient list, click the Find Recipient button.

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Generating Reports From Multiple Worksheets and Workbooks

Summarizing Data With Pivottables

Performing What-If Analyses

Exploring Financial Tools and Functions

Analyzing Data With Business Intelligence Tools

Filters