Question 1

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) link the charts to her Word file so they're always available
B) embed the charts into her Word file so that they will be unchanged when the source file is archived and removed
C) paste the charts as static RTF files
D) paste the charts as Editable JPEG files

Accepted Answer

By embedding the charts into the Word file, they will be part of the document and not linked to the Excel file anymore. This means that the charts will remain unchanged even if the Excel file is archived and removed from the computer. This is the best option for ensuring that the charts are always available in the Word file.

Question 2

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.
-Your boss tells you that she'd like to customize a handful of the letters before they get mailed. You click ____ as the merge option.
A) Edit Individual Documents
B) Print and Send
C) Delete Selected Records
D) Finished and Pending

Accepted Answer

This merge option allows for customization of select letters while still merging the majority automatically. It enables the user to preview each letter before printing or emailing, and make individual changes as needed. This is the best choice to fulfill the boss's request.

Question 3

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.
-The first thing you should do is to ____.
A) create the data source by importing the Access database into a table
B) insert the address block & crosscheck the fields
C) use commands to tell Word to make the document a letter
D) sort the records into alphabetical order

Accepted Answer

The answer of You work for a small non-profit. Your...

Question 4

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

Accepted Answer

The answer of One paste option when pasting an Excel...

Question 5

When you click an embedded object, the ____________________ in the destination program changes to include tabs and commands from the embedded object's source program.

Accepted Answer

The answer of When you click an embedded object, the...

Question 6

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

Accepted Answer

The answer of You can modify an embedded chart's appearance...

Question 7

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?
A) It is the only way to add an individual greeting to the document.
B) It provides a greeting when the first or last name happens to be missing from the data source.
C) It will import the entire name and address as one block, rather than multiple individual fields.
D) It randomizes the greeting for each card in order to feel more personal.

Accepted Answer

Using a Greeting Line merge field allows the letter to automatically include a greeting based on the donor's name and title, even if the first or last name is missing in the database. This ensures that each letter feels personalized and professional.

Question 8

Juliet runs a popular antiques store. She uses Office 2013 to help her manager her business, especially Word and Excel.
-Juliet wants to place an Excel chart into Word. Her best option would be to ____.
A) link it
B) embed it
C) insert it as a picture
D) not enough information to say

Accepted Answer

The answer of Juliet runs a popular antiques store. She...

Question 9

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 ____.
A) rename the database
B) perform the merge
C) insert the merge fields
D) insert the greeting line

Accepted Answer

After selecting the data source, the next step is to insert the merge fields into the Word document to specify where the donor information should appear.

Question 10

The ____ dialog box offers additional choices for moving data on the Clipboard to the destination file.
A) Paste How
B) Clipboard Options
C) Embedding & Linking
D) Paste Special

Accepted Answer

The Paste Special dialog box offers additional choices for moving data on the Clipboard to the destination file, including the ability to specify the format of the pasted data, whether to keep or discard formatting, and whether to link or embed the data.

Question 11

If you ____________________ an Excel chart into Word, and then modify the chart in Word, the source file remains unmodified.

Accepted Answer

The answer of If you ____________________ an Excel chart into...

Question 12

Juliet runs a popular antiques store. She uses Office 2013 to help her manager her business, especially Word and Excel.
-Lastly, Juliet wants to include both a linked Excel chart and an embedded Excel table into a Word file. From her experience, she knows by now that ____.
A) it is not possible to include both a linked and an embedded file
B) the linked file will increase the file size of her Word file significantly
C) there is the possibility of data corruption from trying to include two Excel objects into one Word file
D) she can easily do this

Accepted Answer

It is possible to include both a linked Excel chart and an embedded Excel table into a Word file. Juliet can easily do this using the appropriate commands within Word and Excel.

Question 13

