Question 1

Access is not included with all versions of Microsoft Office.

Accepted Answer

A) True 
 B)False

Question 2

____ fields contain instructions for replacing these field placeholders with the variable information from a data source.

Accepted Answer

A)  Embedded 
B)  Merge 
C)  Query 
D)  Tapped

Question 3

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 decide to use a Greeting Line merge field. Why?

Accepted Answer

A)  It is the only way to add an individual greeting to the document. 
B)  It provides a greeting when the first or last name happens to be missing from the data source. 
C)  It will import the entire name and address as one block, rather than multiple individual fields. 
D)  It randomizes the greeting for each card in order to feel more personal.

Question 4

Describe the general steps for embedding an Excel chart into a Word document.

Accepted Answer

The answer of Describe the general steps for embedding an...

Question 5

To update a linked table in Excel, the first steps are to right-click the table in the document, point to ____________________ on the shortcut menu, then click Edit Link.

Accepted Answer

The answer of To update a linked table in Excel,...

Question 6

When viewing an Access query, if you click "View" in the Views group of the HOME tab, your query will display in ____ view.

Accepted Answer

A)  Code 
B)  Table 
C)  Design 
D)  Query

Question 7

One paste option when pasting an Excel chart into Word is Use Destination ____________________ & Embed Workbook.

Accepted Answer

The answer of One paste option when pasting an Excel...

Question 8

To break a link, you use the Links command on the ____.

Accepted Answer

A)  Manage Data menu in the source file 
B)  Link & Embed menu in the destination file 
C)  Edit menu in the destination file 
D)  Link & Embed menu in the source file

Question 9

Juliet runs a popular antiques store. She uses Office 2013 to help her manager her business, especially Word and Excel.
-Juliet has created a Word file for end-of-the-year sales figures. She wants to include charts from her Excel spreadsheets. She then wants to archive the Excel spreadsheets and remove them from her computer so she doesn't risk confusing them with the current ones for the current year. She should ____.

Accepted Answer

A)  link the charts to her Word file so they're always available 
B)  embed the charts into her Word file so that they will be unchanged when the source file is archived and removed 
C)  paste the charts as static RTF files 
D)  paste the charts as Editable JPEG files

Question 10

A disadvantage of linking is that ____.

Accepted Answer

A)  the source file and destination file must be stored separately 
B)  the source file and destination file must be stored together 
C)  the destination file size increases to reflect the addition of the object from the source file 
D)  the destination file size remains fairly small

Question 11

The location of a source file is known as its ____.

Accepted Answer

A)  file path 
B)  URL 
C)  domain 
D)  root

Question 12

MATCHING
-nonprinting character

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

Question 13

When pasting an Excel chart into a Word document, using the ____ button makes the formatting the same as the Word document's and keeps the source file separate.

Accepted Answer

A)  Keep Source Formatting & Embed Workbook 
B)  Use Destination Theme & Embed Workbook 
C)  Link & Use Destination Styles 
D)  Link & Keep Source Formatting

Question 14

To insert a Word outline into PowerPoint, you click the New Slide button arrow, then click ____________________.

Accepted Answer

The answer of To insert a Word outline into PowerPoint,...

Question 15

-The accompanying figure shows an Excel chart within a Word document.

Accepted Answer

A) True 
 B)False

Question 16

You use a(n) ____ in Access to extract information from a database.

Accepted Answer

A)  randomizer 
B)  query 
C)  equation 
D)  formula

Question 17

-Paragraphs formatted like Box D in the accompanying figure will become ____ when imported into PowerPoint.

Accepted Answer

A)  first-level bulleted items 
B)  second-level bulleted items 
C)  slide titles 
D)  slide headers or footers

Question 18

To change the default paste option, click ____ on the Paste menu.

Accepted Answer

A)  Set Default Paste 
B)  Revert to Default 
C)  Advanced 
D)  Paste Options

Question 19

Describe the similarities and differences between the Paste Options button and the Paste Special command.

Accepted Answer

The answer of Describe the similarities and differences between the...

Question 20

You can modify an embedded chart's appearance using commands on the ____________________ contextual tabs that appear on the ribbon.

Accepted Answer

The answer of You can modify an embedded chart's appearance...

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