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

Accepted Answer

Access data can be exported to Word documents, Excel spreadsheets, and Excel worksheets, but there is no direct import or export command for moving Access data to a PowerPoint presentation.

Question 2

Access is best used for charting and manipulating data.

Accepted Answer

Access is best used for database management and data organization, while Excel is typically used for charting and manipulating data.

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

Accepted Answer

The expand button is used to expand or show the lower levels in an outline after they have been collapsed.

Question 4

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

Accepted Answer

Data from Access 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

Accepted Answer

The answer of To get data from Access to a...

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

Accepted Answer

Word automatically assigns heading styles to the paragraphs when typed in Outline view.

Question 7

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

Accepted Answer

The answer of Using the ________ button moves paragraphs to...

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

Accepted Answer

A hierarchy of paragraphs is an outline, which Word recognizes by end-of-paragraph marks. Reports and documents are more general terms and do not specifically refer to a hierarchical format. Sentences are not grouped in a hierarchical structure.

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

Accepted Answer

The Move Up and Move Down buttons only change the position of the selected lines within the same paragraph, so the best choice is B - position. The other options are not related to the function of these buttons.

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.

Accepted Answer

The Data Link Properties dialog box does require you to set a username and password when accessing data from Access for the first time.

Question 11

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

Accepted Answer

The minus sign at the beginning of a line is often used to denote a bullet point in markdown or plain text formats, not specifically a paragraph.

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.

Accepted Answer

All three methods mentioned (copy and paste, connecting to Access database, and exporting Access data) are valid ways to bring data into Excel from Access.

Question 13

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

Accepted Answer

When you demote a paragraph, you move it to a lower level in the outline hierarchy, not a higher one.

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

Accepted Answer

Access is a database management system that is used to store, sort, and report data.

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

Accepted Answer

When Access data is copied and pasted into Excel, the copy in Excel cannot be automatically updated. This is because the data in Excel is a static copy of the data in Access, and any changes made to the data in Access will not be reflected in the copy in Excel.

Question 16

In Outline View,paragraphs are listed by ________.
A) pages
B) levels
C) sections
D) lines

Accepted Answer

In Outline View, paragraphs are listed by levels, which refers to the hierarchical structure of the document. Each level represents a subdivision of the previous level, with the highest level being the main topic or title of the document. This allows for easy organization and manipulation of the document's content.

Question 17

You can NOT create a chart in ________.
A) Excel
B) Word
C) Access
D) PowerPoint

Accepted Answer

Access is primarily a database management tool, and while it can create reports and forms that include graphical elements, it does not have a direct feature for creating standalone charts like Excel, Word, or PowerPoint. Charts in Access are typically embedded in forms or reports and are not created in the same manner as in the other applications.

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

Accepted Answer

If you close Excel before pasting the chart into PowerPoint, you will not be able to use Paste Link option as it requires the source file to be open. The other options (Paste Bitmap, Paste Special, and Paste Microsoft Office Graphic Object) will still be available.

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

Accepted Answer

When creating PowerPoint slides from a Word outline, PowerPoint will use the highest level of paragraphs as slide titles. This allows for an organized and easy-to-follow presentation structure.

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.

Accepted Answer

In Outline View, a paragraph that has levels below it will display a plus sign or Collapse button at the beginning of the line to indicate that it can be collapsed to hide its sublevels.

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

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

Access is best used for charting and manipulating data.

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

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

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

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

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

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

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

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.

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

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.

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

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

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

In Outline View,paragraphs are listed by ________.

You can NOT create a chart in ________.

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

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

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