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!

  TRUE

  FALSE

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

  Area Graph

  Pie Chart

  Line Graph

  Column Chart

 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%.

  TRUE

  FALSE

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

  Bar Graph

  Pareto Graph

  Number Graph

  Column Chart

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

  Line Graph

  Pie Chart

  Area Graph

  Column 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

  None of these options are valid

  Bar

  Line

  Pie

 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.

  Pie

  Formula Graph

  None of these options are valid

  Bar

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

  pie / line

  column / bar

  pareto / pie

  pie / bar

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

  consistent colours

  all kinds of colours

  only black

  rainbow colours

 11. Use_____________ to improve readability.

   horizontal labels

  as many labels as possible

  no labels

  vertical and top centered

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

  FALSE

  TRUE

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

  FALSE

  TRUE

 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

  bar

  pie

  line

 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

  bar

  line

  pie

  column