Question 1

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

To locate a recipient in a mail merge recipient list,click the Find Recipient button.

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

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 6

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 7

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

Accepted Answer

A) True 
 B)False

Question 8

Which of the following describes the purpose of inserting a Date Picker content control?

Accepted Answer

A)  Enable a person viewing a document to enter a date in the document. 
B)  Display the last-modified date in a document. 
C)  Specify the Created document property. 
D)  Establish a date on which the document will be destroyed. 
A)  Enable a person viewing a document to enter a date in the document. 
B)  Display the last-modified date in a document. 
C)  Specify the Created document property. 
D)  Establish a date on which the document will be destroyed.

Question 9

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 10

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. 
A)  Use the current document. 
B)  Start from a template. 
C)  Start from existing document.

Question 11

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

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

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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 15

Laila needs to correct an entry in the recipient list of a mail merge document.She should do which of the following?

Accepted Answer

A)  Edit the document's style set. 
B)  Edit the document's header. 
C)  Edit the document's properties. 
D)  Edit the document's recipient list. 
A)  Edit the document's style set. 
B)  Edit the document's header. 
C)  Edit the document's properties. 
D)  Edit the document's recipient list.

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

Jane needs to print her mail merge.She should do which of the following?

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 18

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 19

Amed needs his mail merge document to print alphabetically according to the City field.He should do which of the following?

Accepted Answer

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

Question 20

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

The Update Labels command does which of the following?

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

To locate a recipient in a mail merge recipient list,click the Find Recipient button.

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

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.

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?

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

Which of the following describes the purpose of inserting a Date Picker 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?

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?

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.

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

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?

Laila needs to correct an entry in the recipient list of a mail merge document.She should do which of the following?

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

Jane needs to print her mail merge.She should do which of the following?

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

Amed needs his mail merge document to print alphabetically according to the City field.He should do which of the following?

To create envelopes using the Mail Merge Wizard,which of the following options should be selected?

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

The Update Labels command does which of the following?

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

To locate a recipient in a mail merge recipient list,click the Find Recipient button.

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

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.

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?

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

Which of the following describes the purpose of inserting a Date Picker 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?

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?

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.

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

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?

Laila needs to correct an entry in the recipient list of a mail merge document.She should do which of the following?

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

Jane needs to print her mail merge.She should do which of the following?

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

Amed needs his mail merge document to print alphabetically according to the City field.He should do which of the following?

To create envelopes using the Mail Merge Wizard,which of the following options should be selected?

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