Question 1

​ You can use the Check for Errors command to simulate the merge and list any errors found.

Accepted Answer

A) True 
 B)False

Question 2

You can use the Mail Merge Wizard to be guided through the process of a mail merge step-by-step.

Accepted Answer

A) True 
 B)False

Question 3

Which of the following is a function of the Office Clipboard?

Accepted Answer

A) To make a list of actions you want to accomplish 
B) To collect text and object from various files 
C) To store the location of objects from various files 
D) To compile a list of files you need to access 
A) To make a list of actions you want to accomplish 
B) To collect text and object from various files 
C) To store the location of objects from various files 
D) To compile a list of files you need to access

Question 4

​ Bill, a florist, is creating labels for the flowers in his shop. He needs to create a label that will allow him to include a line before the address is entered to include the shop's webpage. To create such a label, Bill should:

Accepted Answer

A) use the Insert Address Block Field button and choose to replace the first field. 
B) use the Insert Merge Field button to insert a field in the document. 
C) use the Create from File button to create a custom field. 
D) use the Insert Greeting Line button and modify it to include a webpage. 
A) use the Insert Address Block Field button and choose to replace the first field. 
B) use the Insert Merge Field button to insert a field in the document. 
C) use the Create from File button to create a custom field. 
D) use the Insert Greeting Line button and modify it to include a webpage.

Question 5

To change the paste options in Microsoft Word 2016, _____.

Accepted Answer

A) click the proofing options from the options menu in Backstage view. 
B) click Special Paste on the Paste menu in the Home tab and choose the options. 
C) click Set Default Paste on the Paste menu in the Home tab and make selections. 
D) click the language options from the options menu in Backstage view. 
A) click the proofing options from the options menu in Backstage view. 
B) click Special Paste on the Paste menu in the Home tab and choose the options. 
C) click Set Default Paste on the Paste menu in the Home tab and make selections. 
D) click the language options from the options menu in Backstage view.

Question 6

​ Using one of the buttons on the Paste button menu allows you to choose to keep the source file theme and formatting or apply the theme and formatting in the destination file.

Accepted Answer

A) True 
 B)False

Question 7

​ Walter, who is working on Microsoft Word 2016, is trying to import data from another file into a word document. He clicks on the Object button in the Insert tab and clicks the Create from File tab. This will allow Walter to:

Accepted Answer

A) open the appropriate program to create a file. 
B) browse to a file with a linked or an embedded object. 
C) browse to a file that can be linked or embedded. 
D) open and attach the file specified as an image 
A) open the appropriate program to create a file. 
B) browse to a file with a linked or an embedded object. 
C) browse to a file that can be linked or embedded. 
D) open and attach the file specified as an image

Question 8

​ Alana is copying some text from a Word file to an Excel file. She wants to retain the formatting of the source file. Which of the following file formats allows her to do that?

Accepted Answer

A) Plain Text format 
B) Rich Text format 
C) Portable Text format 
D) Hyper Text format 
A) Plain Text format 
B) Rich Text format 
C) Portable Text format 
D) Hyper Text format

Question 9

​ When you click the Chart button in the Illustrations group on the Insert tab in Microsoft Word 2016, _____.

Accepted Answer

A)  a chart is created in Word for you to enter data 
B) Word opens a new chart in Microsoft Excel 2016 
C) Word opens a dialog box to insert a chart 
D) a chart link from an Excel worksheet is created in a Word document 
A)  a chart is created in Word for you to enter data 
B) Word opens a new chart in Microsoft Excel 2016 
C) Word opens a dialog box to insert a chart 
D) a chart link from an Excel worksheet is created in a Word document

Question 10

​ Which of the following is a way to start a mail merge?

Accepted Answer

A) Using the Merge and Center button on the Home tab in PowerPoint 
B) Using the Mail Merge Editor in the Export to File in Microsoft Access 
C) Using the Create from File button in Microsoft Word and choose email 
D) Using the buttons on the Mailings tab on the ribbon in Microsoft word 
A) Using the Merge and Center button on the Home tab in PowerPoint 
B) Using the Mail Merge Editor in the Export to File in Microsoft Access 
C) Using the Create from File button in Microsoft Word and choose email 
D) Using the buttons on the Mailings tab on the ribbon in Microsoft word

Question 11

​ You can import data from an Excel worksheet to build a table in _________. 
A)Microsoft Edge 
B)Microsoft Access 
C)Microsoft PowerPoint 
D)Microsoft Word

Accepted Answer

The answer of ​ You can import data from an...

Question 12

​ When you _________ slides in Microsoft PowerPoint, the slide placeholders match the settings in the slide masters. 
A)reset 
B)reboot 
C)save 
D)embed

Accepted Answer

The answer of ​ When you _________ slides in Microsoft...

Question 13

​ Susan is working on a Microsoft PowerPoint 2016 slide that contains a chart from Microsoft Excel 2016. The chart is changed on a daily basis. However, Susan notices that the chart in the slide has not updated. To update the link, Susan should:

Accepted Answer

A) use the proofing options from the options menu in Backstage view. 
B) link the file to the slide again to update the file. 
C) manually update the chart using the Links dialog box. 
D) embed the chart into the PowerPoint slide. 
A) use the proofing options from the options menu in Backstage view. 
B) link the file to the slide again to update the file. 
C) manually update the chart using the Links dialog box. 
D) embed the chart into the PowerPoint slide.

