Understanding Chart Types

10 Questions | Attempts: 387
Share

SettingsSettingsSettings
Graph Quizzes & Trivia

Questions and Answers
  • 1. 
    How many types of Charts are in Excel ?
    • A. 

      9

    • B. 

      11

    • C. 

      7

  • 2. 
    Pie charts are most effective with ___________ or fewer slices.
    • A. 

      Six

    • B. 

      Seven

    • C. 

      Four

  • 3. 
    What uses vertical rectangles to compare values across categories.
    • A. 

      Clustered columns chart

    • B. 

      Clustered column chart

    • C. 

      Cluster chart

    • D. 

      Column chart

  • 4. 
    In excel, charts do not remain linked or connected to their data sources if they appear in different worksheets.
    • A. 

      True

    • B. 

      False

  • 5. 
    In pie charts with legends, it's best to make the slice colors as similar as possible.
    • A. 

      True

    • B. 

      False

  • 6. 
    You can rotate a 3D chart in only two directions: horizontally along the x-axis and vertically along the y-axis.
    • A. 

      True

    • B. 

      False

  • 7. 
    A chart that combines two or more chart types into a single graph is called a(n) _____________ chart.
    • A. 

      Compound Charts

    • B. 

      Combination Charts

    • C. 

      Normal Charts

  • 8. 
    What Excel chart feature would be most helpful if you wanted to show two disparate (very different) values on the same chart?
    • A. 

      Bubble Chart

    • B. 

      Error bars

    • C. 

      Projection

    • D. 

      Secondary axis

  • 9. 
     There are no right or wrong chart types, just ones that illustra the message you are trying to convey about your data better than others.
    • A. 

      True

    • B. 

      False

  • 10. 
    You can modify an exisiting chart?
    • A. 

      True

    • B. 

      False

Back to Top Back to top
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.