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.