Copyright

Create a Chart in Excel Chapter Exam

Exam Instructions:

Choose your answers to the questions and click 'Next' to see the next set of questions. You can skip questions if you would like and come back to them later with the yellow "Go To First Skipped Question" button. When you have completed the practice exam, a green submit button will appear. Click it to see your results. Good luck!

Page 1

Question 1 1. What is the first step to switching rows and columns in an Excel chart?

Question 2 2. In this lesson, we quickly reviewed how to insert a new chart. Which answers below best describes the basic steps of adding a chart to your worksheet?

Question 3 3. What is the first step in creating a chart?

Question 4 4. Which answers BEST describes the y-axis in an Excel chart?

Question 5 5. In order for the Quick Analysis tool to appear, what step must you take first?

Page 2

Question 6 6. After inserting a new chart to your Excel worksheet, Chart Tools appears as a new tab in the ribbon. The menu contains 5 grouping of commands. Which group below is NOT one of the 5 grouping of commands?

Question 7 7. Which of the following are examples of analytic elements you can add to a worksheet?

Question 8 8. There are several different types of charts in Excel. Which two are the most frequently used?

Question 9 9. Under which ribbon menu or tab will you find the chart type commands?

Question 10 10. Where will you find the Quick Analysis tool?

Page 3

Question 11 11. Which answer best describes a chart?

Question 12 12. After inserting a new chart, you will notice a new menu in the ribbon. What is the new ribbon menu called?

Question 13 13. Which answer best describes a graph?

Question 14 14. What is the name of the command that allows you to switch the category and series in an Excel chart?

Question 15 15. What key element is represented in the image below?

Page 4

Question 16 16. You just created a new Bar chart, but you are not satisfied with the way it looks. What steps do you take in order to change your Bar chart to a Column chart?

Question 17 17. When using the Quick Analysis tool, you have five different types of elements. Which of the following is NOT available using the Quick Analysis tool?

Question 18 18. Which of the following answers are different types of charts?

Question 19 19. Which image below represents the Quick Analysis tool command?

Question 20 20. Which answers BEST describes the x-axis in an Excel chart?

Create a Chart in Excel Chapter Exam Instructions

Choose your answers to the questions and click 'Next' to see the next set of questions. You can skip questions if you would like and come back to them later with the yellow "Go To First Skipped Question" button. When you have completed the practice exam, a green submit button will appear. Click it to see your results. Good luck!

Intro to Excel: Essential Training & Tutorials  /  Business Courses
Support