Question 1

-Box B in the accompanying figure points to ____.

Accepted Answer

A)  fields currently in the main document 
B)  fields in the data source 
C)  active linked files 
D)  other open Word documents 
A)  fields currently in the main document 
B)  fields in the data source 
C)  active linked files 
D)  other open Word documents

Question 2

You can choose how an object will be pasted by using the Paste Options button on the Paste menu.

Accepted Answer

A) True 
 B)False

Question 3

An advantage of embedding is that the destination file remains fairly small.

Accepted Answer

A) True 
 B)False

Question 4

You work for a small non-profit. Your boss has given you the task of creating thank-you letters to send to people who have donated to your non-profit organization this past year. She has given you a form letter in Word and a database of donors in Access. You need to merge the two.
-Your boss tells you that she'd like to customize a handful of the letters before they get mailed. You click ____ as the merge option.

Accepted Answer

A)  Edit Individual Documents 
B)  Print and Send 
C)  Delete Selected Records 
D)  Finished and Pending 
A)  Edit Individual Documents 
B)  Print and Send 
C)  Delete Selected Records 
D)  Finished and Pending

Question 5

When Excel worksheet data is on the Clipboard, the Paste Options menu in PowerPoint includes all of the following paste options EXCEPT ____.

Accepted Answer

A)  embed the workbook 
B)  paste as a picture 
C)  paste as unformatted text 
D)  convert to Access query 
A)  embed the workbook 
B)  paste as a picture 
C)  paste as unformatted text 
D)  convert to Access query

Question 6

You manage your linked objects using the Links dialog box.

Accepted Answer

A) True 
 B)False

Question 7

MATCHING
-used to break a link

Accepted Answer

A) Paste menu 
B) Mailings tab 
C) Heading 1 style 
D) RTF File 
E) Navigation pane
F)embedding
G)Links dialog box
H)query
I)¶
J)linking 
A) Paste menu 
B) Mailings tab 
C) Heading 1 style 
D) RTF File 
E) Navigation pane
F)embedding
G)Links dialog box
H)query
I)¶
J)linking

Question 8

-The accompanying figure shows a(n) ____.

Accepted Answer

A)  Word main document 
B)  Access query 
C)  embedded table 
D)  recipients list 
A)  Word main document 
B)  Access query 
C)  embedded table 
D)  recipients list

Question 9

The ____ merge field makes it simple to include an inside address in a merged document.

Accepted Answer

A)  Inside Address 
B)  Address Block 
C)  Whole Address 
D)  Street-City-ZIP 
A)  Inside Address 
B)  Address Block 
C)  Whole Address 
D)  Street-City-ZIP

Question 10

MATCHING
-option for exporting an Access query

Accepted Answer

A) Paste menu 
B) Mailings tab 
C) Heading 1 style 
D) RTF File 
E) Navigation pane
F)embedding
G)Links dialog box
H)query
I)¶
J)linking 
A) Paste menu 
B) Mailings tab 
C) Heading 1 style 
D) RTF File 
E) Navigation pane
F)embedding
G)Links dialog box
H)query
I)¶
J)linking

Question 11

You work for a small non-profit. Your boss has given you the task of creating thank-you letters to send to people who have donated to your non-profit organization this past year. She has given you a form letter in Word and a database of donors in Access. You need to merge the two.
-The first thing you should do is to ____.

Accepted Answer

A)  create the data source by importing the Access database into a table 
B)  insert the address block & crosscheck the fields 
C)  use commands to tell Word to make the document a letter 
D)  sort the records into alphabetical order 
A)  create the data source by importing the Access database into a table 
B)  insert the address block & crosscheck the fields 
C)  use commands to tell Word to make the document a letter 
D)  sort the records into alphabetical order

Question 12

The ____ field in a merge picks up the primary key field from an Access table.

Accepted Answer

A)  Keylock 
B)  Primary 
C)  Static ID 
D)  Unique Identifier 
A)  Keylock 
B)  Primary 
C)  Static ID 
D)  Unique Identifier

Question 13

The Greeting Line button can be found in the ____ group of the MAILINGS ribbon tab.

Accepted Answer

A)  Create 
B)  Write & Insert Fields 
C)  Design & Format 
D)  Start Mail Merge 
A)  Create 
B)  Write & Insert Fields 
C)  Design & Format 
D)  Start Mail Merge

Question 14

When you simply click the Paste button to insert an Excel chart into Word, ____.

Accepted Answer

A)  you cannot alter the way it was pasted 
B)  you can only alter the orientation of the pasted object 
C)  you can only alter the way the object was pasted by using Ribbon commands 
D)  you can easily alter the way the object was pasted by using the Paste Options button that appears at the lower-right corner of the object 
A)  you cannot alter the way it was pasted 
B)  you can only alter the orientation of the pasted object 
C)  you can only alter the way the object was pasted by using Ribbon commands 
D)  you can easily alter the way the object was pasted by using the Paste Options button that appears at the lower-right corner of the object

Question 15

MATCHING
-used to extract information from a database

Accepted Answer

