Exam 11: Integrating Word, Excel, Access, and Powerpoint

The ______ contextual tabs appears on the Word ribbon when an embedded Excel chart is selected.

You can export an Access query to ____.

If an Excel chart is linked into Word, changes in the chart in Excel will not affect the Word file.

When attempting to paste an Excel object into Word as a linked object, your options are "Link & Keep Source Formatting" or "Link & Use Destination Styles."

If Word doesn't automatically find and the correct fields when creating a mail merge, you can use the Match Fields dialog box to assign fields manually.

In Access, you use a(n) ____________________ to extract information from a database.

A mail merge data source can be any of the following EXCEPT ____.

If an Excel table is likely to change, and you want to make sure that its information is updated in any files in which it is used, it is best to ____.

An advantage of embedding is that ____.

If your document does not show nonprinting characters, click the Show/Hide button in the Paragraph group on the ____ tab.

In Access, you find the Queries group on the ____ tab of the Ribbon.

MATCHING -used to see the outline of a document

You use the Merge Connections dialog box to select the people who will receive a merged letter.

When importing an outline into PowerPoint, second-level bulleted items are created from paragraphs formatted with the ____ style.

You may import both Access tables and Access queries into Word.

You work for a small non-profit. Your boss has given you the task of creating thank-you letters to send to people who have donated to your non-profit organization this past year. She has given you a form letter in Word and a database of donors in Access. You need to merge the two. -Within the Word document, you have now successfully selected the Access database as the data source. The next step is to ____.

If you click the Paste button arrow, a menu appears; you can point to the buttons on that menu to see a(n) ____________________ of the pasted object.

If you have clicked the Paste button to insert an object, you can still change the way an object is pasted by clicking the ____ button that appears just below and to the right of the pasted object.

When exporting an Access query to Word, you will make use of the Export - ____________________ dialog box.

Juliet runs a popular antiques store. She uses Office 2013 to help her manager her business, especially Word and Excel. -Juliet wants to e-mail a Word file with a linked Excel chart to her friend Miguel. She knows that Miguel has Word, but does not have Excel. What should Juliet do?