Peak Study Hub
Start Practice
Lookup Functions1/7

Spreadsheet practice

Complete each goal to unlock the next task.

Module progress0/7

Goal

Enter the lookup table.

Create a small grade table before practising lookups.

Steps

  1. 1Click J3.
  2. 2Type exactly "Club".
  3. 3Press Enter.
  4. 4Click K3.
  5. 5Type exactly "Coach".
  6. 6Press Enter.
  7. 7Click J4.
  8. 8Type exactly "Drama".
  9. 9Press Enter.
  10. 10Click K4.
  11. 11Type exactly "Mr Lee".
  12. 12Press Enter.
  13. 13Click J5.
  14. 14Type exactly "Robotics".
  15. 15Press Enter.
  16. 16Click K5.
  17. 17Type exactly "Ms Patel".
  18. 18Press Enter.
  19. 19Click J6.
  20. 20Type exactly "Coding".
  21. 21Press Enter.
  22. 22Click K6.
  23. 23Type exactly "Mr Obi".
  24. 24Press Enter.
  25. 25Click J7.
  26. 26Type exactly "Art".
  27. 27Press Enter.
  28. 28Click K7.
  29. 29Type exactly "Mrs Green".
  30. 30Press Enter.
0 points

Spreadsheet workspace

Loading spreadsheet engine...

Modules