Juliet runs a popular antiques store. She uses Office 2013 to help her manager her business, especially Word and Excel.
-Juliet maintains an Excel file on sales figures for her antiques store that is updated every month. She likes to create charts from the figures and paste them into Word. It's important that the Word files always have the latest information. What is the simplest way for Juliet to ensure this?
A) Link the chart
B) Embed the chart
C) Paste the chart as a picture
D) not enough information to say

Accepted Answer

By linking the chart from the Excel file to the Word file, any changes made to the Excel file will automatically be reflected in the Word file, ensuring that the Word file always has the latest information. Embedding the chart or pasting it as a picture would not allow for automatic updates.

Question 14

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?
A) Nothing; the Excel chart along with all of the software needed to open it will be there in the Word file for Miguel to see
B) Send Miguel the name of the file path that she uses for the Excel chart so he can use it too
C) Break the link so Miguel can see the file without getting an error
D) Consider re-pasting the chart as a picture, because Miguel will not be able to see it otherwise since he doesn't have Excel

Accepted Answer

Since Miguel does not have Excel, he will not be able to view the linked chart in the Word file without downloading or purchasing Excel. Therefore, the best choice would be to copy the chart in Excel and paste it as a picture in Word. This way, Miguel can still see the chart without needing Excel.

Question 15

-In the accompanying figure, the Chart Tools ribbon tabs are available because the chart is ____________________.

Accepted Answer

The answer of 
-In the accompanying figure, the Chart Tools...

Question 16

A disadvantage to ____________________ is that source and destination files must be stored together.

Accepted Answer

The answer of A disadvantage to ____________________ is that source...

Question 17

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.

Accepted Answer

The answer of To update a linked table in Excel,...

Question 18

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.

Accepted Answer

The answer of If you click the Paste button arrow,...

Question 19

When Excel worksheet data is on the Clipboard, the Paste Options menu in PowerPoint includes all of the following paste options EXCEPT ____.
A) embed the workbook
B) paste as a picture
C) paste as unformatted text
D) convert to Access query

Accepted Answer

The paste options menu in PowerPoint does not include an option to convert Excel data on the Clipboard into an Access query. The other three options (embedding the workbook, pasting as a picture, and pasting as unformatted text) are available on the Paste Options menu.

Question 20

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 discover that donor social security numbers are the primary key in the Access database. You ____ in order to keep that information from being available to other people reading the document.
A) decide to enter all data manually
B) change the Unique Identifier field in the Match Fields dialog box to "(not matched)"
C) match the SSN field to "NULL" in the Match Fields dialog box
D) do nothing

Accepted Answer

Changing the Unique Identifier field to "(not matched)" will ensure that the social security numbers are not included in the merged document, as they will not be matched with any field in the Word form letter. This is the best solution as it allows for an efficient and accurate merge, while also protecting sensitive information. Manually entering data would be time-consuming and prone to errors, matching the SSN field to "NULL" could still potentially reveal the information, and doing nothing would result in the social security numbers being included in the merged letters.

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

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

When you click an embedded object, the ____________________ in the destination program changes to include tabs and commands from the embedded object's source program.

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

Juliet runs a popular antiques store. She uses Office 2013 to help her manager her business, especially Word and Excel. -Juliet wants to place an Excel chart into Word. Her best option would be to ____.

The ____ dialog box offers additional choices for moving data on the Clipboard to the destination file.

If you ____________________ an Excel chart into Word, and then modify the chart in Word, the source file remains unmodified.

Juliet runs a popular antiques store. She uses Office 2013 to help her manager her business, especially Word and Excel. -Lastly, Juliet wants to include both a linked Excel chart and an embedded Excel table into a Word file. From her experience, she knows by now that ____.

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?

-In the accompanying figure, the Chart Tools ribbon tabs are available because the chart is ____________________.

A disadvantage to ____________________ is that source and destination files must be stored together.

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.

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.

When Excel worksheet data is on the Clipboard, the Paste Options menu in PowerPoint includes all of the following paste options EXCEPT ____.