Deck 3: Integrating Word and Excel

Question 1

If a text value in a Word document is automatically updated after a corresponding text value is updated in an Excel source document, you can infer that the text value in Word is ____ the source document.

A) embedded in
B) linked to
C) copied to
D) pasted to

Answer 1

B

Question 2

To link data other than a chart, you use the Select button and the Copy Link command to create a link between the source file and the destination file.

Answer 2

False

Question 3

You cannot insert a Word file into an Excel workbook.

Answer 3

False

Question 4

When you copy and paste an object, changes that you make to the object in the source file appear in the destination file.

Question 5

Microsoft Office programs are designed to work together through a process called ____.

A) validation
B) integration
C) certification
D) authentication

Question 6

When you integrate data from multiple Office programs, you work with both a source file and a destination file.

Question 7

You use the Copy and Paste buttons to create a link between a chart in Excel and the same chart pasted into a document in Word.

Question 8

Microsoft Office provides ____ integration methods.

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

Question 9

To link data other than a chart, you use the Copy button and Update Link command to create a link between the source file and the destination file.

Question 10

When you place multiple items on the Clipboard, newer items appear at the top of the list.

Question 11

You use a(n) embed option from the Paste Special dialog box to create a link between selected data in two files.

Question 12

When you want to copy an object without a data connection to the source file, you should use the ____ integration method.

A) linking
B) inline
C) pasting
D) compacting

Question 13

By default, when you copy an Excel report into Word, it will be formatted with the same theme applied to the source document.

Question 14

The Paste list arrow in the Insert group allows you to see each of the five Paste Options and to view how the pasted object will appear in the document.

Question 15

You can insert a Word object anywhere in an Excel worksheet.

Question 16

When a Word object is embedded in an Excel file, you can use the tools from the source program (Word) to edit it.

Question 17

Instead of re-creating the same information in compatible programs, you can create the information in one program and then reuse it in other programs.

Question 18

You can edit a(n) embedded file by double-clicking it in the destination program to open the source program.

Question 19

You can prepare a report in Word that contains a chart you created in Excel.

Question 20

You can copy ____ and numbers between Word and Excel.

A) ribbons
B) commands
C) words
D) formula bars

Question 22

After you create an object in one program, you can choose to either ____ the object or embed it in another program.

A) recover
B) link
C) redefine
D) capture

Question 23

Office technology allows you to ____, or place an unlinked copy of, the contents of a Word file into an Excel worksheet.

A) augment
B) compress
C) embed
D) convert

Question 24

You use the term linked object to refer to ____ data.

A) connected
B) encrypted
C) binary
D) variable

Question 25

To open the Clipboard task pane in Excel or Word, you can click the ____________________ in the Clipboard group.

Question 26

You use the Copy and ____________________ commands when you want to copy an item from one program to another program.

Question 27

By default, an object copied from one program to another program retains the ____ of the original object.

A) address
B) formatting
C) record
D) link to the source

Question 28

The button named ____ is selected by default when a chart is pasted into the destination document.

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

Question 29

When you are embedding an object in a file, the ____________________ dialog box gives you the option of either creating a new object or inserting an object from a file.

Question 30

You can ____ an entire file that you create in one Office program in a document created in another Office program.

A) collate
B) hide
C) associate
D) embed

Question 31

If you need to remove all items appearing in the Clipboard task pane, click ____.

A) Paste All
B) Clear All
C) Select All
D) Delete

Question 32

In Excel, the Clipboard task pane opens ____ the spreadsheet window.

A) to the left of
B) to the right of
C) above
D) below

Question 33

When you change data in a source file, linked data also changes in the ____________________ file.

Question 34

In the ____ dialog box, you can choose to paste a value from a source file as a link and you can choose how you want the pasted value to appear in the destination file.

A) Paste Special
B) Save As
C) Copy
D) Replace

Question 35

The ____________________ file is the file from which information is copied or used.

Question 37

You can "collect" up to ____ items to the Clipboard and then switch to another program to paste them.

A) 8
B) 12
C) 16
D) 24

Question 38

The formula ____ in Excel will calculate the mean of the values in cells B14 through F14.

A) =SUM(B14:F14)
B) =MEDIAN(B14:F14)
C) =MAX(B14:F14)
D) =AVERAGE(B14:F14)

Question 39

When you are editing an embedded file, you can determine the name of the destination file by examining the ____.

A) status bar
B) title bar
C) Word tabs
D) source document

Question 40

Suppose you have placed the following items to the Clipboard: a photograph, a text value, a column chart, and a table. If the items were copied in the order listed, the ____ would be at the bottom of the list.

