MASTERING EXCEL CHARTS- SECTION 04 REVIEW QUIZ

True or False? It’s usually better to add the elements you’d like to see in a chart first, then add formulas and styles.

True

False

Correct! It's best practice to add the elements you’d like to see in a chart first, then add formulas and styles after you have the chart the way you like it. That way you do not have to keep reapplying formulas and styles when changes are made.

Incorrect, that statement is true. It's best practice to add the elements you’d like to see in a chart first, then add formulas and styles after you have the chart the way you like it. That way you do not have to keep reapplying formulas and styles when changes are made.

What's the best action to take if the data labels on a chart are too crowded?

Delete some labels

Go into LABEL OPTIONS and click on LEGEND KEY

Click on SHOW LEADER LINES in the LABEL OPTIONS. Then grab a label from that group and drag it vertically away from the bar to add some space

Incorrect, you may need those labels so deleting them is not the best way to handle this situation.

Incorrect, adding a LEGEND KEY will add a color coded square next to your data label so you are adding more info to an already crowded space.

Correct! If the data labels on a chart get too crowded, click on SHOW LEADER LINES in the LABEL OPTIONS. Then grab a label from that group and drag it vertically away from the bar to add some space.

Which chart element helps you view and understand the information belonging to the plot lines?

Gridlines

Legend

Error Bars

Chart title

Incorrect. Gridlines allow the viewers eyes to connect with the information being displayed, horizontally, vertically, or both.

Correct! A legend helps you view and understand the information belonging to the plot lines.

Incorrect. Error bars help you see how much a statistic deviates from the norm.

Incorrect. A chart title lets a reader know the title of a chart.

{"name":"MASTERING EXCEL CHARTS- SECTION 04 REVIEW QUIZ", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"Basics of Tax Course, What is your full name?, What color is an orange?","img":"https://www.quiz-maker.com/3012/images/ogquiz.png"}