Deck 6: Illustrating Documents With Graphics Managing Workbook Dataimproving Queriesenhancing Chartsintegrating Word, Excel, Access, and Powerpoint

Question 1

To add a shape effect to an object, click the Drawing Tools  Format  tab, and then click the Special Effects button in the Shape Styles group.​

Answer 1

False

Question 2

You can choose to paste a Word object with or without linking it to the source document.​

Answer 2

True

Question 3

To paste a datasheet query into PowerPoint, use the Paste list arrow​

Answer 3

True

Question 4

You cannot embed a PowerPoint slide in a Word document.​

Question 5

When you copy an Access table into PowerPoint, a link is established between the two programs.

Question 6

To select multiple objects, press and hold the [Shift] key.​

Question 7

You can copy a query datasheet but not an Access table into PowerPoint.

Question 8

You cannot create a direct ____ between Access and PowerPoint when an Access table has been copied into a PowerPoint slide.

A) link
B) database
C) file
D) response

Question 9

In PowerPoint, you click the ____ on the slide before pasting an object.

A) graphic frame
B) content placeholder
C) object placeholder
D) picture frame

Question 10

To change the format of a query datasheet in PowerPoint, you can click the Table Tools ____ tab, click the More button in the Table Styles group, and then select the desired design.

A) Design
B) Layout
C) Style
D) Themes

Question 11

To add a shape fill to an object, click the Drawing Tools  Format  tab, and then click the Shape Fill list arrow in the Shape Styles group.​

Question 12

You can embed a PowerPoint slide in a Word document and then, because it is embedded, use PowerPoint tools within Word to add text to the slide and apply formatting.

Question 13

If you link an Excel file into a PowerPoint presentation, changes you make to the file in Excel appear in PowerPoint and in the original Excel file.

Question 14

Access does not use Microsoft Office themes.

Question 15

You can use PowerPoint or Word to create handouts of PowerPoint slides.

Question 16

When you delete slide content from the Word document, that slide is not deleted from the ProwerPoint presentation.​

Question 17

When you open  Access, you must always enable the content.

Question 18

In Excel, the AutoSum button appears in the Editing group on the Home tab.​

Question 19

When you link an Excel file into PowerPoint, you can edit it by double-clicking the file in PowerPoint.​

Question 20

In Access, the Copy button appears in the ____ group.

A) Home
B) Editing
C) Database Tools
D) Clipboard

Question 21

In PowerPoint, the Object button appears in the Text group of the ____ tab.

A) Home
B) Insert
C) Design
D) Add-ins

Question 22

Which of the following tabs do you click to format an Access table in PowerPoint?

A) Table Tools Design
B) Table Tools Format
C) Access Table Design
D) Format Tools

Question 23

You can insert a linked Excel file into a PowerPoint presentation using the ____ command.

A) Link
B) Object
C) Place
D) Load

Question 24

To edit the content of an Excel file that has been linked to a PowerPoint presentation, you ____ it to open it in Excel, the source program.

A) right-click
B) double-click
C) Shift+Click
D) Ctrl+Click

Question 25

The Links dialog box includes ____.

A) PowerPoint slides
B) PowerPoint notes
C) Excel files
D) Excel charts

Question 26

In Excel, the AutoSum button appears in the _____ group on the Home tab.​

A)Data
B)Editing
C)Formula
D)Cells

Question 27

You can apply the Bevel option to text by clicking the ____ button in the Shape Styles group.

A) Bevel & Emboss
B) Shape Effects
C) Shape Forms
D) Shape

Question 28

When you paste text from Word into PowerPoint, you can choose to ____ it or not.

A) hide
B) comment on
C) lock
D) link

Question 29

To apply a quick style, click the Quick Styles button in the _____ group.​

A)Drawing
B)Styles
C)Format
D)Design

Question 30

​To show table gridlines, click the Tables Tools _____ tab, then click the View Gridlines button in the Table group.

A)Layout
B)Format
C)Design
D)Arrange

Question 31

If you copy text from Word and paste it into PowerPoint, the pasted text becomes a ____ that you can then format and position using PowerPoint tools.

A) text placeholder
B) text box
C) vector graphic
D) bitmap graphic

Question 32

The Paste list arrow displays _____ available paste options.​

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

Question 33

To add a shape fill to an object, click the Drawing Tools _____ tab, and then click the Shape Fill list arrow in the Shape Styles group.​

A)Format
B) Arrange​
C)Design
D)Style

Question 34

To access the Links dialog box, click Edit Links to Files on the ____ tab.

A) Links
B) Data
C) Edit
D) File

Question 35

In the Links dialog box in Word, the source files are from ____.

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

Question 36

In PowerPoint, the Themes group is on the ____ tab.

A) Table Tools Design
B) Page Layout
C) Themes
D) Design

Question 37

When you link an Excel file into PowerPoint, Excel is the ____ program.

