Exam 27: Integration Unit C: Integrating Word, Excel, Access, and Powerpoint

After updating an Access table, linked values in Excel will update automatically if you wait a few minutes.

To embed an object in a PowerPoint presentation, you use the ____ command in the Text group on the Insert tab.

If your presentation requires an object and you want to keep your presentation file size small, you should ____ the object's source file.

You can speed up the update of values in Excel linked to an Access table by updating the values manually in the ____ dialog box.

When you click on the tab pointed to by item 1 in the figure above, you will be able to ____.

The values in columns E and G of the figure above are in the ____ format.

The source for the outline pointed to by item 2 in the figure above is a(n) ____.

The element pointed to by item 4 in the figure above adds a(n) ____ to your PowerPoint slides.

The proper formula in Excel for calculating the percentage change between cells D3 and D2 is ____.

If you want an Access table to be sorted in alphabetical order by a particular field, you need to create a(n) ____________________ containing the sorted data.

In the figure above, item 5 points to a button that ____ selected text.

To calculate the value pointed to by item 3 in the figure above, ____ numbers are added.

You embed data created in other programs in PowerPoint when you want to be able to edit it from within the ____________________ file.

After adding values and labels to the embedded object, how do you calculate total revenue for the years 2008-2010?

A value that you copy from Excel and paste into PowerPoint as a link is formatted as a(n) ____.

One slide in the presentation you are developing for Mary Lou Jacobs requires a spreadsheet that includes several calculations. Since the calculations are specific to the presentation, you decide to embed and then edit the spreadsheet in PowerPoint. The result of your work is shown in the figure below. How do you embed an Excel worksheet in a slide of the presentation?

Because the Excel data in the above figure is ____ an Access table, it will be updated when you update the Access table.

You ____________________ an object to a PowerPoint slide when the object's source file is shared on a network or where other users have access to the file and can change it.

You link an object to a PowerPoint slide when you always want your object to include the latest information.

Explain the purpose of the Object command.