Exam 22: Integrating Word, Excel, Access and Powerpoint

Sean is working on a mail merge. Since he is not allowed to post letters to the recipients due to his company's policy on sustainability and responsibility, he decides to e-mail the message. Which of the following should Sean do after selecting the recipients in Outlook?

(Multiple Choice)

4.9/5

(34)

Question 41

Changes made to an embedded object appear in the source file.

(True/False)

4.8/5

(36)

Question 42

Case 22-2 Clark, an HR manager, wants to communicate a policy on information security to all the employees. He acquires the names and addresses of the employees from an Excel worksheet. He also drafts a preliminary text about the policy and a table of points to follow to ensure online safety. To incorporate transparency, he inserts a simple poll to receive feedback. In the context of mail merge, which of the following is the data source in this scenario?

(Multiple Choice)

4.8/5

(31)

Question 43

Which of the following is an advantage of linking an object?

(Multiple Choice)

4.8/5

(36)

Question 44

In the context of mail merge in Word, when you click the Check for Errors button, _____.

(Multiple Choice)

4.8/5

(47)

Question 45

In a form letter, merge fields contain:

(Multiple Choice)

4.9/5

(34)

Question 46

Marshall is using Microsoft Access to export a query table to Microsoft Excel 2016. If he does not want to preserve the layout of the data, he should:

(Multiple Choice)

4.9/5

(42)

Question 47

The _________ command in the Object button in Microsoft Word 2016 inserts only the text of a file into the destination document. A)Text from File B)Drop Cap C)Link text D)Text to Insert

(Short Answer)

4.7/5

(34)

Question 48

Case 22-2 Clark, an HR manager, wants to communicate a policy on information security to all the employees. He acquires the names and addresses of the employees from an Excel worksheet. He also drafts a preliminary text about the policy and a table of points to follow to ensure online safety. To complete the mail merge, Clark should:

(Multiple Choice)

4.9/5

(47)

Question 49

When pasting a table from Microsoft Access to Microsoft Word, you can use the _________ in the Table Tools Layout tab to remove the first row. A)Delete button B)Remove button C)Trash button D)Discard button

(Short Answer)

4.9/5

(36)

Question 50

You can export Access data directly to a PowerPoint slide.

(True/False)

4.8/5

(42)

Question 51

The program used to create the object you want to integrate into another program is the source program.

(True/False)

4.9/5

(41)

Question 52

If a chart exists in an Excel worksheet and you think you might update it in the future, consider embedding it in a Word document or PowerPoint slide instead of linking it.

(True/False)

4.9/5

(47)

Question 53

Michelle is exporting data from a table in Microsoft Access 2016 to Microsoft Word 2016. To ensure that the formatting and layout from the query is preserved, Michelle should:

(Multiple Choice)

4.9/5

(41)

Question 54

Apart from using the Text from File button, you can also just open a(n) _________ file in a Word window, copy tables, and paste them into the destination file. A)Plain Text Format B)Rich Text Format C)Database Format D)Worksheet Format

(Short Answer)

4.9/5

(37)

Question 55

Which of the following merge fields includes a recipient's first and last name, address, city, and state in a single merge field?

(Multiple Choice)

4.8/5

(36)

Question 56

In a mail merge, data source is a file that contains the variable information for a _________. A)form letter B)merge field C)main document D)linked file

(Short Answer)

4.7/5

(32)

Question 57

If you use the Reset button on the Home tab in a Microsoft PowerPoint 2016 presentation, _____. ed item on the slide.

(Multiple Choice)

4.8/5

(42)

Question 58

Describe how to import and export data from Microsoft Access tables.

(Essay)

4.9/5

(38)

Question 59

Case 22-1 Hayley is working on a mail merge to draft a letter. She prepares the main documents, data sources, and merge fields. After entering addresses and names from a database, Hayley notices a distance between each address. To correct this, Hayley should:

(Multiple Choice)

4.9/5

(37)

Question 60

Showing 41 - 60 of 74

Sean is working on a mail merge. Since he is not allowed to post letters to the recipients due to his company's policy on sustainability and responsibility, he decides to e-mail the message. Which of the following should Sean do after selecting the recipients in Outlook?

Changes made to an embedded object appear in the source file.

Which of the following is an advantage of linking an object?

In the context of mail merge in Word, when you click the Check for Errors button, _____.

In a form letter, merge fields contain:

Marshall is using Microsoft Access to export a query table to Microsoft Excel 2016. If he does not want to preserve the layout of the data, he should:

The _________ command in the Object button in Microsoft Word 2016 inserts only the text of a file into the destination document. A)Text from File B)Drop Cap C)Link text D)Text to Insert

When pasting a table from Microsoft Access to Microsoft Word, you can use the _________ in the Table Tools Layout tab to remove the first row. A)Delete button B)Remove button C)Trash button D)Discard button

You can export Access data directly to a PowerPoint slide.

The program used to create the object you want to integrate into another program is the source program.

If a chart exists in an Excel worksheet and you think you might update it in the future, consider embedding it in a Word document or PowerPoint slide instead of linking it.

