Deck 3: Integrated Projects, workshop 3: Integrating Word, excel, access, and Powerpoint

Question 1

There is not import or export command for moving Access data to a(n)________.

A) PowerPoint presentation
B) Word document
C) Excel spreadsheet
D) Excel worksheet

Answer 1

A

Question 2

Access is best used for charting and manipulating data.

Answer 2

False

Question 3

The ________ button allows you to show the lower levels in an outline after they have been collapsed.

A) Display
B) Expand
C) Show/Hide
D) Collapse

Answer 3

B

Question 4

Any data from an Access table or query can be selected,copied,and pasted into PowerPoint using the Clipboard.

Question 5

To get data from Access to a PowerPoint presentation,you must use ________.

A) Mail Merge
B) the Import Data button in PowerPoint
C) the Export Data button in Access
D) copy and paste

Question 6

Word automatically assigns ________ to the paragraphs when you type a paragraph into a document in Outline view.

A) font styles
B) paragraph names
C) end-of-paragraph marks
D) heading styles

Question 7

Using the ________ button moves paragraphs to a higher level in the outline.

Question 8

A(n)________ is a group of paragraphs in a hierarchical format that Word recognizes by end-of-paragraph marks.

A) report
B) sentence
C) outline
D) document

Question 9

The Move Up and Move Down buttons move selected lines up or down,but only changes the ________ of the paragraphs.

A) sections
B) position
C) pages
D) levels

Question 10

The first time you use a link on your computer to get data from Access,the Data Link Properties dialog box will open and require you to set a username and password.

Question 11

The minus sign at the beginning of a line indicates a paragraph that is a simple bullet point.

Question 12

When bringing data into Excel from Access,you can use the copy and paste commands in Clipboard,by connecting to an Access database from a worksheet,and by exporting Access data into the Excel worksheet.

Question 13

When you demote a paragraph,you move it to a higher level in the outline.

Question 14

If you need to store,sort,or report data,your best Microsoft Office application choice is ________.

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

Question 15

When Access data is copied and pasted into Excel,the copy in Excel cannot be automatically ________.

A) updated
B) deleted
C) linked
D) expanded

Question 16

In Outline View,paragraphs are listed by ________.

A) pages
B) levels
C) sections
D) lines

Question 17

You can NOT create a chart in ________.

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

Question 18

When you are copying and pasting an Excel chart into a PowerPoint slide,if you close Excel before pasting the chart into PowerPoint,you will NOT be able to use ________.

A) Paste bitmap
B) Paste link
C) Paste Special
D) Paste Microsoft Office Graphic Object

Question 19

When you create PowerPoint slides from a Word outline,PowerPoint uses the highest level of paragraphs in the outline as ________.

A) bullet lists
B) slide text
C) slide titles
D) the presentation title

Question 20

In Outline View,a paragraph that has levels below it will display a plus sign or Collapse button at the beginning of the line.

Question 21

If you use Access data to create an Excel chart,and then link the chart to a PowerPoint presentation,when the data is updated in Access,it can be ________ in Excel and PowerPoint at the same time.

Question 22

A hierarchical representation of paragraphs is called a(n)________.

Question 23

The top level of the Outline hierarchy is called the ________ paragraph.

Question 24

There is no import or export command for moving Access data to a(n)________ presentation.

Question 25

Importing data from an Access database into an Excel worksheet creates a(n)________ connection.

Question 26

The ________ database does not have charting capability.