Question 1

Tim needs to view how a mail merge document will appear after merge fields have been filled. He should do which of the following?

Accepted Answer

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

Question 2

John needs to view the merge fields in a document. To help locate them, he should click Highlight Merge Fields.

Accepted Answer

A) True 
 B)False

Question 3

The dynamic parts of a mail merge that are populated with recipient information are which of the following?

Accepted Answer

A)  Labels. 
B)  Merge fields. 
C)  Tables. 
D)  Equations. 
A)  Labels. 
B)  Merge fields. 
C)  Tables. 
D)  Equations.

Question 4

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.

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

Samantha needs certain text to be inserted in a merged document if the City field equals "Bristol." She should create a filter for the mail merge.

Accepted Answer

False - ru

Question 7

To modify a field in a mail merge, edit the document's References List.

Accepted Answer

False - recipient
Fa

Question 8

Jayla opened a document that has information separated by tab characters and paragraph characters. She wants the information displayed in a table. She should click Table and then Convert Text to Table.

Accepted Answer

A) True 
 B)False

Question 9

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 10

James needs to correct an error in a mail merge recipient list. He should do which of the following?

Accepted Answer

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

Question 11

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 12

To specify which recipients to include in a mail merge, select mail merge recipients.

Accepted Answer

A) True 
 B)False

Question 13

Karen is working on a mail merge document and needs to add the text "Dear," followed by the recipient's name and a comma. She should do which of the following?

Accepted Answer

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

Question 14

Brandon has a document with a large amount of data separated by tab characters and paragraph characters. He wants the information displayed in a table. He should do which of the following?

Accepted Answer

A)  Select the data and then click Convert Text to Table. 
B)  Copy the text into the document header. 
C)  Create a table and then manually populate each cell with data. 
D)  Create a table and then click Convert to Text. 
A)  Select the data and then click Convert Text to Table. 
B)  Copy the text into the document header. 
C)  Create a table and then manually populate each cell with data. 
D)  Create a table and then click Convert to Text.

Question 15

Susie is creating a recipient list for a mail merge document. She has information that she wants stored in a field called "Status." She should do which of the following?

Accepted Answer

A)  Add a field called "Status". 
B)  Add an entry and enter "Status" in the first field. 
C)  There is no way to create custom fields in Word. 
A)  Add a field called "Status". 
B)  Add an entry and enter "Status" in the first field. 
C)  There is no way to create custom fields in Word.

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 create envelopes using the Mail Merge Wizard, which of the following options should be selected?

Accepted Answer

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

Question 18

The Update Labels command does which of the following?

Accepted Answer

A)  Sets rules to control how Word merges the data in the data source with the main document. 
B)  Searches for a specific record in the merged document. 
C)  Checks for and reports errors in the merge. 
D)  Updates all the labels in a label main document to match the content and formatting of the first label. 
A)  Sets rules to control how Word merges the data in the data source with the main document. 
B)  Searches for a specific record in the merged document. 
C)  Checks for and reports errors in the merge. 
D)  Updates all the labels in a label main document to match the content and formatting of the first label.

Question 19

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 20

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.

Tim needs to view how a mail merge document will appear after merge fields have been filled. He should do which of the following?

John needs to view the merge fields in a document. To help locate them, he should click Highlight Merge Fields.

The dynamic parts of a mail merge that are populated with recipient information are which of the following?

To arrange recipients in a mail merge alphabetically by last name, 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?

Samantha needs certain text to be inserted in a merged document if the City field equals "Bristol." She should create a filter for the mail merge.

To modify a field in a mail merge, edit the document's References List.

Jayla opened a document that has information separated by tab characters and paragraph characters. She wants the information displayed in a table. She should click Table and then Convert Text to Table.

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?

James needs to correct an error in a mail merge recipient list. He should do which of the following?

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?

To specify which recipients to include in a mail merge, select mail merge recipients.

Karen is working on a mail merge document and needs to add the text "Dear," followed by the recipient's name and a comma. She should do which of the following?

Brandon has a document with a large amount of data separated by tab characters and paragraph characters. He wants the information displayed in a table. He should do which of the following?

Susie is creating a recipient list for a mail merge document. She has information that she wants stored in a field called "Status." She 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 create envelopes using the Mail Merge Wizard, which of the following options should be selected?

The Update Labels command does 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?

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

Tim needs to view how a mail merge document will appear after merge fields have been filled. He should do which of the following?

John needs to view the merge fields in a document. To help locate them, he should click Highlight Merge Fields.

The dynamic parts of a mail merge that are populated with recipient information are which of the following?

To arrange recipients in a mail merge alphabetically by last name, 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?

Samantha needs certain text to be inserted in a merged document if the City field equals "Bristol." She should create a filter for the mail merge.

To modify a field in a mail merge, edit the document's References List.

Jayla opened a document that has information separated by tab characters and paragraph characters. She wants the information displayed in a table. She should click Table and then Convert Text to Table.

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?

James needs to correct an error in a mail merge recipient list. He should do which of the following?

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?

To specify which recipients to include in a mail merge, select mail merge recipients.

Karen is working on a mail merge document and needs to add the text "Dear," followed by the recipient's name and a comma. She should do which of the following?

Brandon has a document with a large amount of data separated by tab characters and paragraph characters. He wants the information displayed in a table. He should do which of the following?

Susie is creating a recipient list for a mail merge document. She has information that she wants stored in a field called "Status." She 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 create envelopes using the Mail Merge Wizard, which of the following options should be selected?

The Update Labels command does 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?

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