You have the following chart and you’d like to convert the Flexible Budget series to an area chart. What is the first thing you need to do?

Answer 1

Right click the Flexible Budget series and choose “Convert to Combination Chart”

Answer 2

Right click the Flexible Budget series and choose “Change Series Chart Type”

Answer 3

Right click the Flexible Budget series and choose “Format Series”

Answer 4

Don’t know

Answer 5

4: three lines series and an area series

Answer 6

3: three lines series and background shading

Answer 7

3: two line series, and an area series

Answer 8

Don’t know

Answer 9

Start with a line chart and check the “combination” option.

Answer 10

Begin by plotting a clustered column chart, then change the blue series chart type to a line chart.

Answer 11

Begin by plotting a dual series line chart, then selecting the orange series and changing the series chart type to a bar chart.

Answer 12

Don’t know

In the chart below, how many series of data are shown?