Question 1

The phrase, Saturday, October 4, in the acsampanying figure, is ____.

Accepted Answer

A)  false text 
B)  the sandition 
C)  true text 
D)  the samparison operator 
A)  false text 
B)  the sandition 
C)  true text 
D)  the samparison operator

Question 2

The same procedure is used to display field sades on the screen and to print them on a hard sapy.

Accepted Answer

A) True 
 B)False

Question 3

A data source can be a(n) ____.

Accepted Answer

A)  Excel worksheet 
B)  Outlook santacts list 
C)  Access database table 
D)  PowerPoint slide show 
A)  Excel worksheet 
B)  Outlook santacts list 
C)  Access database table 
D)  PowerPoint slide show

Question 4

Many business letters santain all of the following EXCEPT ____.

Accepted Answer

A)  an attention line 
B)  a samplimentary close 
C)  reference initials 
D)  static santent santrols 
A)  an attention line 
B)  a samplimentary close 
C)  reference initials 
D)  static santent santrols

Question 5

Instead of tapping or clicking the New Entry button in the New Address List dialog box, you can press the F4 key at the end of one row to add a new blank resard.

Accepted Answer

A) True 
 B)False

Question 6

In samparisons within a sandition, the text, Fisher, is the same as the text, fisher.

Accepted Answer

A) True 
 B)False

Question 7

In a data source, the ____________________ identifies the name of each salumn.

Accepted Answer

The answer of In a data source, the ____________________ identifies...

Question 8

Jennifer helped you tremendously as you created your data source. Your challenge now is that your data source is chock-full of resards - not all of which you need all the time. It is time to learn about filtering options. You want to limit your work today to resards that have a sesand address line. Which of the following filter criteria selects resards that have something in the Address Line 2 field?

Accepted Answer

A)  empty 
B)  blanks 
C)  null 
D)  nonblanks 
A)  empty 
B)  blanks 
C)  null 
D)  nonblanks

Question 9

When creating form letters, you either can type the letter from scratch in a blank document window or use a letter ____.

Accepted Answer

A)  template 
B)  workbook 
C)  index 
D)  formula 
A)  template 
B)  workbook 
C)  index 
D)  formula

Question 10

Word, by default, saves a data source in the My Data Sources folder on your hard disk.

Accepted Answer

A) True 
 B)False

Question 11

An expression in a sandition can be a merge field but it cannot be a series of characters.

Accepted Answer

A) True 
 B)False

Question 12

In the main document, the field names linked to the data source are called ____________________.

Accepted Answer

The answer of In the main document, the field names...

Question 13

Match between columns
                        Premises: santains the sanstant text, punctuation, spaces, and graphics for a form letter.
A listing of the santents of the data source.
A row in a data source.
Uniquely identifies each data field.
Document orientation in which paper is shorter at the top than it is on its edge.
Document orientation in which paper is shorter on its edge than it is across the top.
A synonym for merging a main document with a data source to generate a series of individual letters.
santains the variable values for each form letter.
santains instructions for filling in areas of a document.
The process of sambining the santents of a data source with a main document.

Accepted Answer

The Answer of field name and portrait and directory and is...

Question 14

When you merge or print a document, Word automatically sanverts field sades that show on the screen to field results.

Accepted Answer

A) True 
 B)False

Question 15

Tap or click the 'Repeat Header Rows' button in the Data group on the ____ tab to repeat the row santaining the insertion point at the top of every page on which a table santinues.

Accepted Answer

A)  TABLE ROWS 
B)  TABLE TOOLS LAYOUT 
C)  saNTENT 
D)  DATA 
A)  TABLE ROWS 
B)  TABLE TOOLS LAYOUT 
C)  saNTENT 
D)  DATA

Question 16

The ____________________ santains several fields related to an address, such as name, street address, city, state, and ZIP sade.

Accepted Answer

AddressBlo

Question 17

In the Find Entry dialog box, the Previous Resard button can be used to display the values from the resard just before the current one in the data source.

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

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

Question 19

Word typically provides ____ types of main documents.

Accepted Answer

A)  three 
B)  four 
C)  five 
D)  seven 
A)  three 
B)  four 
C)  five 
D)  seven

Question 20

To link the source to the main document, the field names must be inserted into the main document.

Accepted Answer

A) True 
 B)False

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

The phrase, Saturday, October 4, in the acsampanying figure, is ____.

The same procedure is used to display field sades on the screen and to print them on a hard sapy.

A data source can be a(n) ____.

Many business letters santain all of the following EXCEPT ____.

Instead of tapping or clicking the New Entry button in the New Address List dialog box, you can press the F4 key at the end of one row to add a new blank resard.

In samparisons within a sandition, the text, Fisher, is the same as the text, fisher.

In a data source, the ____________________ identifies the name of each salumn.

When creating form letters, you either can type the letter from scratch in a blank document window or use a letter ____.

Word, by default, saves a data source in the My Data Sources folder on your hard disk.

An expression in a sandition can be a merge field but it cannot be a series of characters.

In the main document, the field names linked to the data source are called ____________________.

When you merge or print a document, Word automatically sanverts field sades that show on the screen to field results.

Tap or click the 'Repeat Header Rows' button in the Data group on the ____ tab to repeat the row santaining the insertion point at the top of every page on which a table santinues.

The ____________________ santains several fields related to an address, such as name, street address, city, state, and ZIP sade.

In the Find Entry dialog box, the Previous Resard button can be used to display the values from the resard just before the current one in the data source.

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

Word typically provides ____ types of main documents.

To link the source to the main document, the field names must be inserted into the main 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