Creating Histograms, Box, Scatter & Dot Plots in Excel

Instructions:

Choose an answer and hit 'next'. You will receive your score and answers at the end.

question 1 of 3

What menu option is used in Excel for creating graphs and plots of data?

Create Your Account To Take This Quiz

As a member, you'll also get unlimited access to over 79,000 lessons in math, English, science, history, and more. Plus, get practice tests, quizzes, and personalized coaching to help you succeed.

Try it risk-free
Try it risk-free for 30 days. Cancel anytime
Already registered? Log in here for access

1. In Excel, ''Column'' or ''Bar'' refers to what type of statistical data display?

2. Once a plot has been created, how do you access all of the display options for that plot?

Create your account to access this entire worksheet
A Premium account gives you access to all lesson, practice exams, quizzes & worksheets
Access to all video lessons
Quizzes, practice exams & worksheets
Certificate of Completion
Access to instructors
Create an account to get started Create Account

About This Quiz & Worksheet

How well you know the processes involved in creating histograms, scatter, dot and box plots in Excel will be tested when you take this short quiz. Questions address subjects including how to access the display options for a plot and the easiest way to shift between basic plot types.

Quiz & Worksheet Goals

Our quiz and worksheet is a helpful way to see if you understand:

  • Which Excel menu option is used for creating graphs and plots of data
  • The type of statistical data display referred to in Excel as ''column'' or ''bar''
  • How you access all the display options for a plot once it's been created
  • Which data attribute is not easily noticeable in a 100% stacked histogram
  • The easiest way to shift between basic plot types in Excel

Skills Practiced

  • Knowledge application - use your knowledge to answer questions about which menu option is used for created data plots and graphs
  • Information recall - access the knowledge you've gained regarding the data attribute not easily noticeable in a 100% stacked histogram
  • Reading comprehension - ensure that you draw the most important information from the related lesson about creating scatter, box and dot plots and histograms in Excel

Additional Learning

Work through our lesson called Creating Histograms, Box, Scatter & Dot Plots in Excel at your own pace to learn more about this topic. It's been designed by professionals to assist you in achieving these objectives:

  • Outline the first step in creating a chart
  • Differentiate between a stacked column and a clustered column histogram
  • Detail a scenario in which a line plot would be the best choice for presenting data
Support