Deck 12: Integration 3: Integrating Word Excel Access and Powerpoint

Question 1

You should link an object to a PowerPoint slide when you always want your object to include the latest information.

Answer 1

True

Question 2

A block of text that is not formatted with a heading style in Word is not included when it is imported into a PowerPoint presentation.

Answer 2

True

Question 3

You should embed an object when you are able to open the source file. ____________________​

Answer 3

False

Question 4

To sort data in an Access table, you can use a query . ____________________​

Question 5

You embed an object in a PowerPoint slide when you want to access the object in its source program, even if the source file is not available. _________________________

Question 6

You can copy an Access table from Access to PowerPoint.

Question 7

Links are still maintained when you move files among machines or transmit files to other people.​

Question 8

An embedded object becomes a part of the PowerPoint file, which means that the file size of the PowerPoint presentation decreases . _________________________

Question 9

When you link an object to a PowerPoint slide, a picture of the object is placed on the slide instead of the actual object.​

Question 10

To view all slides in a P​owerPoint presentation, use Slide Sorter view.

Question 11

After updating an Access table, linked values in Excel will update automatically if you wait a few minutes.

Question 12

You can paste an Access table as a link in PowerPoint.

Question 13

When you insert a Word outline into a PowerPoint presentation, the connection between the two files is maintained.​

Question 14

When you embed an object, you create a link to the source file.

Question 15

When you double-click an embedded object, you can use the tools of the destination program to edit the object. _________________________

Question 16

You should link an object to a PowerPoint slide when you are the only user of an object, and you want the object to be a part of your presentation.

Question 17

You can integrate information into a PowerPoint presentation using the linking and embedding techniques you learned with Word, Excel, and Access.

Question 18

You frequently need to manage the links you create between files and programs.

Question 19

You can export a Word outline into PowerPoint to automatically create slides without having to reenter information. _________________________

Question 20

You cannot move or resize an object that has been copied from Excel and pasted into PowerPoint as a link.

Question 21

PowerPoint imports all text formatted with the Heading 1 style as a(n) ____.

A) slide title
B) bulleted list
C) numbered list
D) outline number list

Question 22

To change the theme of a PowerPoint presentation, click the _____ tab.​

A) ​Insert
B) ​File
C) ​Home
D) ​Design

Question 23

When you import slides into PowerPoint, you need to reset the ____ of the slides to conform to the PowerPoint slide design you have applied.

A) accent
B) layout
C) motif
D) margin

Question 24

Which of the following indicates the number of slides contained in a presentation?

A) Status pane
B) menu bar
C) status bar
D) Quick Access Toolbar

Question 25

If your presentation requires an object and you want to keep your presentation file size small, you should ____ the object's source file.

A) encrypt
B) decrypt
C) link
D) embed

Question 26

The formula =ADD(F7:F9) will find the total of the values in cells F7, F8, and F9.

Question 27

To embed an object in a PowerPoint presentation, use the Object command in the _____ group on the Insert tab.​

A) ​Type
B) ​Link
C) ​Text
D) ​Layout

Question 28

To edit an embedded object, you ____ it.

A) single-click
B) double-click
C) control-click
D) highlight

Question 29

When you click the Demote button once while Body text is selected, the text moves to the right ____ tab stop(s) and changes from subtitle text to a Level 2 heading.

A) one
B) two
C) three
D) four

Question 30

When you ____ an object to a PowerPoint slide, the object is still stored in the source file in the source program.

A) embed
B) define
C) join
D) link

Question 31

You use linking when you want the linked information in the destination file to update when you change the ____ file.

A) source
B) destination
C) binary
D) text

Question 32

You normally break a link when you need to send a file to another user. _________________________

Question 33

You can use source program tools to edit a(n) ____ object within a destination file.

A) dynamic
B) embedded
C) static
D) de-referenced

Question 34

You can use [ ____ ][Tab] to promote headings in Outline view.

A) Alt
B) Shift
C) Ctrl
D) Fn

Question 35

To embed an object in a PowerPoint presentation, you use the ____ command in the Text group on the INSERT tab.

A) Picture
B) Table
C) Chart
D) Object

Question 36

The default theme in PowerPoint is the ____ theme.

A) Main
B) Calibri
C) Standard
D) Office

Question 37

You can use ____ to promote headings in Outline View.

A) [Tab]
B) [Shift][Tab]
C) [Alt][Tab]
D) [Ctrl][Tab]

Question 38

A(n) ____ object in a PowerPoint file becomes a part of the PowerPoint file.

A) persistent
B) dynamic
C) embedded
D) immutable

Question 39

To copy an Access query to an Excel file, click the query in the _____ and then click the Copy button.

A) ​taskbar
B) ​Navigation Pane
C) ​status bar
D) ​Backstage view

Question 40

All text formatted with the ____ style is imported into PowerPoint as a Level 1 item in a bulleted list.

A) Heading 1
B) Heading 2
C) Heading A
D) Heading B

Question 41

The proper formula in Excel for calculating the percentage change between cells D3 and D2 is ____.

A) (D3 + D2)/D3
B) =(D3 + D2)/D3
C) (D3-D2)/D3
D) =(D3-D2)/D3