Michelle is exporting data from a table in Microsoft Access 2016 to Microsoft Word 2016. To ensure that the formatting and layout from the query is preserved, Michelle should:

Apart from using the Text from File button, you can also just open a(n) _________ file in a Word window, copy tables, and paste them into the destination file. A)Plain Text Format B)Rich Text Format C)Database Format D)Worksheet Format

Which of the following merge fields includes a recipient's first and last name, address, city, and state in a single merge field?

In a mail merge, data source is a file that contains the variable information for a _________. A)form letter B)merge field C)main document D)linked file

If you use the Reset button on the Home tab in a Microsoft PowerPoint 2016 presentation, _____. ed item on the slide.

Describe how to import and export data from Microsoft Access tables.

Case 22-1 Hayley is working on a mail merge to draft a letter. She prepares the main documents, data sources, and merge fields. After entering addresses and names from a database, Hayley notices a distance between each address. To correct this, Hayley should:

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

Exam 22: Integrating Word, Excel, Access and Powerpoint

Sean is working on a mail merge. Since he is not allowed to post letters to the recipients due to his company's policy on sustainability and responsibility, he decides to e-mail the message. Which of the following should Sean do after selecting the recipients in Outlook?

​ Changes made to an embedded object appear in the source file.

​ Which of the following is an advantage of linking an object?

​ In the context of mail merge in Word, when you click the Check for Errors button, _____.

​ In a form letter, merge fields contain:

​ Marshall is using Microsoft Access to export a query table to Microsoft Excel 2016. If he does not want to preserve the layout of the data, he should:

​ The _________ command in the Object button in Microsoft Word 2016 inserts only the text of a file into the destination document. A)Text from File B)Drop Cap C)Link text D)Text to Insert

​ When pasting a table from Microsoft Access to Microsoft Word, you can use the _________ in the Table Tools Layout tab to remove the first row. A)Delete button B)Remove button C)Trash button D)Discard button

​ You can export Access data directly to a PowerPoint slide.

The program used to create the object you want to integrate into another program is the source program.​

​ If a chart exists in an Excel worksheet and you think you might update it in the future, consider embedding it in a Word document or PowerPoint slide instead of linking it.

​ Michelle is exporting data from a table in Microsoft Access 2016 to Microsoft Word 2016. To ensure that the formatting and layout from the query is preserved, Michelle should:

​ Apart from using the Text from File button, you can also just open a(n) _________ file in a Word window, copy tables, and paste them into the destination file. A)Plain Text Format B)Rich Text Format C)Database Format D)Worksheet Format

​ Which of the following merge fields includes a recipient's first and last name, address, city, and state in a single merge field?

​ In a mail merge, data source is a file that contains the variable information for a _________. A)form letter B)merge field C)main document D)linked file

​ If you use the Reset button on the Home tab in a Microsoft PowerPoint 2016 presentation, _____. ed item on the slide.

​ Describe how to import and export data from Microsoft Access tables.

Case 22-1 Hayley is working on a mail merge to draft a letter. She prepares the main documents, data sources, and merge fields. ​ After entering addresses and names from a database, Hayley notices a distance between each address. To correct this, Hayley should:

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

Changes made to an embedded object appear in the source file.

Which of the following is an advantage of linking an object?

In the context of mail merge in Word, when you click the Check for Errors button, _____.

In a form letter, merge fields contain:

Marshall is using Microsoft Access to export a query table to Microsoft Excel 2016. If he does not want to preserve the layout of the data, he should:

The _________ command in the Object button in Microsoft Word 2016 inserts only the text of a file into the destination document. A)Text from File B)Drop Cap C)Link text D)Text to Insert

When pasting a table from Microsoft Access to Microsoft Word, you can use the _________ in the Table Tools Layout tab to remove the first row. A)Delete button B)Remove button C)Trash button D)Discard button

You can export Access data directly to a PowerPoint slide.

The program used to create the object you want to integrate into another program is the source program.

If a chart exists in an Excel worksheet and you think you might update it in the future, consider embedding it in a Word document or PowerPoint slide instead of linking it.

Michelle is exporting data from a table in Microsoft Access 2016 to Microsoft Word 2016. To ensure that the formatting and layout from the query is preserved, Michelle should:

Apart from using the Text from File button, you can also just open a(n) _________ file in a Word window, copy tables, and paste them into the destination file. A)Plain Text Format B)Rich Text Format C)Database Format D)Worksheet Format

Which of the following merge fields includes a recipient's first and last name, address, city, and state in a single merge field?

In a mail merge, data source is a file that contains the variable information for a _________. A)form letter B)merge field C)main document D)linked file

If you use the Reset button on the Home tab in a Microsoft PowerPoint 2016 presentation, _____. ed item on the slide.

Describe how to import and export data from Microsoft Access tables.

Case 22-1 Hayley is working on a mail merge to draft a letter. She prepares the main documents, data sources, and merge fields. After entering addresses and names from a database, Hayley notices a distance between each address. To correct this, Hayley should: