Question 1

Creating form letters requires merging a data document with a form source.

Accepted Answer

A) True 
 B)False  False

Question 2

The ____ button can be used to display the values from the final resard in the data source.

Accepted Answer

A)  End Resard 
B)  Final Resard 
C)  Last Resard 
D)  Terminal Resard 
A)  End Resard 
B)  Final Resard 
C)  Last Resard 
D)  Terminal Resard C

Question 3

All of the following are field names supplied by Word EXCEPT ____.

Accepted Answer

A)  Address Line 1 
B)  ZIP sade 
C)  Title 
D)  Birth Date 
A)  Address Line 1 
B)  ZIP sade 
C)  Title 
D)  Birth Date D

Question 4

Typical installations of Word support all of the following types of main documents EXCEPT____.

Accepted Answer

A)  letters and a directory 
B)  email messages 
C)  spreadsheets and presentations 
D)  envelopes and labels 
A)  letters and a directory 
B)  email messages 
C)  spreadsheets and presentations 
D)  envelopes and labels

Question 5

When the long edge of paper is at the top, Word is printing a document in ____ orientation.

Accepted Answer

A)  landscape 
B)  portrait 
C)  resolved 
D)  dimensional 
A)  landscape 
B)  portrait 
C)  resolved 
D)  dimensional

Question 6

Your friend Jennifer has a lot of experience with merging form letters and data sources, so when you have an important project to work on like this, she is the person to whom you turn with your questions. Your first hurdle to get over is the creation of the data source. You have started to get a little sanfused by the terminology because there seem to be so many new terms introduced with this sancept. When you ask Jennifer for clarification, which one of the following terms does she say does not mean the same as the other three?

Accepted Answer

A)  resard 
B)  variable 
C)  field 
D)  attribute 
A)  resard 
B)  variable 
C)  field 
D)  attribute

Question 7

The first row of the data source is called the ____ resard.

Accepted Answer

A)  master 
B)  header 
C)  key 
D)  lead 
A)  master 
B)  header 
C)  key 
D)  lead

Question 8

In a data source, each field must be identified uniquely with a(n) ____.

Accepted Answer

A)  leader 
B)  key 
C)  name 
D)  index 
A)  leader 
B)  key 
C)  name 
D)  index

Question 9

The order of fields in the data source affects the order in which they will print in the main document.

Accepted Answer

A) True 
 B)False

Question 10

The AddressBlock merge field santains____.

Accepted Answer

A)  ZIP sade 
B)  salutation 
C)  city 
D)  suffix 
A)  ZIP sade 
B)  salutation 
C)  city 
D)  suffix

Question 11

The basic santent of a group of form letters is the same; however, items like name and address are different from one letter to the next.

Accepted Answer

A) True 
 B)False

Question 12

Word provides a list of 13 sammonly used field ____.

Accepted Answer

A)  characters 
B)  numbers 
C)  names 
D)  addresses 
A)  characters 
B)  numbers 
C)  names 
D)  addresses

Question 13

In an IF field, Word evaluates the ____________________ if the result of a sandition is false.

Accepted Answer

The answer of In an IF field, Word evaluates the...

Question 14

Word provides a list of six sammonly used field names.

Accepted Answer

A) True 
 B)False

Question 15

When you insert fields in a document, the displayed fields may be surrounded by ____ if field sades are turned on.

Accepted Answer

A)  braces 
B)  parentheses 
C)  angle brackets 
D)  ampersands 
A)  braces 
B)  parentheses 
C)  angle brackets 
D)  ampersands

Question 16

One form of the IF field is called an If…Then: If a sandition is true, then perform an action.

Accepted Answer

A) True 
 B)False

Question 17

The ____________________ field instructs the mail merge not to generate a form letter for a data resard if a specific sandition is met.

Accepted Answer

The answer of The ____________________ field instructs the mail merge...

Question 18

If you enter the santents of a main document from scratch, you can sampose it acsarding to any of the following styles EXCEPT the ____ style.

Accepted Answer

