0
0
Excelspreadsheet~20 mins

Chart elements (title, legend, axis labels) in Excel - Practice Problems & Coding Challenges

Choose your learning style9 modes available
Challenge - 5 Problems
🎖️
Chart Elements Master
Get all challenges correct to earn this badge!
Test your skills under time pressure!
📊 Formula Result
intermediate
2:00remaining
What is the effect of adding a chart title in Excel?

You create a bar chart from sales data. You add a chart title named "Monthly Sales". What will the chart display?

AThe chart will display "Monthly Sales" as a data label on each bar.
BThe chart will show "Monthly Sales" as the label on the vertical axis.
CThe chart will add "Monthly Sales" as a legend entry.
DThe chart will show "Monthly Sales" at the top center as the chart title.
Attempts:
2 left
💡 Hint

Think about where chart titles usually appear in Excel charts.

📊 Formula Result
intermediate
2:00remaining
What does the legend in an Excel chart represent?

You create a pie chart showing sales by product category. The legend shows colors with category names. What is the purpose of the legend?

AIt explains which color corresponds to each product category in the chart.
BIt shows the total sales amount for each category.
CIt labels the horizontal axis with category names.
DIt displays the chart title.
Attempts:
2 left
💡 Hint

Think about how colors and categories are matched in charts.

Function Choice
advanced
2:00remaining
Which Excel feature lets you add axis labels to a chart?

You want to add descriptive labels to the horizontal and vertical axes of a chart. Which Excel feature do you use?

AChart Elements button (plus icon) > Axis Titles
BInsert > Shapes > Text Box
CPage Layout > Margins
DData > Sort & Filter
Attempts:
2 left
💡 Hint

Look for the button that controls chart parts like titles and labels.

🎯 Scenario
advanced
2:00remaining
You want to remove the legend from a chart. How do you do it?

You have a column chart with a legend showing series names. You want to hide the legend without deleting the chart. What is the correct way?

ADelete the chart title text box.
BClick the Chart Elements button (plus icon) and uncheck Legend.
CRight-click the vertical axis and select Delete.
DChange the chart type to Pie Chart.
Attempts:
2 left
💡 Hint

Think about how to toggle chart parts on or off.

data_analysis
expert
2:00remaining
How many axis labels will appear on the horizontal axis if you add axis titles to this chart?

You create a line chart with monthly sales data for 12 months. You add an axis title to the horizontal axis labeled "Month". How many axis labels (not including the title) will appear on the horizontal axis?

A1 label, the axis title "Month" only
BNo labels, only the axis title appears
C12 labels, one for each month
D24 labels, two for each month
Attempts:
2 left
💡 Hint

Think about the difference between axis labels and axis title.