A) text value
B) table
C) photograph
D) column chart

Question 41

You can copy a table created in Word into an Access table .

Question 42

You can import data from an Excel spreadsheet into Access.

Question 43

Why would you want to embed a file that you create in one Office Program into a document created in another Office Program?

Question 44

You can modify cell formatting of pasted data in Excel that is linked to the Access source table.

Question 45

You can delete any of the rows in pasted Excel data that are linked to an Access source table.

Question 47

Before exporting data from Excel into Access, you need to remove titles, subtitles, charts, and any other extraneous data.

Question 48

You cannot append Excel data to an existing table in Access.

Question 49

When you add data from one table to an existing table, you need to make sure that the number of records is the same in both tables.

Question 51

Be sure to click the Excel button in the Export & Link group when transferring data from Excel into Access.

Question 52

The Paste Special command does not provide formatting options for pasted objects that are not linked.

Question 53

When and how do you use the Copy and Paste commands to integrate data?

Question 54

You can increase efficiency by integrating the information you create in Word, Excel, and Access.

Question 55

Provide an example of why you might want to link data included in two or more files.

Question 56

What is the difference between linking and embedding an object?

Question 57

Explain how you link data other than a chart.

Question 58

You work as a location scout for a video production company in New York City. You have to find interesting locations for a corporate production shoot. You use the Internet and Internet Explorer to gather the information that your team needs to complete its work. When you start the browser, you want it to open up to an interactive map of New York. What Web sites could you go to in order to find more information that your team might need?

Question 59

You cannot import data into an Access database table from a text file.

Question 60

After importing Excel data into Access without links, any changes you make to the Excel source data will be reflected in the Access table.

Question 61

You can import data into Access from ____.

A) another Access database
B) a JPG file
C) a GIF file
D) a BMP file

Question 62

In Word, you can click the ____ button to select the contents of an entire table.

A) Tables and Borders
B) Insert Table
C) Insert Hyperlink
D) table select

Question 63

By integrating information created in Word, Excel, and Access, the information ____.

A) persists indefinitely
B) is guaranteed to be secure
C) is guaranteed to be accurate
D) works together

Question 64

After pasting data into Excel that is linked to an Access source table, you can ____.

A) delete rows
B) modify cell formatting
C) delete columns
D) modify the Access source table from Excel

Question 65

If you are adding ten Excel records to an existing Access table, you should ensure that the Access table has ____.

A) at least one record
B) the same number of records
C) more than ten records
D) less than ten records

Question 66

You can minimize typing time by ____ Excel data directly into a table in an Access database.

A) importing
B) exporting
C) compressing
D) encrypting

Question 67

A workbook that you plan to export from Excel into Access should only contain the ____ that you want to appear in the Access table.

A) titles
B) data
C) subtitles
D) charts

Question 68

If you need to create sales charts, order new products, complete purchase orders, and produce proposals to obtain new contracts, you can use ____ techniques in the Office suite to accomplish your tasks.

A) validation
B) authentication
C) certification
D) integration

Question 69

After exporting Excel data into Access, the column headings in the Excel spreadsheet become ____ in the Access table.

A) data cells
B) row ids
C) record pointers
D) field names

Question 70

You can choose to import Excel data directly into a new table or you can ____ the data to an existing table.

A) extract
B) overwrite
C) append
D) join

Question 71

You link an Access table to Excel and then to Word when you want the data in all three applications to always remain ____.

A) current
B) static
C) secure
D) encrypted

Question 72

You can enter data into an Access ____.

A) workbook
B) database
C) spreadsheet
D) attachment

Question 73

You use the ____ command in Access to import data from an outside source.

A) New
B) Open
C) Get External Data
D) Export

Question 74

Excel contains ____ tools not available in Access.

A) data storage
B) copy
C) calculation
D) pasting

Question 75

During the process of importing data from Excel into Access, you can change the field names and even ____ of selected fields.

A) values
B) locations
C) source code
D) data types

Question 76

In Microsoft Office 2010, the program that is used for calculations with data is ____.

A) Word
B) Excel
C) Access
D) PowerPoint

Question 77

You can modify calculations based on the pasted data in Excel that is linked to an Access source table.

Question 78

If you want to select from a variety of formatting options when pasting an object into Word, you should use the Paste Format command.

Question 79

You cannot copy an Access table and paste it directly into Word as a link.

Question 80

When pasting into a Word file from Access, ____ show where you will paste the table(s).

A) variables
B) locators
C) placeholders
D) buttons