Question 14

​In the given snippet from Microsoft Word 2016, the option that Box 1 indicates allows you to: ​

Accepted Answer

A) link copied data to Word. 
B) link copied data as a hyperlink to Word. 
C) paste a copied item as an image in Word. 
D) paste a copied item as an embedded object in Word. 
A) link copied data to Word. 
B) link copied data as a hyperlink to Word. 
C) paste a copied item as an image in Word. 
D) paste a copied item as an embedded object in Word.

You can use the Check for Errors command to simulate the merge and list any errors found.

You can use the Mail Merge Wizard to be guided through the process of a mail merge step-by-step.

Which of the following is a function of the Office Clipboard?

Bill, a florist, is creating labels for the flowers in his shop. He needs to create a label that will allow him to include a line before the address is entered to include the shop's webpage. To create such a label, Bill should:

To change the paste options in Microsoft Word 2016, _____.

Using one of the buttons on the Paste button menu allows you to choose to keep the source file theme and formatting or apply the theme and formatting in the destination file.

Walter, who is working on Microsoft Word 2016, is trying to import data from another file into a word document. He clicks on the Object button in the Insert tab and clicks the Create from File tab. This will allow Walter to:

Alana is copying some text from a Word file to an Excel file. She wants to retain the formatting of the source file. Which of the following file formats allows her to do that?

When you click the Chart button in the Illustrations group on the Insert tab in Microsoft Word 2016, _____.

Which of the following is a way to start a mail merge?

You can import data from an Excel worksheet to build a table in _________. A)Microsoft Edge B)Microsoft Access C)Microsoft PowerPoint D)Microsoft Word

When you _________ slides in Microsoft PowerPoint, the slide placeholders match the settings in the slide masters. A)reset B)reboot C)save D)embed

Susan is working on a Microsoft PowerPoint 2016 slide that contains a chart from Microsoft Excel 2016. The chart is changed on a daily basis. However, Susan notices that the chart in the slide has not updated. To update the link, Susan should:

In the given snippet from Microsoft Word 2016, the option that Box 1 indicates allows you to:

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

​ You can use the Check for Errors command to simulate the merge and list any errors found.

You can use the Mail Merge Wizard to be guided through the process of a mail merge step-by-step.

Which of the following is a function of the Office Clipboard?

​ Bill, a florist, is creating labels for the flowers in his shop. He needs to create a label that will allow him to include a line before the address is entered to include the shop's webpage. To create such a label, Bill should:

To change the paste options in Microsoft Word 2016, _____.

​ Using one of the buttons on the Paste button menu allows you to choose to keep the source file theme and formatting or apply the theme and formatting in the destination file.

​ Walter, who is working on Microsoft Word 2016, is trying to import data from another file into a word document. He clicks on the Object button in the Insert tab and clicks the Create from File tab. This will allow Walter to:

​ Alana is copying some text from a Word file to an Excel file. She wants to retain the formatting of the source file. Which of the following file formats allows her to do that?

​ When you click the Chart button in the Illustrations group on the Insert tab in Microsoft Word 2016, _____.

​ Which of the following is a way to start a mail merge?

​ You can import data from an Excel worksheet to build a table in _________. A)Microsoft Edge B)Microsoft Access C)Microsoft PowerPoint D)Microsoft Word

​ When you _________ slides in Microsoft PowerPoint, the slide placeholders match the settings in the slide masters. A)reset B)reboot C)save D)embed

​ Susan is working on a Microsoft PowerPoint 2016 slide that contains a chart from Microsoft Excel 2016. The chart is changed on a daily basis. However, Susan notices that the chart in the slide has not updated. To update the link, Susan should:

​In the given snippet from Microsoft Word 2016, the option that Box 1 indicates allows you to: ​

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

You can use the Check for Errors command to simulate the merge and list any errors found.

Bill, a florist, is creating labels for the flowers in his shop. He needs to create a label that will allow him to include a line before the address is entered to include the shop's webpage. To create such a label, Bill should:

Using one of the buttons on the Paste button menu allows you to choose to keep the source file theme and formatting or apply the theme and formatting in the destination file.

Walter, who is working on Microsoft Word 2016, is trying to import data from another file into a word document. He clicks on the Object button in the Insert tab and clicks the Create from File tab. This will allow Walter to:

Alana is copying some text from a Word file to an Excel file. She wants to retain the formatting of the source file. Which of the following file formats allows her to do that?

When you click the Chart button in the Illustrations group on the Insert tab in Microsoft Word 2016, _____.

Which of the following is a way to start a mail merge?

You can import data from an Excel worksheet to build a table in _________. A)Microsoft Edge B)Microsoft Access C)Microsoft PowerPoint D)Microsoft Word

When you _________ slides in Microsoft PowerPoint, the slide placeholders match the settings in the slide masters. A)reset B)reboot C)save D)embed

Susan is working on a Microsoft PowerPoint 2016 slide that contains a chart from Microsoft Excel 2016. The chart is changed on a daily basis. However, Susan notices that the chart in the slide has not updated. To update the link, Susan should:

In the given snippet from Microsoft Word 2016, the option that Box 1 indicates allows you to: