Question 1

Which of the following is a disadvantage of embedding an object? ​

Accepted Answer

A) The source file and the destination file need to be stored together. 
B) The destination file size increases reflecting the addition of the object from the source file. 
C) Changes made in the destination file are reflected in the source file. 
D) Changes made in the source file are reflected in the destination file. 
A) The source file and the destination file need to be stored together. 
B) The destination file size increases reflecting the addition of the object from the source file. 
C) Changes made in the destination file are reflected in the source file. 
D) Changes made in the source file are reflected in the destination file. B

Question 2

The _________ will offer only options to embed charts or paste them as an image if you close the relevant Excel workbook. 
A)Paste button menu 
B)Embed objects menu 
C)Paste objects button 
D)Embed button menu

Accepted Answer

Paste button menu

Question 3

​ In the context of mail merges, you can explicitly identify a merge field by:

Accepted Answer

A) using the Match Fields dialog box 
B) using the Insert Address block dialog box 
C) using the Name Line merge field dialog box 
D) using the Location Block merge field dialog box 
A) using the Match Fields dialog box 
B) using the Insert Address block dialog box 
C) using the Name Line merge field dialog box 
D) using the Location Block merge field dialog box A

Question 4

​List the procedure to insert Access data in a PowerPoint slide.

Accepted Answer

Answers will vary. If you want to use Ac

Question 5

​ Jim is creating a PowerPoint presentation using various charts and data from the outlines in a Word document. If he creates a slide from an outline, Microsoft PowerPoint 2016:

Accepted Answer

A) opens a dialog box to format the outline. to a slide. 
B) uses the heading styles from Word to determine the format of the text. 
C) starts the Import Object Wizard to determine the format of the text. 
D) keeps the formatting of the source document. 
A) opens a dialog box to format the outline. to a slide. 
B) uses the heading styles from Word to determine the format of the text. 
C) starts the Import Object Wizard to determine the format of the text. 
D) keeps the formatting of the source document.

Question 6

​ You can import data that is in the form of charts, images, and slides.

Accepted Answer

A) True 
 B)False

Question 7

​ Which of the following allows you to start a mail merge through emails?

Accepted Answer

A) Using the mail merge when writing an e-mail in Microsoft Outlook 
B) Saving a completed mail merge as a Rich Text Format word file and copying it to an e-mail 
C) Selecting E-mail messages in the Start Mail Merge button menu in the Mailings tab 
D) Writing an email and choosing the mail merge option from the sending options 
A) Using the mail merge when writing an e-mail in Microsoft Outlook 
B) Saving a completed mail merge as a Rich Text Format word file and copying it to an e-mail 
C) Selecting E-mail messages in the Start Mail Merge button menu in the Mailings tab 
D) Writing an email and choosing the mail merge option from the sending options

Question 8

​ When you create slides from a(n) _________ of a Word document, PowerPoint inserts them after the current slide. 
A)outline 
B)link 
C)image 
D)screenshot

Accepted Answer

The answer of ​ When you create slides from a(n)...

Question 9

​ The _________ dialog box opens when you create a slide from a Word outline. 
A)Edit Outline 
B)Insert Outline 
C)Format Outline 
D)Change Outline

Accepted Answer

The answer of ​ The _________ dialog box opens when...

Question 10

​ Robert is using Microsoft Excel 2016 to create a worksheet. He adds a list of data from a Microsoft Access file to the worksheet and uses it in a PowerPoint slide in a presentation. In the context of linking and embedding, which of the following types of programs is Microsoft PowerPoint?

Accepted Answer

A) Firewall program 
B) Destination program 
C) Wireframe program 
D) Source program 
A) Firewall program 
B) Destination program 
C) Wireframe program 
D) Source program

Question 11

Case 22-1 Hayley is working on a mail merge to draft a letter. She prepares the main documents, data sources, and merge fields.
To complete the mail merge, she should:

Accepted Answer

A) try and print the first page to see if the documents print correctly. 
B) run the Autocorrect command to make sure the document will print properly. 
C) click the Preview Results button to see the file without the merge fields. 
D) click the Rules button in the Mailings tab to see if the merge fields work. 
A) try and print the first page to see if the documents print correctly. 
B) run the Autocorrect command to make sure the document will print properly. 
C) click the Preview Results button to see the file without the merge fields. 
D) click the Rules button in the Mailings tab to see if the merge fields work.

Question 12

Ezra is working on a Word document that contains a linked chart from an Excel worksheet. He updates the chart in the worksheet, but the changes do not appear in the Word document. In this scenario, to update the chart, Ezra should click the _____ button on the Chart Tools Design tab.

Accepted Answer

A) Arrange Data 
B) Refresh Data d document. 
C) Insert Chart 
D) Update Chart 
A) Arrange Data 
B) Refresh Data d document. 
C) Insert Chart 
D) Update Chart

Question 13

​ If a linked worksheet does not refresh, you should:

Accepted Answer

A) right-click the Arrange button in the Format tab. 
B) left-click the Refresh Data button in the Design tab. 
C) left-click to select the worksheet and press the F5 key. 
D) right-click the worksheet and click Update Link. 
A) right-click the Arrange button in the Format tab. 
B) left-click the Refresh Data button in the Design tab. 
C) left-click to select the worksheet and press the F5 key. 
D) right-click the worksheet and click Update Link.

Question 14

​ If you choose to embed or link a file using the Create from File tab, the copied data from the file is inserted as an object in the destination file.

Accepted Answer

A) True 
 B)False

Question 15

​ Clicking the Finish & Merge button in the Finish group on the Mailings tab opens _____.

Accepted Answer

A) a dialog box asking you to confirm if you want to complete the mail merge 
B) a new document containing the results of the mail merge 
C) a side panel that allows you to choose a location to save the results as an image 
D) a menu that allows you to print form letters, send email, or save the contents 
A) a dialog box asking you to confirm if you want to complete the mail merge 
B) a new document containing the results of the mail merge 
C) a side panel that allows you to choose a location to save the results as an image 
D) a menu that allows you to print form letters, send email, or save the contents

Question 16

​ If a Microsoft _________ dialog box opens warning you that a potential security concern has been identified, click Open. 
A)Access Security Notice 
B)Shield Wizard 
C)Office Security 
D)Threat Detector

Accepted Answer

Access Sec

Question 17

​ Which of the following is a disadvantage of linking an object?

Accepted Answer

A) The source file and the destination file need to be stored together. 
B) Changes made in the destination file are reflected in the source file. 
C) Changes made in the source file are not reflected in the destination file. 
D) The source file is deleted once linked into the destination file. 
A) The source file and the destination file need to be stored together. 
B) Changes made in the destination file are reflected in the source file. 
C) Changes made in the source file are not reflected in the destination file. 
D) The source file is deleted once linked into the destination file.

Question 18

​ In the accompanying figure of Microsoft Word 2016, which of the following boxes points to the Excel Chart Tools for the inserted chart? ​

Accepted Answer

A)  Box 1 
B) Box 2 
C) Box 3 
D) Box 4 
A)  Box 1 
B) Box 2 
C) Box 3 
D) Box 4

Question 19

​ In the accompanying figure of Microsoft Excel 2016, which of the following best describes the purpose of the component that Box 1 indicates? ​

Accepted Answer

A)  ​​ It allows you to save a worksheet as a chart in Word. 
B) It allows you to modify the data in an embedded chart. 
C)  It allows you to link a chart to a Word file. 
D)  It allows you to change the formatting of an embedded chart. 
A)  ​​ It allows you to save a worksheet as a chart in Word. 
B) It allows you to modify the data in an embedded chart. 
C)  It allows you to link a chart to a Word file. 
D)  It allows you to change the formatting of an embedded chart.

Question 20

​ If a Word outline was used to create the slide shown in the accompanying figure, which of the following was Heading 1 in the Word document? ​

Accepted Answer

A) $4.50/SFT 
B) Ash and Cherry Flooring Options 
C) Species 
D) Engineered hardwood 
A) $4.50/SFT 
B) Ash and Cherry Flooring Options 
C) Species 
D) Engineered hardwood

Exam 22: Integrating Word, Excel, Access and Powerpoint

Which of the following is a disadvantage of embedding an object? ​

The _________ will offer only options to embed charts or paste them as an image if you close the relevant Excel workbook. A)Paste button menu B)Embed objects menu C)Paste objects button D)Embed button menu

​ In the context of mail merges, you can explicitly identify a merge field by:

​List the procedure to insert Access data in a PowerPoint slide.

