Challenge - 5 Problems
Data Visual Master
Get all challenges correct to earn this badge!
Test your skills under time pressure!
📊 Formula Result
intermediate2:00remaining
What is the output of this formula for total sales?
You have sales data in cells A2:A6: 100, 200, 150, 300, 250. What is the result of the formula
=SUM(A2:A6)?Google Sheets
=SUM(A2:A6)
Attempts:
2 left
💡 Hint
Add all the numbers in the range A2 to A6.
✗ Incorrect
The SUM function adds all numbers in the range. 100 + 200 + 150 + 300 + 250 = 1000.
❓ Function Choice
intermediate2:00remaining
Which function helps create a chart from data?
You want to make a visual chart from sales data in Google Sheets. Which function or feature should you use?
Attempts:
2 left
💡 Hint
Charts are created from the menu, not by a formula.
✗ Incorrect
In Google Sheets, charts are inserted using the Insert > Chart menu, not by a formula.
🎯 Scenario
advanced2:00remaining
Which chart type best shows parts of a whole?
You have sales data for different products and want to show how each product contributes to total sales visually. Which chart type is best?
Attempts:
2 left
💡 Hint
Think about showing percentages of a total.
✗ Incorrect
Pie charts show parts of a whole clearly by dividing a circle into slices.
❓ data_analysis
advanced2:00remaining
What does this chart show about monthly sales?
You have a line chart showing monthly sales increasing steadily from January to June. What does this visual tell you?
Attempts:
2 left
💡 Hint
Look at the trend line direction.
✗ Incorrect
A line chart with an upward slope shows sales increasing steadily over time.
🧠 Conceptual
expert2:00remaining
Why do charts help understand data better than raw numbers?
Which reason best explains why charts make data easier to understand compared to just numbers in cells?
Attempts:
2 left
💡 Hint
Think about how visuals help your brain spot trends.
✗ Incorrect
Charts use colors, shapes, and layouts to help you see patterns and trends faster than reading numbers.