Question 42

PowerPoint imports all text formatted with the Heading 2 style as a level 1 item in a(n) ____________________ list.

Question 43

To change the theme of a worksheet, click the _____ tab. ​

A) ​Design
B) ​Page Layout
C) ​Insert
D) ​View

Question 44

You can use the ____ command to embed Excel objects such as worksheets and charts into both Word and PowerPoint documents.

A) Object
B) Worksheet
C) Table
D) Diagram

Question 45

A value that you copy from Excel and paste into PowerPoint as a link is formatted as a(n) ____.

A) placeholder
B) heading
C) slide
D) object

Question 46

The proper formula in Excel for multiplying the value in cell B2 with the value in cell C2 is ____.

A) =B2xC2
B) =B2%C2
C) =B2*C2
D) B2*C2

Question 47

When you insert an Excel chart into a PowerPoint presentation, you usually need to select a new chart ____________________ so the data is easy to read on a slide.

Question 48

When you copy a chart from Excel to PowerPoint, the chart takes on the theme of the ____________________ file.​

Question 49

You ____________________ an object to a PowerPoint slide when the object's source file is shared on a network or where other users have access to the file and can change it.

Question 50

If a linked value did not update after making a change in a source file, click the File tab, click Edit Links to Files in the lower-right corner of the dialog box, and then click ____.

A) Revise Now
B) Modify Values
C) Update Values
D) Format Now

Question 51

To format a cell as percent (%), click the Percent Style button in the ____________________ group.​

Question 52

You open the Edit Links dialog box from the _____ tab.​

A) ​Home
B) ​Data
C) ​File
D) ​View

Question 53

When you embed a worksheet object in a PowerPoint slide, you generally want to show only the ____ that contain data.

A) cells
B) indices
C) foci
D) tabs

Question 54

If Excel data is ____ an Access table, it will be updated when you update the Access table.

A) embedded from
B) subordinate to
C) linked to
D) independent of

Question 55

To widen columns in Excel, ____________________​ the column divider.

Question 56

Before you import a Word outline to PowerPoint, you need to make sure all the headings and subheadings are ____________________ with heading styles.​

Question 57

If you want an Access table to be sorted in alphabetical order by a particular field, you need to create a(n) ____________________ containing the sorted data.

Question 58

You embed data created in other programs in PowerPoint when you want to be able to edit it from within the ____________________ file.

Question 59

To move to the top of an embedded Excel worksheet, enter [Ctrl] [ ____ ].

A) Insert
B) Home
C) Tab
D) Alt

Question 60

You can speed up the update of values in Excel linked to an Access table by updating the values manually in the ____ dialog box.

A) Edit Links
B) Insert Object
C) Paste Special
D) Import Data

Question 61

Critical Thinking Questions Case 1-1 Your manager has just asked you to create a PowerPoint slide presentation to be delivered at your company's next sales meeting. She expects you to construct the presentation slide by slide based on data in a Word document. You want your PowerPoint presentation to include the latest information from the Word document, because you anticipate that your teammates may still be updating the source document. Which of the following integration strategies should you use?
A. embedding
B. linking
C. copying and pasting
D. replacement

Question 62

Why would you want to import a Word outline into PowerPoint?

Question 63

Critical Thinking Questions Case 1-1 Your manager has just asked you to create a PowerPoint slide presentation to be delivered at your company's next sales meeting. She expects you to construct the presentation slide by slide based on data in a Word document. You know that you could retype the information from the Word document. However, what is an easier way to get the information from Word into PowerPoint?
A. importing
B. baselining
C. indexing
D. outlining

Question 64

Describe the rules for pasting an Access table into PowerPoint.

Question 67

Explain the purpose of the Object command.

Question 68

Explain how you can integrate objects that you create in Word, Excel, and Access into PowerPoint presentations.

Question 69

Critical Thinking Questions Case 1-1 Your manager has just asked you to create a PowerPoint slide presentation to be delivered at your company's next sales meeting. She expects you to construct the presentation slide by slide based on data in a Word document. You have 11 Level 1 headings in the Word outline. How many slides will this generate in PowerPoint?
A. 9
B. 10
C. 11
D. It is impossible to say until the import is complete.

Question 70

Critical Thinking Questions Case 1-1 Your manager has just asked you to create a PowerPoint slide presentation to be delivered at your company's next sales meeting. She expects you to construct the presentation slide by slide based on data in a Word document. After some time goes by, you realize that your team will no longer be updating the Word document, but now your concern is continuing to have access to the information in the original Word application. Which of the following integration strategies should you use?
A. replacement
B. linking
C. copying and pasting
D. embedding

Question 71

After an Excel worksheet is embedded in a PowerPoint slide, how is the worksheet identified and displayed?

Question 74

Critical Thinking Questions Case 1-1 Your manager has just asked you to create a PowerPoint slide presentation to be delivered at your company's next sales meeting. She expects you to construct the presentation slide by slide based on data in a Word document. You are ready to send the completed PowerPoint presentation to your manager and all along you knew it was important to keep the size of the presentation small. Which of the following are you most likely to use to accomplish this?
A. linking
B. embedding
C. filtering
D. copying and pasting