Microsoft Excel: Chapter 3 Test Review

____ analysis looks at how future results might change based on varying inputs or data.

Calculate a percentage of a total by dividing the individual value by the total value.

• True

• False

____ means to insert an object in a destination document so that it can still be edited by the source application.

Excel will always display an error message when improperly placed parentheses can cause logic flaws in a formula.

• True

• False

An ____ chart is a chart that exists as an object in the worksheet alongside the data.

The ____ area is the overall background for the chart and all its elements.

Making data or formatting changes to an Excel chart embedded in Word also changes the original data or chart in Excel.

• True

• False

Separating one slice of a pie chart from the rest of the chart is called:

• Reforming

• Exploding

• Adjusting

• Emphasizing

To maintain the link, the source and destination files do not need to remain in their original locations.

• True

• False

When you change the data or chart formatting in a linked chart and open the destination file again, the link causes the destination chart to update as well.

• True

• False