AOP213 Final Review

To change theme effects, click on Effects on the Page Layout tab, then select the set of effects that you want to use.

• True

• False

To add a calculated field to a PIvotTable, select a cell in the pivot table, then under the PivotTable Tools tab, click the Analyze tab. In the Calculations group, click Fields, Items, & Sets, and then click Calculated Field. Enter a name for the calculated field, type a formula in the Formula box, then click Add to save the calculated field, and click Close.

• True

• False

Adding a bevel to table cells gives the cells a 3D appearance.

• True

• False

To create a section break and start the new section on the same page, insert an Even Page section break.

• True

• False

To close an Access module, you must close the Cheese Basic Editor.

• True

• False

When a section is collapsed, a number appears after the section name. What does this number indicate?

• The slide number of the first slide in the section

• The number of slides in the section

• The slide number of the last slide in the section

• The total time the presentation takes

How can you distinguish between a manually added page break and an automatic page break in a worksheet?

• Automatic page breaks appear as dashed lines while manual page breaks appear as solid lines.

• Automatic page breaks appear as curved lines while manual page breaks appear as jagged lines.

• Automatic page breaks appear as dashed lines while manual page breaks appear as wavy lines.

• Automatic page breaks appear as zigzag lines while manual page breaks appear as solid lines.

To identify differences between two versions of a document, which of the following should be done?

• Use the Smart Lookup command.

• Use the Researcher command.

• Use the Combine command.

• Use the Compare command.

Danielle wants a legend to appear below a chart. She should do which of the following?

• Set the legend position to top.

• Set the legend position to bottom.

• Set the legend position to left.

• Set the legend position to right.

Which of the following would you select on the Developer group to record a relative reference macro?

• Macros

• Visual Basic

• Record Macro

• Use Relative References