A) embedded
B) primary
C) source
D) destination

Question 38

You can create ____ of PowerPoint slides in Word.

A) handouts
B) titles
C) copies
D) footnotes

Question 39

To create PowerPoint handouts in Word, click the File tab, click _____, and then click Create Handouts.​

A)Export
B)Save Handouts
C)Save As
D)Export Handouts

Question 40

The Links dialog box is found in ____.

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

Question 41

You cannot create a direct link between an Access table and a(n) ____________________ file.

Question 42

The Increase Font Size button is in the Font group on the ____________________ tab.​

Question 43

To change the format of a query datasheet in PowerPoint, you can click the Table Tools ______________ tab, click the More button in the Table Styles group, and then select the desired design.

Question 44

In Word, the Multiple Pages button appears in the ____________________ group of the View tab.

Question 45

The Use Destination Theme button is an option on the ____________________ list arrow.​

Question 47

You can insert a linked Excel file into a PowerPoint presentation using the ___________________ command.

Question 48

When you copy text from Word and paste it in PowerPoint, you can choose to paste the object with or without ____________________ it to the source document.

Question 50

If you copy text from Word and paste it into PowerPoint, the pasted text becomes a(n) ___________________  box that you can then format and position using PowerPoint tools.

Question 51

After you link an Excel file into a PowerPoint presentation, you can double-click it to open it in the source ____________________.

Question 52

You can print slides as ____________________ directly from PowerPoint or create them in Word from your PowerPoint slides.

Question 54

In Word, the Multiple Pages button appears in the  _____ group.​

A)Zoom
B)View
C)Layout
D)Arrange

Question 55

The Links dialog box shows PowerPoint slides linked to a(n) ____________________ document.

Question 56

​ To create PowerPoint handouts in Word, click the File tab, click ____________________, and then click Create Handouts.​

Question 57

The Break Link command is in the ____________________ dialog box in Word.

Question 58

How many options are displayed when you click the Paste list arrow? ____________________​

Question 59

A PowerPoint slide that is not linked to a Word document but is in a Word document is ____________________.

Question 60

Cool Slant is a(n) ____________________ style.

Question 61

To add a shape fill to an object, click the Drawing Tools Design tab, and then click the Shape Fill list arrow in the Shape Styles group. ____________________​

Question 62

In PowerPoint, the Themes group is on the Page Layout tab.

Question 63

You are creating a presentation with highlights from your company's annual report. You want to include a slide that contains a table with a list of your company's branch offices and the number of employees at each location. Instead of manually typing the information in the table, you would like to insert an Access table in your presentation.
You notice a mistake in the number of employees of the Flint branch, so you update the value in the table. Will the change be reflected in the Access table? Explain.

Question 64

To apply a quick style, click the Quick Styles button in the Format group.​ ____________________

Question 65

Why would you want to insert Word objects in a PowerPoint presentation? How can you do this?

Question 66

A select query is the most common type of query.

Question 67

Describe how to create a WordArt object and then how to change the fill color of the WordArt object to a gradient.

Question 68

If you change a customer name from "Miller" to "Millen" in a query's datasheet, you will need to make the update in any other query that also displays this customer's name.

Question 69

Assume you have published PowerPoint slides in Word. What would happen to the original PowerPoint slides if you delete slides in Word?

Question 70

You are creating a presentation with highlights from your company's annual report. You want to include a slide that contains a table with a list of your company's branch offices and the number of employees at each location. Instead of manually typing the information in the table, you would like to insert an Access table in your presentation.
How can you insert the Access table in your current PowerPoint presentation?

Question 71

You can insert a linked Excel file into a PowerPoint presentation using the Insert command. ____________________

Question 72

You are creating a presentation with highlights from your company's annual report. You want to include a slide that contains a table with a list of your company's branch offices and the number of employees at each location. Instead of manually typing the information in the table, you would like to insert an Access table in your presentation.
Now that you have inserted the table, you want to format it to match your presentation style (e.g., using Themed Style 1 - Accent 1). How can you do this?

Question 73

You are creating a brochure for a local florist. They would like you to add a photograph of flowers to the brochure.
How can you add a shadow to the picture to give it some depth?

Question 74

In Query Design View, a table's name displays in the field list title bar.

Question 75

A query can display fields from one or more tables in a relational database.

Question 76

To delete a table row, click the Edit  Table button on the mini-toolbar, and then click Delete Rows​. ____________________

Question 77

To delete a table row, click the Delete Table button on the mini-toolbar, and then click Delete Rows​. ____________________

Question 78

When you open a query in Datasheet View, you run it.

Question 79

​To show table gridlines, click the Tables Tools Layout   tab, then click the View Gridlines button in the Table group. ____________________

Question 80

​ To create PowerPoint handouts in Word, click the File tab, click Save As , and then click Create Handouts.​ ____________________