​ Jim is creating a PowerPoint presentation using various charts and data from the outlines in a Word document. If he creates a slide from an outline, Microsoft PowerPoint 2016:

​ You can import data that is in the form of charts, images, and slides.

​ Which of the following allows you to start a mail merge through emails?

​ When you create slides from a(n) _________ of a Word document, PowerPoint inserts them after the current slide. A)outline B)link C)image D)screenshot

​ The _________ dialog box opens when you create a slide from a Word outline. A)Edit Outline B)Insert Outline C)Format Outline D)Change Outline

​ Robert is using Microsoft Excel 2016 to create a worksheet. He adds a list of data from a Microsoft Access file to the worksheet and uses it in a PowerPoint slide in a presentation. In the context of linking and embedding, which of the following types of programs is Microsoft PowerPoint?

Case 22-1 Hayley is working on a mail merge to draft a letter. She prepares the main documents, data sources, and merge fields. To complete the mail merge, she should:

Ezra is working on a Word document that contains a linked chart from an Excel worksheet. He updates the chart in the worksheet, but the changes do not appear in the Word document. In this scenario, to update the chart, Ezra should click the _____ button on the Chart Tools Design tab.

​ If a linked worksheet does not refresh, you should:

​ If you choose to embed or link a file using the Create from File tab, the copied data from the file is inserted as an object in the destination file.

​ Clicking the Finish & Merge button in the Finish group on the Mailings tab opens _____.

​ If a Microsoft _________ dialog box opens warning you that a potential security concern has been identified, click Open. A)Access Security Notice B)Shield Wizard C)Office Security D)Threat Detector

​ Which of the following is a disadvantage of linking an object?

​ In the accompanying figure of Microsoft Word 2016, which of the following boxes points to the Excel Chart Tools for the inserted chart? ​

​ In the accompanying figure of Microsoft Excel 2016, which of the following best describes the purpose of the component that Box 1 indicates? ​

​ If a Word outline was used to create the slide shown in the accompanying figure, which of the following was Heading 1 in the Word document? ​

Introduction to Computers and the Internet

Computer Hardware

Computer Software

Computer Networks

The Internet and Email

Security and Privacy

Exploring Windows 10 and Managing Files

Using Edge Mail and People

Introducing Microsoft Office 2016

Creating a Document

Formatting a Long Document

Enhancing a Document

Creating a Workbook

Working With Formulas and Functions

Creating an Advanced Workbook

Inserting and Formatting Charts

Creating a Database

Maintaining and Querying a Database

Creating Forms and Reports

Creating Apresentation

Enhancing a Presentation

Filters

Which of the following is a disadvantage of embedding an object?

In the context of mail merges, you can explicitly identify a merge field by:

List the procedure to insert Access data in a PowerPoint slide.

Jim is creating a PowerPoint presentation using various charts and data from the outlines in a Word document. If he creates a slide from an outline, Microsoft PowerPoint 2016:

You can import data that is in the form of charts, images, and slides.

Which of the following allows you to start a mail merge through emails?

When you create slides from a(n) _________ of a Word document, PowerPoint inserts them after the current slide. A)outline B)link C)image D)screenshot

The _________ dialog box opens when you create a slide from a Word outline. A)Edit Outline B)Insert Outline C)Format Outline D)Change Outline

Robert is using Microsoft Excel 2016 to create a worksheet. He adds a list of data from a Microsoft Access file to the worksheet and uses it in a PowerPoint slide in a presentation. In the context of linking and embedding, which of the following types of programs is Microsoft PowerPoint?

If a linked worksheet does not refresh, you should:

If you choose to embed or link a file using the Create from File tab, the copied data from the file is inserted as an object in the destination file.

Clicking the Finish & Merge button in the Finish group on the Mailings tab opens _____.

If a Microsoft _________ dialog box opens warning you that a potential security concern has been identified, click Open. A)Access Security Notice B)Shield Wizard C)Office Security D)Threat Detector

Which of the following is a disadvantage of linking an object?

In the accompanying figure of Microsoft Word 2016, which of the following boxes points to the Excel Chart Tools for the inserted chart?

In the accompanying figure of Microsoft Excel 2016, which of the following best describes the purpose of the component that Box 1 indicates?

If a Word outline was used to create the slide shown in the accompanying figure, which of the following was Heading 1 in the Word document?