Question 1

Ian wants to create a mail merge document based on a template from Office.com. He should select which of the following options when starting the mail merge?

Accepted Answer

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

Question 2

To exclude certain recipients from a mail merge list, sort the recipient list.

Accepted Answer

A) True 
 B)False

Question 3

To have the labels in a mail merge document match the content and formatting of the first label, which of the following should be done?

Accepted Answer

A)  Click Update Labels. 
B)  Click Match Fields. 
C)  Click Finish & Merge. 
D)  Click Edit Recipient List.

Question 4

To locate a recipient in a mail merge recipient list, which of the following should be done?

Accepted Answer

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

Question 5

Karen needs to find a recipient in a recipient list whose last name is Brady. The list also contains recipients whose first name is Brady. She should do which of the following?

Accepted Answer

A)  Use the Find Entry dialogue box and search for a keyword based on all fields. 
B)  Use the Find Entry dialogue box and search for a keyword based on the Last_Name field. 
C)  Use the Find Entry dialogue box and search for a keyword based on the First_Name field.

Question 6

To view how a mail merge document will appear after merge fields have been filled, which of the following should be done?

Accepted Answer

A)  Check for errors. 
B)  Preview the results. 
C)  Start a Mail Merge. 
D)  Highlight merge fields.

Question 7

To insert an address in a mail merge document, select the Address Block merge field.

Accepted Answer

A) True 
 B)False

Question 8

Jerome needs to create a document with a list of names and telephone addresses for his chess club. He should select which of the following options when starting a mail merge via the Mail Merge Wizard?

Accepted Answer

A)  Letters 
B)  E-mail messages 
C)  Directory 
D)  Labels

Question 9

To select an existing recipient list, click Choose from Outlook Contacts.

Accepted Answer

A) True 
 B)False

Question 10

To ensure a mail merge document is free of errors, inspect the document.

Accepted Answer

A) True 
 B)False

Question 11

The recipients in a mail merge document include addresses that span multiple lines. The author should make sure the mail merge document includes which of the following fields?

Accepted Answer

A)  Address_Line_1 only. 
B)  Address_Line_2 only. 
C)  Address_Line_1 and Address_Line_2.

Question 12

To ensure the merge fields in a template are populated with correct fields in your data source, make sure to match merge fields before performing the merge.

Accepted Answer

A) True 
 B)False

Question 13

To add a greeting line to a mail merge document, insert the Title merge field.

Accepted Answer

A) True 
 B)False

Question 14

To follow a step-by-step process for creating a mail merge, start the Mail Merge Wizard.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following is a reason to sort a mail merge recipient list?

Accepted Answer

A)  Certain recipients need to be excluded from the mail merge result. 
B)  The mail merge result needs to be generated in a specific order. 
C)  Errors in the mail merge document need to be identified. 
D)  Accessibility issues with the mail merge document need to be identified.

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

Shannon needs the labels in a mail merge document to match the content and formatting of the first label. She should do which of the following?

Accepted Answer

A)  Click Update Labels. 
B)  Click Edit Recipient List. 
C)  Click Finish & Merge. 
D)  Click Match Fields.

Question 18

Katie needs to create hundreds of labels for a project. She plans to create a mail merge document to do so. She should select which of the following options in the Mail Merge Wizard?

Accepted Answer

A)  Letters 
B)  E-mail messages 
C)  Envelopes 
D)  Labels

Question 19

Jasmine needs to locate a recipient in a mail merge recipient list. She should do which of the following?

Accepted Answer

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

Question 20

To create a new recipient list for a mail merge, select Use an Existing List.

Accepted Answer

A) True 
 B)False

Exam 6: Managing Data With Data Tools

Ian wants to create a mail merge document based on a template from Office.com. He should select which of the following options when starting the mail merge?

To exclude certain recipients from a mail merge list, sort the recipient list.

To have the labels in a mail merge document match the content and formatting of the first label, which of the following should be done?

To locate a recipient in a mail merge recipient list, which of the following should be done?

Karen needs to find a recipient in a recipient list whose last name is Brady. The list also contains recipients whose first name is Brady. She should do which of the following?

To view how a mail merge document will appear after merge fields have been filled, which of the following should be done?

To insert an address in a mail merge document, select the Address Block merge field.

Jerome needs to create a document with a list of names and telephone addresses for his chess club. He should select which of the following options when starting a mail merge via the Mail Merge Wizard?

To select an existing recipient list, click Choose from Outlook Contacts.

To ensure a mail merge document is free of errors, inspect the document.

The recipients in a mail merge document include addresses that span multiple lines. The author should make sure the mail merge document includes which of the following fields?

To ensure the merge fields in a template are populated with correct fields in your data source, make sure to match merge fields before performing the merge.

To add a greeting line to a mail merge document, insert the Title merge field.

To follow a step-by-step process for creating a mail merge, start the Mail Merge Wizard.

Which of the following is a reason to sort a mail merge recipient list?

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

Shannon needs the labels in a mail merge document to match the content and formatting of the first label. She should do which of the following?

Katie needs to create hundreds of labels for a project. She plans to create a mail merge document to do so. She should select which of the following options in the Mail Merge Wizard?

Jasmine needs to locate a recipient in a mail merge recipient list. She should do which of the following?

To create a new recipient list for a mail merge, select Use an Existing List.