Question 1

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 2

Susan needs to send the results of a mail merge to clients who may or may not have Microsoft Office installed.She wants clients to be able to open a viewable version of the document.She should do which of the following?

Accepted Answer

A)  Merge to Adobe PDF. 
B)  Print documents. 
C)  Edit individual documents. 
A)  Merge to Adobe PDF. 
B)  Print documents. 
C)  Edit individual documents.

Question 3

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 4

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 5

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. 
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 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 transfer all data in a table to text separated by tabs,which of the following should be done?

Accepted Answer

A)  Change the alignment of the table. 
B)  Apply a table style to the table. 
C)  Convert the table to text. 
D)  Apply shading to the table. 
A)  Change the alignment of the table. 
B)  Apply a table style to the table. 
C)  Convert the table to text. 
D)  Apply shading to the table.

Question 8

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 9

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 10

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 11

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

Accepted Answer

A) True 
 B)False

Question 12

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 13

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

Jacki has a document on her Desktop that she needs to use in a mail merge.She 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 15

Daniel needs to enable people viewing a document to enter a date.He should do which of the following?

Accepted Answer

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

Question 16

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 17

To set custom page margins,adjust the page size.

Accepted Answer

A) True 
 B)False

Question 18

To arrange recipients in a mail merge alphabetically by last name,which of the following should be done?

Accepted Answer

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

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

Susan needs to send the results of a mail merge to clients who may or may not have Microsoft Office installed.She wants clients to be able to open a viewable version of the document.She should do which of the following?

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?

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?

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

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

To transfer all data in a table to text separated by tabs,which of the following should be done?

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

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?

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

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

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?

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?

Jacki has a document on her Desktop that she needs to use in a mail merge.She should select which of the following options in the Mail Merge Wizard?

Daniel needs to enable people viewing a document to enter a date.He should do which of the following?

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

To set custom page margins,adjust the page size.

To arrange recipients in a mail merge alphabetically by last name,which of the following should be done?

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

Summarizing Data With Pivottables: Preparing a Social Media Marketing Report

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

Exploring Financial Tools and Functions: Analyzing a Business Plan

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

Filters

Exam 6: Managing Data With Data Tools: Analyzing Employment Data

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

Susan needs to send the results of a mail merge to clients who may or may not have Microsoft Office installed.She wants clients to be able to open a viewable version of the document.She should do which of the following?

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?

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?

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

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

To transfer all data in a table to text separated by tabs,which of the following should be done?

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

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?

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

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

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?

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?

Jacki has a document on her Desktop that she needs to use in a mail merge.She should select which of the following options in the Mail Merge Wizard?

Daniel needs to enable people viewing a document to enter a date.He should do which of the following?

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

To set custom page margins,adjust the page size.

To arrange recipients in a mail merge alphabetically by last name,which of the following should be done?

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

Summarizing Data With Pivottables: Preparing a Social Media Marketing Report

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

Exploring Financial Tools and Functions: Analyzing a Business Plan

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

Filters