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

Access is not included with all versions of Microsoft Office.

____ fields contain instructions for replacing these field placeholders with the variable information from a data source.

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. -You decide to use a Greeting Line merge field. Why?

Describe the general steps for embedding an Excel chart into a Word document.

To update a linked table in Excel, the first steps are to right-click the table in the document, point to ____________________ on the shortcut menu, then click Edit Link.

When viewing an Access query, if you click "View" in the Views group of the HOME tab, your query will display in ____ view.

One paste option when pasting an Excel chart into Word is Use Destination ____________________ & Embed Workbook.

To break a link, you use the Links command on the ____.

Juliet runs a popular antiques store. She uses Office 2013 to help her manager her business, especially Word and Excel. -Juliet has created a Word file for end-of-the-year sales figures. She wants to include charts from her Excel spreadsheets. She then wants to archive the Excel spreadsheets and remove them from her computer so she doesn't risk confusing them with the current ones for the current year. She should ____.

A disadvantage of linking is that ____.

The location of a source file is known as its ____.

MATCHING -nonprinting character

When pasting an Excel chart into a Word document, using the ____ button makes the formatting the same as the Word document's and keeps the source file separate.

To insert a Word outline into PowerPoint, you click the New Slide button arrow, then click ____________________.

-The accompanying figure shows an Excel chart within a Word document.

You use a(n) ____ in Access to extract information from a database.

-Paragraphs formatted like Box D in the accompanying figure will become ____ when imported into PowerPoint.

To change the default paste option, click ____ on the Paste menu.

Describe the similarities and differences between the Paste Options button and the Paste Special command.

You can modify an embedded chart's appearance using commands on the ____________________ contextual tabs that appear on the ribbon.