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

Question 1

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

Answer 1

False

Question 2

If you're in Word and want to link a chart, and you're happy with the way the chart is currently formatted, then you would choose the Link & Keep Source Formatting button in the Paste Options menu.

Answer 2

True

Question 3

To import a Word outline into a PowerPoint presentation, use the Word Import command on the New Slide button menu.

Answer 3

False
Slides from Outline

Question 4

If an Excel chart is linked into Word, changes in the chart in Excel will not affect the Word file.

Question 5

A link between two files can be broken.

Question 6

Access is not included with all versions of Microsoft Office.

Question 7

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

Question 8

You use the Merge Connections dialog box to select the people who will receive a merged letter.

Question 9

When you click an Excel chart that is embedded in Word, the Excel EMBED contextual tabs appear on the Word ribbon.

Question 10

In a mail merge, form letters, mailing labels, and envelopes are all different types of main documents.

Question 11

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

Question 12

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

Question 13

You may import both Access tables and Access queries into Word.

Question 14

You manage your linked objects using the Links dialog box.

Question 15

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

Question 16

When attempting to paste an Excel object into Word as a linked object, your options are "Link & Keep Source Formatting" or "Link & Use Destination Styles."

Question 17

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

Question 18

Linking and embedding are two different terms for the same type of integration.

Question 19

If Word doesn't automatically find and the correct fields when creating a mail merge, you can use the Match Fields dialog box to assign fields manually.

Question 20

You can export an Access query using either the Export - Excel Spreadsheet or Export - Word File dialog boxes.

Question 21

The choices on the Paste Options button that appears next to a pasted object are ____ the choices seen when clicking the Paste button arrow.

A) usually, but not always, different from
B) more varied than
C) compressed versions of
D) the same as

Question 22

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.

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

Question 23

If an Excel table is likely to change, and you want to make sure that its information is updated in any files in which it is used, it is best to ____.

A) embed the table
B) link the table
C) paste the table as a picture
D) manual re-paste the table each time it is updated

Question 24

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

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 25

When you click an embedded object, the ____ changes to include tabs and commands from the embedded object's source 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 26

Use embedding if you want ____.

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 27

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

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

Question 28

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

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

Question 29

The ______ contextual tabs appears on the Word ribbon when an embedded Excel chart is selected.

A) CHART TOOLS
B) HOME
C) OLE
D) PAGE LAYOUT

Question 30

When you paste an object into an Office document, you can choose how that object will be pasted before you paste it by using the ____.

A) Paste Preview button
B) Object button arrow
C) Paste buton arrow
D) Live Options button

Question 31

If you have clicked the Paste button to insert an object, you can still change the way an object is pasted by clicking the ____ button that appears just below and to the right of the pasted object.

A) Revert
B) Paste Preview
C) Paste Options
D) Special Tools

Question 32

If you plan to send a file with a linked object to someone who will not have access to the linked object's source file, you should ____.

A) bundle the files as a PDF
B) break the link
C) hard-paste the link
D) not try to send the file, as an error will result

Question 33

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

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

Question 34

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

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 35

A disadvantage of linking is that ____.

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 36

If your document does not show nonprinting characters, click the Show/Hide button in the Paragraph group on the ____ tab.

A) TABLE TOOLS
B) FILE
C) DESIGN
D) HOME

Question 37

An advantage of embedding is that ____.

A) the source file and destination file may be stored separately
B) the source file and destination file are automatically 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 38

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 ____.

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 39

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

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

Question 40

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

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

Question 41

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

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

Question 42

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

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

Question 43

The accompanying figure shows a(n) ____.

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

Question 44

In Access, you find the Queries group on the ____ tab of the Ribbon.

A) FILE
B) QUERY
C) CREATE
D) SEARCH

Question 45

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

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

Question 46

The Insert Merge Field button is found in the ____ group on the MAILINGS ribbon tab.

A) Write & Insert Fields
B) Start Mail Merge
C) Create
D) Embed & Link Fields

Question 47

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

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

Question 48

A mail merge data source can be any of the following EXCEPT ____.

A) an Access query
B) an Excel table
C) a PowerPoint graph
D) an Access table

Question 49

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

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

Question 50

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

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

Question 51

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

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

Question 52

You run a query in Access by clicking the Run button on the ____ tab.

A) QUERY EXECUTE
B) QUERY TOOLS DESIGN
C) DRAWING TOOLS FORMAT
D) INTERACT

Question 53

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

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 54

Box B in the accompanying figure points to ____.

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

Question 55

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

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

Question 56

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

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

Question 57

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

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

Question 58

You can export an Access query to ____.

A) an Excel worksheet only
B) a Word document only
C) either a Word document or an Excel worksheet
D) nothing; you can only export Access tables

Question 59

When the file shown in the accompanying figure is imported into PowerPoint, ____.

A) the outline shown in the navigation pane will also import as a separate slide
B) the text will be formatted with the open PowerPoint presentation's format
C) the text will be formatted as per the original Word document
D) duplicate text/slides will be deleted

Question 60

When importing an outline into PowerPoint, second-level bulleted items are created from paragraphs formatted with the ____ style.

A) Heading 1
B) Heading 2
C) Heading 3
D) Body Text

Question 61

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 ____.

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 62

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.

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

Question 63

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 ____.

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 64

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

Question 65

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

Question 66

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

Question 67

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?

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 68

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 ____.

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

Question 69

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.
Within the Word document, you have now successfully selected the Access database as the data source. The next step is to ____.

A) rename the database
B) perform the merge
C) insert the merge fields
D) insert the greeting line

Question 70

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

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

Question 71

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

Question 72

Juliet runs a popular antiques store. She uses Office 2013 to help her manager her business, especially Word and Excel.
Lastly, Juliet wants to include both a linked Excel chart and an embedded Excel table into a Word file. From her experience, she knows by now that ____.

A) it is not possible to include both a linked and an embedded file
B) the linked file will increase the file size of her Word file significantly
C) there is the possibility of data corruption from trying to include two Excel objects into one Word file
D) she can easily do this

Question 73

Juliet runs a popular antiques store. She uses Office 2013 to help her manager her business, especially Word and Excel.
Juliet maintains an Excel file on sales figures for her antiques store that is updated every month. She likes to create charts from the figures and paste them into Word. It's important that the Word files always have the latest information. What is the simplest way for Juliet to ensure this?

A) Link the chart
B) Embed the chart
C) Paste the chart as a picture
D) not enough information to say

Question 74

Juliet runs a popular antiques store. She uses Office 2013 to help her manager her business, especially Word and Excel.
Juliet wants to e-mail a Word file with a linked Excel chart to her friend Miguel. She knows that Miguel has Word, but does not have Excel. What should Juliet do?

A) Nothing; the Excel chart along with all of the software needed to open it will be there in the Word file for Miguel to see
B) Send Miguel the name of the file path that she uses for the Excel chart so he can use it too
C) Break the link so Miguel can see the file without getting an error
D) Consider re-pasting the chart as a picture, because Miguel will not be able to see it otherwise since he doesn't have Excel

Question 75

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

Question 76

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

Question 77

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.

Question 78

If you click the Paste button arrow, a menu appears; you can point to the buttons on that menu to see a(n) ____________________ of the pasted object.

Question 79

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

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

Question 80

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.

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