Question 1

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. 
A)  Click Update Labels. 
B)  Click Match Fields. 
C)  Click Finish & Merge. 
D)  Click Edit Recipient List.

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

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 5

Jared needs to update one of the addresses in a recipient list.He should do which of the following?

Accepted Answer

A)  Select recipients. 
B)  Merge to Adobe PDF. 
C)  Edit the recipient list. 
D)  Preview results. 
A)  Select recipients. 
B)  Merge to Adobe PDF. 
C)  Edit the recipient list. 
D)  Preview results.

Question 6

Jared needs to create dozens of envelopes for a mailing.He plans to create a mail merge document to do so.He should select which of the following options in the Mail Merge Wizard?

Accepted Answer

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

Question 7

Samantha needs to create a new recipient list for a mail merge.While using the Mail Merge Wizard,she should select which of the following options?

Accepted Answer

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

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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. 
A)  Check for errors. 
B)  Preview the results. 
C)  Start a Mail Merge. 
D)  Highlight merge fields.

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 generate Word documents based on your mail merge,select the Edit Individual Documents option.

Accepted Answer

A) True 
 B)False

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

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. 
A)  Address_Line_1 only. 
B)  Address_Line_2 only. 
C)  Address_Line_1 and Address_Line_2.

Question 14

Which of the following describes a reason to insert an IF field in a mail merge document?

Accepted Answer

A)  The author needs to include a greeting line in a mail merge document. 
B)  The author needs to include an address line in a mail merge document. 
C)  The author needs to insert text when a given field is equal to specified text. 
D)  The author needs to be prompted to fill-in text in a mail merge field. 
A)  The author needs to include a greeting line in a mail merge document. 
B)  The author needs to include an address line in a mail merge document. 
C)  The author needs to insert text when a given field is equal to specified text. 
D)  The author needs to be prompted to fill-in text in a mail merge field.

Question 15

To send email messages as a result of a mail merge,select which of the following options when finishing the merge?

Accepted Answer

A)  Edit the individual documents. 
B)  Print the documents. 
C)  Send email messages. 
A)  Edit the individual documents. 
B)  Print the documents. 
C)  Send email messages.

Question 16

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.

Question 17

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 
A)  Letters 
B)  E-mail messages 
C)  Directory 
D)  Labels

Question 18

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 19

To see how a mail merge will appear after the fields have been populated,select preview mail merge.

Accepted Answer

A) True 
 B)False

Question 20

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.

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 insert an address in a mail merge document,select the Address Block merge field.

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

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

Jared needs to update one of the addresses in a recipient list.He should do which of the following?

Jared needs to create dozens of envelopes for a mailing.He plans to create a mail merge document to do so.He should select which of the following options in the Mail Merge Wizard?

Samantha needs to create a new recipient list for a mail merge.While using the Mail Merge Wizard,she should select which of the following options?

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

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

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 generate Word documents based on your mail merge,select the Edit Individual Documents option.

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.

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?

Which of the following describes a reason to insert an IF field in a mail merge document?

To send email messages as a result of a mail merge,select which of the following options when finishing the merge?

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

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 enter a new recipient list for a mail merge,which of the following options should be selected?

To see how a mail merge will appear after the fields have been populated,select preview mail merge.

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

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

Working With Large Worksheets, Charting, and What-If Analysis

Financial Functions, Data Tables, and Amortization Schedules

Working With Multiple Worksheets and Workbooks

Creating Templates, Importing Data, and Working With Smartart, Images, and Screenshots

Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers

Formula Auditing, Data Validation, and Complex Problem Solving

Data Analysis With Power Tools and Creating Macros

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

Filters

Exam 6: Creating, Sorting, and Querying a Table

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 insert an address in a mail merge document,select the Address Block merge field.

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

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

Jared needs to update one of the addresses in a recipient list.He should do which of the following?

Jared needs to create dozens of envelopes for a mailing.He plans to create a mail merge document to do so.He should select which of the following options in the Mail Merge Wizard?

Samantha needs to create a new recipient list for a mail merge.While using the Mail Merge Wizard,she should select which of the following options?

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

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

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 generate Word documents based on your mail merge,select the Edit Individual Documents option.

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.

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?

Which of the following describes a reason to insert an IF field in a mail merge document?

To send email messages as a result of a mail merge,select which of the following options when finishing the merge?

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

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 enter a new recipient list for a mail merge,which of the following options should be selected?

To see how a mail merge will appear after the fields have been populated,select preview mail merge.

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

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

Working With Large Worksheets, Charting, and What-If Analysis

Financial Functions, Data Tables, and Amortization Schedules

Working With Multiple Worksheets and Workbooks

Creating Templates, Importing Data, and Working With Smartart, Images, and Screenshots

Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers

Formula Auditing, Data Validation, and Complex Problem Solving

Data Analysis With Power Tools and Creating Macros

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

Filters