Preview

08 - Creating Charts in Excel

 1. Charts give you a ________________ of your data in a way that creates maximum impact on your audience.

  automated calculation

  text based

  numerical analysis

  visual representation

 2. You can select the data you want in the chart and press ALT + F1 to create a chart immediately.
Note: If you haven't tried this, please do!

  FALSE

  TRUE

 3. The chart in the image below is a:
chart_in_excel_question1.png

  Column Chart

  Pie Chart

  Line Graph

  Area Graph

 4. For a pie chart, it is good practice to ensure you have as many categories as possible and also check the slice values add up to just 50%.

  FALSE

  TRUE

 5. The chart in the image below is a:
pareto_chart_of_fast_food_chains_w640.jpeg

  Pareto Graph

  Bar Graph

  Number Graph

  Column Chart

 6. The chart in the image below is a:
Line_chart_graph_2.png

  Area Graph

  Line Graph

  Column Chart

  Pie Chart

 7. Use this type of chart to show how individual parts make up the whole of something, such as the device type used for mobile visitors to your website or total sales broken down by sales rep

  Pie

  Bar

  None of these options are valid

  Line

 8. Use this type of chart for comparing one or many value sets. This chart will easily show the low and high values in the data sets.

  Formula Graph

  Pie

  Bar

  None of these options are valid

 9. A ___________ or ______ chart is used to show a comparison among different items, or it can show a comparison of items over time.

  column / bar

  pie / bar

  pareto / pie

  pie / line

 10. Use _________________ throughout the chart, selecting accent colors to highlight meaningful data points or changes over time.

  all kinds of colours

  rainbow colours

  consistent colours

  only black

 11. Use_____________ to improve readability.

  no labels

  as many labels as possible

  vertical and top centered

   horizontal labels

 12. It is good practice to start the y-axis at 0 to appropriately reflect the values in your graph.

  TRUE

  FALSE

 13. It is not possible to show negative values on a bar chart.

  TRUE

  FALSE

 14. A ____ graph reveals trends or progress over time and can be used to show many different categories of data. You should use it when you chart a continuous data se
Note: Pick the answer that best fits the answer

  column

  line

  bar

  pie

 15. An area chart is basically a ____ chart, but the space between the x-axis and the line is filled with a color or pattern

  line

  pie

  bar

  column