A) Paste menu 
B) Mailings tab 
C) Heading 1 style 
D) RTF File 
E) Navigation pane
F)embedding
G)Links dialog box
H)query
I)¶
J)linking 
A) Paste menu 
B) Mailings tab 
C) Heading 1 style 
D) RTF File 
E) Navigation pane
F)embedding
G)Links dialog box
H)query
I)¶
J)linking

Question 16

You work for a small non-profit. Your boss has given you the task of creating thank-you letters to send to people who have donated to your non-profit organization this past year. She has given you a form letter in Word and a database of donors in Access. You need to merge the two.
-You discover that donor social security numbers are the primary key in the Access database. You ____ in order to keep that information from being available to other people reading the document.

Accepted Answer

A)  decide to enter all data manually 
B)  change the Unique Identifier field in the Match Fields dialog box to "(not matched)" 
C)  match the SSN field to "NULL" in the Match Fields dialog box 
D)  do nothing 
A)  decide to enter all data manually 
B)  change the Unique Identifier field in the Match Fields dialog box to "(not matched)" 
C)  match the SSN field to "NULL" in the Match Fields dialog box 
D)  do nothing

Question 17

When you click an embedded object, the ____________________ in the destination program changes to include tabs and commands from the embedded object's source program.

Accepted Answer

The answer of When you click an embedded object, the...

Question 18

A disadvantage to ____________________ is that source and destination files must be stored together.

Accepted Answer

The answer of A disadvantage to ____________________ is that source...

Question 19

-In the accompanying figure, the Chart Tools ribbon tabs are available because the chart is ____________________.

Accepted Answer

selected
a

Question 20

When PowerPoint creates slides from a Word outline, each outline paragraph given the Heading 1 style becomes the title of a new slide.

Accepted Answer

A) True 
 B)False

-Box B in the accompanying figure points to ____.

You can choose how an object will be pasted by using the Paste Options button on the Paste menu.

An advantage of embedding is that the destination file remains fairly small.

When Excel worksheet data is on the Clipboard, the Paste Options menu in PowerPoint includes all of the following paste options EXCEPT ____.

You manage your linked objects using the Links dialog box.

MATCHING -used to break a link

-The accompanying figure shows a(n) ____.

The ____ merge field makes it simple to include an inside address in a merged document.

MATCHING -option for exporting an Access query

The ____ field in a merge picks up the primary key field from an Access table.

The Greeting Line button can be found in the ____ group of the MAILINGS ribbon tab.

When you simply click the Paste button to insert an Excel chart into Word, ____.

MATCHING -used to extract information from a database

When you click an embedded object, the ____________________ in the destination program changes to include tabs and commands from the embedded object's source program.

A disadvantage to ____________________ is that source and destination files must be stored together.

-In the accompanying figure, the Chart Tools ribbon tabs are available because the chart is ____________________.

When PowerPoint creates slides from a Word outline, each outline paragraph given the Heading 1 style becomes the title of a new slide.

Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Essential Computer Concepts

Getting Started With Excel

Formatting Workbook Text and Data

Calculating Data With Formulas and Functions

Analyzing and Charting Financial Data

Exploring the Basics of Windows 8

Internet Basics and Information Literacy

Introduction to Cloud Computing

Managing Your Files

Creating a Presentation

Adding Media and Special Effects

Creating and Editing a Document

Navigating and Formatting a Document

Creating Tables and a Multipage Report

Enhancing Page Layout and Design

Filters

Exam 11: Integrating Word, Excel, Access, and Powerpoint

-Box B in the accompanying figure points to ____.

You can choose how an object will be pasted by using the Paste Options button on the Paste menu.

An advantage of embedding is that the destination file remains fairly small.

When Excel worksheet data is on the Clipboard, the Paste Options menu in PowerPoint includes all of the following paste options EXCEPT ____.

You manage your linked objects using the Links dialog box.

MATCHING -used to break a link

-The accompanying figure shows a(n) ____.

The ____ merge field makes it simple to include an inside address in a merged document.

MATCHING -option for exporting an Access query

The ____ field in a merge picks up the primary key field from an Access table.

The Greeting Line button can be found in the ____ group of the MAILINGS ribbon tab.

When you simply click the Paste button to insert an Excel chart into Word, ____.

MATCHING -used to extract information from a database

When you click an embedded object, the ____________________ in the destination program changes to include tabs and commands from the embedded object's source program.

A disadvantage to ____________________ is that source and destination files must be stored together.

-In the accompanying figure, the Chart Tools ribbon tabs are available because the chart is ____________________.

When PowerPoint creates slides from a Word outline, each outline paragraph given the Heading 1 style becomes the title of a new slide.

Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Essential Computer Concepts

Getting Started With Excel

Formatting Workbook Text and Data

Calculating Data With Formulas and Functions

Analyzing and Charting Financial Data

Exploring the Basics of Windows 8

Internet Basics and Information Literacy

Introduction to Cloud Computing

Managing Your Files

Creating a Presentation

Adding Media and Special Effects

Creating and Editing a Document

Navigating and Formatting a Document

Creating Tables and a Multipage Report

Enhancing Page Layout and Design

Filters