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?

Supporting image for quiz question

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

3: three lines series and background shading

Answer 6

4: three lines series and an area series

Answer 7

3: two line series, and an area series

Answer 8

Don’t know

Answer 9

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

Answer 10

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

Answer 11

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

Answer 12

Don’t know

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