Question 1

To perform a mail merge, you work with commands in the MAILINGS ribbon tab.

Accepted Answer

A) True 
 B)False

Question 2

The ____ dialog box offers additional choices for moving data on the Clipboard to the destination file.

Accepted Answer

A)  Paste How 
B)  Clipboard Options 
C)  Embedding & Linking 
D)  Paste Special 
A)  Paste How 
B)  Clipboard Options 
C)  Embedding & Linking 
D)  Paste Special

Question 3

A link between two files can be broken.

Accepted Answer

A) True 
 B)False

Question 4

-Clicking ____ in the accompanying figure will open a gallery displaying chart styles.

Accepted Answer

A)  A 
B)  B 
C)  anywhere in the chart 
D)  C 
A)  A 
B)  B 
C)  anywhere in the chart 
D)  C

Question 5

MATCHING
-location of the Insert Merge Field button

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 6

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

Accepted Answer

A)  ribbon in the destination program 
B)  ribbon in the source program 
C)  Paste Options menu in the source program 
D)  Paste Options menu in the destination program 
A)  ribbon in the destination program 
B)  ribbon in the source program 
C)  Paste Options menu in the source program 
D)  Paste Options menu in the destination program

Question 7

The first step in exporting the results of an Access query to Word is ____.

Accepted Answer

A)  to click the query to be exported in the Navigation Pane 
B)  to click the EXTERNAL DATA tab on the ribbon 
C)  enter the name of the Word file in the File Name box 
D)  click the Browse button in the Export -- RTF File dialog box 
A)  to click the query to be exported in the Navigation Pane 
B)  to click the EXTERNAL DATA tab on the ribbon 
C)  enter the name of the Word file in the File Name box 
D)  click the Browse button in the Export -- RTF File dialog box

Question 8

When evaluating a final document for style & formatting, use ____________________ or Multiple Pages view.

Accepted Answer

The answer of When evaluating a final document for style...

Question 9

-Paragraphs formatted like Box C 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 
A)  first-level bulleted items 
B)  second-level bulleted items 
C)  slide titles 
D)  slide headers or footers

Question 10

Juliet runs a popular antiques store. She uses Office 2013 to help her manager her business, especially Word and Excel.
-Juliet wants to place an Excel chart into Word. Her best option would be to ____.

Accepted Answer

A)  link it 
B)  embed it 
C)  insert it as a picture 
D)  not enough information to say 
A)  link it 
B)  embed it 
C)  insert it as a picture 
D)  not enough information to say

Question 11

If you have changed the location of the source file for a linked object, you need to identify the new location by navigating to the Links dialog box, clicking the ____________________ button, and then navigating to the new location of the source file.

Accepted Answer

The answer of If you have changed the location of...

Question 12

-The accompanying figure shows a PowerPoint outline, which will be used to create a Word document.

Accepted Answer

A) True 
 B)False

Question 13

-In the accompanying figure, the symbol denoted by box A is ____.

Accepted Answer

A)  a nonprinting character 
B)  a merge field 
C)  an embedded icon 
D)  a section break 
A)  a nonprinting character 
B)  a merge field 
C)  an embedded icon 
D)  a section break

Question 14

The first step in completing a mail merge is to ____.

Accepted Answer

A)  select recipients 
B)  identify merge fields 
C)  optimize the link 
D)  open the document to be used as the main document 
A)  select recipients 
B)  identify merge fields 
C)  optimize the link 
D)  open the document to be used as the main document

Question 15

When linking an Excel chart into a Word document, using the ____ button makes the formatting the same as the Word document.

Accepted Answer

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

Question 16

When you paste Access data into a PowerPoint presentation, PowerPoint adds ____ between each column.

Accepted Answer

A)  a space 
B)  a Tab character 
C)  nothing 
D)  a hard return 
A)  a space 
B)  a Tab character 
C)  nothing 
D)  a hard return

Question 17

If you ____________________ an Excel chart into Word, and then modify the chart in Word, the source file remains unmodified.

Accepted Answer

The answer of If you ____________________ an Excel chart into...

