You have the following chart. What do you need to do in order to have the chart plotted with the lowest number of goals at the bottom and the highest number at the top?

Supporting image for quiz question

Answer 1

Sort the data in A4:B11 in ascending order.

Answer 2

Sort the data in A4:B11 in descending order.

Answer 3

Manually arrange the items on the chart.

Answer 4

Don’t know

Answer 5

Drag the borders of the chart to make it taller.

Answer 6

Select the player names on the chart, press = , then select A5:A11 to re-link them.

Answer 7

Change the font size for cells A5:A11 to something smaller.

Answer 8

Don’t know

Answer 9

Select the bars > Chart > Format > Add Data Labels

Answer 10

Right click any bar > Add Data Labels

Answer 11

Nothing. The Numbers are added automatically when the chart is created.

Answer 12

Don’t know

You have produced the following chart, but realized that not all of the names are showing in the chart. How would you fix it?