Peak Study HubStart Practice
Charts1/9

Spreadsheet practice

Complete each goal to unlock the next task.

Module progress0/9

Goal

Create a column chart for club attendance.

The activities lead wants to compare clubs quickly, so the chart should make the tallest attendance values easy to spot.

Steps

  1. 1Click A1.
  2. 2Type exactly "Club".
  3. 3Press Enter.
  4. 4Click B1.
  5. 5Type exactly "Attendance".
  6. 6Press Enter.
  7. 7Click A2.
  8. 8Type exactly "Drama".
  9. 9Press Enter.
  10. 10Click B2.
  11. 11Type exactly "18".
  12. 12Press Enter.
  13. 13Click A3.
  14. 14Type exactly "Robotics".
  15. 15Press Enter.
  16. 16Click B3.
  17. 17Type exactly "22".
  18. 18Press Enter.
  19. 19Click A4.
  20. 20Type exactly "Coding".
  21. 21Press Enter.
  22. 22Click B4.
  23. 23Type exactly "16".
  24. 24Press Enter.
  25. 25Click A5.
  26. 26Type exactly "Art".
  27. 27Press Enter.
  28. 28Click B5.
  29. 29Type exactly "20".
  30. 30Press Enter.
  31. 31In the chart panel, set Chart type to column.
  32. 32Set Source range to A1:B5.
  33. 33Set Chart title to Club Attendance.
  34. 34Set Category label to Club.
  35. 35Set Value label to Attendance.
  36. 36Click Check my result.
0 points

Spreadsheet workspace

Loading spreadsheet engine...

Modules

Chart practice

Choose data and create a visual interpretation.

Untitled chart

A1:B5

Enter data and refresh preview