Deck 6: Creating, Sorting, and Querying a Table

Question 1

To ensure a mail merge document is free of errors,inspect the document.

Answer 1

False

Question 2

To enter a new recipient list for a mail merge,which of the following options should be selected?

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

Answer 2

C

Question 3

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

Answer 3

False

Question 4

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

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

Question 5

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

Question 6

To add a greeting line to a mail merge document,insert the Title merge field.

Question 7

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.

Question 8

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

Question 9

To add logic to a mail merge,insert an IF field.

Question 10

Kevin needs to center text between the top and bottom of a page.He should do which of the following?

A) Change the vertical alignment of the page.
B) Change the paragraph alignment.
C) Change the page orientation.
D) Change the page margin.

Question 11

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

Question 12

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?

A) Use the current document.
B) Start from a template.
C) Start from an existing document.

Question 13

To add a mail merge field to a document,insert a citation.

Question 14

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

Question 15

To set custom page margins,adjust the page size.

Question 16

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

Question 17

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

Question 18

To generate Word documents based on your mail merge,select the Edit Individual Documents option.

Question 19

To set a document's page layout to landscape,change the page orientation.

Question 20

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

A) The author needs to be prompted to fill-in text in a mail merge field.
B) The author needs to include a greeting line in a mail merge document.
C) The author needs to include text in a mail merge document under certain conditions.
D) The author needs to include an address line in a mail merge document.

Question 21

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

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 22

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?

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

Question 23

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

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 24

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

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

Question 25

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

A) Edit individual documents.
B) Print documents.
C) Send email messages.
D) Merge to Adobe PDF.

Question 26

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?

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

Question 27

Joanne needs to have text inserted in a mail merge document if the recipient's city is "Fairview." She should do which of the following?

A) Insert an IF field in the document.
B) Insert a Fill-in field in the document.
C) Insert a Next Record field in the document.
D) Insert a Set Bookmark field in the document.

Question 28

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

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 29

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

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

Question 30

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

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

Question 31

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?

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

Question 32

To align document text to the bottom of the page,which of the following should be done?

A) Change the page orientation.
B) Change the paragraph alignment.
C) Change the vertical alignment of the page.
D) Change the page margin.

Question 33

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

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

Question 34

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

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 35

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

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

Question 36

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?

A) Use the current document.
B) Start from a template.
C) Start from an existing document.

Question 37

To locate a recipient in a mail merge recipient list,which of the following should be done?

A) Use the Match Fields function.
B) Use the Check for Errors function.
C) Use the Find Recipient function.
D) Use the Inspect Document function.

Question 38

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?

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

Question 39

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

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

Question 40

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?

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 41

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

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

Question 42

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

A) Add an address block.
B) Add a greeting line.
C) Add electronic postage.

Question 43

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?

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 44

Which of the following describes how to use the "Otherwise insert this text:" box when inserting an IF field in a mail merge document?

A) Enter text in the "Otherwise insert this text:" that you want to include in a document when the IF statement is false.
B) Enter text in the "Otherwise insert this text:" that you want to include in a document when the IF statement is true.
C) Enter text in the "Otherwise insert this text:" that you want to include in the document regardless of whether the IF statement is true or false.

Question 45

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?

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 46

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?

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 47

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?

A) Click Update Labels.
B) Click Match Fields.
C) Click Finish & Merge.
D) Click Edit Recipient List.

Question 48

Which of the following describes the purpose of changing the vertical alignment of the page?

A) Changing the vertical alignment of the page specifies how text is positioned relative to the top and bottom of the page.
B) Changing the vertical alignment of the page specifies how text is positioned relative to the left and right of the page.
C) Changing the vertical alignment of the page specifies whether the page has landscape or portrait orientation.
D) Changing the vertical alignment of the page specifies the size of the margins on a page.

Question 49

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?

A) Click Update Labels.
B) Click Edit Recipient List.
C) Click Finish & Merge.
D) Click Match Fields.

Question 50

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?

A) Use the current document.
B) Start from a template.
C) Start from existing document.

Question 51

Which of the following is an important factor in deciding whether to create envelopes via mail merge or mailing labels via mail merge?

A) Whether or not your printer can accommodate the desired envelope size.
B) The size of the mail merge recipient list.
C) The distance that the mailings will need to travel.
D) Whether or not you use the mail merge wizard to create your document.

Question 52

To enable people viewing a document to enter a date,which of the following should be done?

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

Question 53

Which of the following fields do you need to include in a mailing envelope?

A) ZIP_Code
B) Title
C) Email_Address
D) Work_Phone

Question 54

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?

A) Address_Line_1 only.
B) Address_Line_2 only.
C) Address_Line_1 and Address_Line_2.

Question 55

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?

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

Question 56

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

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

Question 57

Which of the following describes the purpose of adding a Greeting Line merge field 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 58

Jasmine needs to insert the text "Illinois" when the State field is blank.She should do which of the following?

A) Insert a Fill-in field in the document.
B) Insert a Set Bookmark field in the document.
C) Insert an IF field in the document.
D) Insert a Next Record field in the document.

Question 59

Which of the following describes what happens when you preview a mail merge?

A) PDFs are generated from the mail merge document.
B) Word files are generated from the mail merge document.
C) The merge fields are populated with data in the header.
D) The merge fields are populated with data in the recipient list.

Question 60

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?

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

Question 61

Which of the following is a reason to sort a mail merge recipient list?

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 62

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

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

Question 63

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

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.