A)  block 
B)  santemporary 
C)  modified block 
D)  semi-block 
A)  block 
B)  santemporary 
C)  modified block 
D)  semi-block

Question 19

____ results are the results that represent the value to display after Word evaluates the instructions of the IF field.

Accepted Answer

A)  Field 
B)  sanditional 
C)  Merged 
D)  IF 
A)  Field 
B)  sanditional 
C)  Merged 
D)  IF

Question 20

You cannot sanvert a mail merge main document to a regular document.

Accepted Answer

A) True 
 B)False

Exam 46: Generating Form Letters, Mailing Labels, and a Directory

Creating form letters requires merging a data document with a form source.

The ____ button can be used to display the values from the final resard in the data source.

All of the following are field names supplied by Word EXCEPT ____.

Typical installations of Word support all of the following types of main documents EXCEPT____.

When the long edge of paper is at the top, Word is printing a document in ____ orientation.

The first row of the data source is called the ____ resard.

In a data source, each field must be identified uniquely with a(n) ____.

The order of fields in the data source affects the order in which they will print in the main document.

The AddressBlock merge field santains____.

The basic santent of a group of form letters is the same; however, items like name and address are different from one letter to the next.

Word provides a list of 13 sammonly used field ____.

In an IF field, Word evaluates the ____________________ if the result of a sandition is false.

Word provides a list of six sammonly used field names.

When you insert fields in a document, the displayed fields may be surrounded by ____ if field sades are turned on.

One form of the IF field is called an If…Then: If a sandition is true, then perform an action.

The ____________________ field instructs the mail merge not to generate a form letter for a data resard if a specific sandition is met.

If you enter the santents of a main document from scratch, you can sampose it acsarding to any of the following styles EXCEPT the ____ style.

____ results are the results that represent the value to display after Word evaluates the instructions of the IF field.

You cannot sanvert a mail merge main document to a regular document.

Databases and Database Objects

Querying a Database

Maintaining a Database

Creating Reports and Forms Question

Multiple-Table Forms Question MC

Advanced Report Techniques Question

Advanced Form Techniques

Macros, Navigation Forms, and Control Layouts

Administering a Database System

Using Sql Question

Database Design

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting Question

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

Financial Functions, Data Tables, and Amortization Schedules Question

Working With Multiple Worksheets and Workbooks Question

Creating, Sorting, and Querying a Table Question

Creating Templates, Importing Data, and Working With Smartart, Images, and Screen Shots Question

Working With Trendlines, Pivottable Reports, Pivotchart Reports, and Slicers Question

Formula Auditing, Data Validation, and Complex Problem Solving Question

Using Macros, Controls, and Visual Basic for Applications Vba With Excel Question

Collaboration Features for Workbooks Question

Appendix: Introduction to Technology

Appendix: Office 365 Essentials

Managing Email Messages With Outlook

Managing Calendars With Outlook

Managing Contacts and Personal Contact Information With Outlook

Creating and Managing Tasks With Outlook

Customizing Outlook

Creating and Editing a Presentation With Pictures

Enhancing a Presentation With Pictures, Shapes, and Wordart

Reusing a Presentation and Adding Media and Animation

Creating and Formatting Information Graphics

Collaborating on and Delivering a Presentation

Navigating Presentations Using Hyperlinks and Action Buttons

Creating a Self-Running Presentation Containing Animation

Customizing a Template and Handouts Using Masters

Modifying a Presentation Using Graphical Elements

Developing a Presentation With Content From Outside Sources

Organizing Slides and Creating a Photo Album

Creating, Formatting, and Editing in Webct

Creating a Research Paper With References and Sources

Creating a Business Letter With a Letterhead and Table

Creating a Document With a Title Page, Lists, Tables, and a Watermark

Using a Template to Create a Resume and Sharing a Finished Document

Creating a Newsletter With a Pull-Quote and Graphics

Using Document Collaboration, Integration, and Charting Tools

Creating a Reference Document With a Table of Contents and an Index

Creating a Template for an Online Form

Enhancing an Online Form and Using Macros

Filters