Question 18

Use embedding if you want ____.

Accepted Answer

A)  to edit the object without affecting the source file 
B)  to store the object in the source file 
C)  the destination file size to remain fairly small 
D)  to have changes to the source file appear in the destination file 
A)  to edit the object without affecting the source file 
B)  to store the object in the source file 
C)  the destination file size to remain fairly small 
D)  to have changes to the source file appear in the destination file

Question 19

If you have a source document and a destination document open, and you change information in a linked source document, a quick way to see the changes in the destination document is to ____.

Accepted Answer

A)  right-click the taskbar and click Update Links 
B)  click the changed object in the source file and then select Refresh from the Options button that appears 
C)  triple-click the object in the source file 
D)  right-click the object in the destination file and then click Update Link 
A)  right-click the taskbar and click Update Links 
B)  click the changed object in the source file and then select Refresh from the Options button that appears 
C)  triple-click the object in the source file 
D)  right-click the object in the destination file and then click Update Link

Question 20

Describe why the location of a linked object's source file may need to change, and how to identify the new location.

Accepted Answer

If you send a file containing a linked o

To perform a mail merge, you work with commands in the MAILINGS ribbon tab.

The ____ dialog box offers additional choices for moving data on the Clipboard to the destination file.

A link between two files can be broken.

-Clicking ____ in the accompanying figure will open a gallery displaying chart styles.

MATCHING -location of the Insert Merge Field button

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

The first step in exporting the results of an Access query to Word is ____.

When evaluating a final document for style & formatting, use ____________________ or Multiple Pages view.

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

Juliet runs a popular antiques store. She uses Office 2013 to help her manager her business, especially Word and Excel. -Juliet wants to place an Excel chart into Word. Her best option would be to ____.

If you have changed the location of the source file for a linked object, you need to identify the new location by navigating to the Links dialog box, clicking the ____________________ button, and then navigating to the new location of the source file.

-The accompanying figure shows a PowerPoint outline, which will be used to create a Word document.

-In the accompanying figure, the symbol denoted by box A is ____.

The first step in completing a mail merge is to ____.

When linking an Excel chart into a Word document, using the ____ button makes the formatting the same as the Word document.

When you paste Access data into a PowerPoint presentation, PowerPoint adds ____ between each column.

If you ____________________ an Excel chart into Word, and then modify the chart in Word, the source file remains unmodified.

Use embedding if you want ____.

If you have a source document and a destination document open, and you change information in a linked source document, a quick way to see the changes in the destination document is to ____.

Describe why the location of a linked object's source file may need to change, and how to identify the new location.

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

To perform a mail merge, you work with commands in the MAILINGS ribbon tab.

The ____ dialog box offers additional choices for moving data on the Clipboard to the destination file.

A link between two files can be broken.

-Clicking ____ in the accompanying figure will open a gallery displaying chart styles.

MATCHING -location of the Insert Merge Field button

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

The first step in exporting the results of an Access query to Word is ____.

When evaluating a final document for style & formatting, use ____________________ or Multiple Pages view.

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

Juliet runs a popular antiques store. She uses Office 2013 to help her manager her business, especially Word and Excel. -Juliet wants to place an Excel chart into Word. Her best option would be to ____.

If you have changed the location of the source file for a linked object, you need to identify the new location by navigating to the Links dialog box, clicking the ____________________ button, and then navigating to the new location of the source file.

-The accompanying figure shows a PowerPoint outline, which will be used to create a Word document.

-In the accompanying figure, the symbol denoted by box A is ____.

The first step in completing a mail merge is to ____.

When linking an Excel chart into a Word document, using the ____ button makes the formatting the same as the Word document.

When you paste Access data into a PowerPoint presentation, PowerPoint adds ____ between each column.

If you ____________________ an Excel chart into Word, and then modify the chart in Word, the source file remains unmodified.

Use embedding if you want ____.

If you have a source document and a destination document open, and you change information in a linked source document, a quick way to see the changes in the destination document is to ____.

Describe why the location of a linked object's source file may need to change, and how to identify the new location.

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