Changing the chart style does not change its layout (the position of elements in the chart area).

True

False

Correct!

Review the section "Chart Design."

Charts can only be moved around on the current worksheet or to another existing worksheet.

True

False

Correct!

Review Develop Your Skills E3-D4, step #3.

The Chart Filters feature allows you to remove values from your chart; you can display all the data again later.

True

False

Correct!

Review the section "Edit Chart Data."

Only pictures that are saved on your computer can be added to an Excel worksheet.

True

False

Correct!

Review the section “Adding Images."

After a conditional formatting rule is created, if the data changes:

the formatting will automatically update to reflect the new data

you must reapply the conditional formatting rule

the conditional formatting is removed

you must click the Refresh button to update the formatting

Correct!

Review the section “Use Conditional Formatting."

Which of these is not a number formatting option for a chart axis?

Currency

Date

Negative

Percentage

Correct!

Review the section “Chart Format."

What chart type is useful for showing trends in data over time, such as days, months, or years?

Pie

Bar

Column

Line

Correct!

Review the section “Choosing a Chart Type."

Which range would you select to create a pie chart of Product 1 sales for January through March?

Partial worksheet showing the range A1:D6. Products, named Product 1 through Product 5, are listed in A2:A6 and the months January, February, and March are column headings in B1:D1. The range B2:D6 is populated with varying numbers.

A1:B6

A1:D2

A2:D2

A1:D6

Correct!

Review the section “Selecting Chart Data."

Which of these is NOT a chart element?

Chart title

Legend

Horizontal axis

Pivot area

Correct!

Review the section “Chart Elements."

Using the selected data as shown, which chart can be created?

Portion of a worksheet with Product 1 through Product 5 listed as row headings and the months January, February, and March showing as column headings. All product row headings and the data in the January column, including the heading, are selected.

A column chart for February and Product 1 through Product 5

A pie chart for Product 1 and the months January through March

A pie chart for January and Product 1 through Product 5

A column chart for Product 1 through Product 5 and the months January through March

Correct!

Review the section “Selecting Chart Data."

Which statement is true regarding what happens after moving a chart to a chart sheet?

You can continue to modify all the elements using chart tools.

You can no longer make any changes to the chart.

You can’t move the chart again.

You can move but not edit the chart.

Correct!

Review the section “Move and Size Charts."

Which feature could have been used to modify the first chart to look like the second?

First chart: A column chart displaying data for January through March, for Product 2 and Product 3. Second chart: A column chart displaying data for January through March, for Products 1, ,2, ,3, and 4.

Change Chart Type

Select Data

Chart Filters

Either Select Data or Chart Filters

Correct!

Review the section "Edit Chart Data."

After inserting a picture or shape, which aspects of the image’s appearance can you edit?

Size and style

Size and color

Style and color

Size, style, and color

Correct!

Review the section “Adding Images."

Which conditional formatting rule would change the first group of data to look like the second?

Portion of a worksheet showing data for five products (Product 1 through Product 5) and five months (January through May). Product labels in rows and month labels in columns. Numbers range from 3 to 15.

Shows the same portion of a worksheet. In this image, the numbers 12, 13, 14, and 15 are formatted with light red fill with dark red text. The numbers 3 through 11 are not formatted.

Greater than 10

Top 5

Greater than 5

Greater than 10 or Top 5

Correct!

Review the section "Use Conditional Formatting."