Czech version
logolink

<Back to the lesson list

Excel - task num.2: Results of remote run

office

RANK function, COUNT, NUMBER2, TODAY, NOW, calculating the runtime of individual athletes and their assembly sequence

The main aim of this lesson is to familiarize students with the basic functions of RANK, COUNT, NUMBER2, TODAY, NOW, and calculating the time course of individual athletes and their assembly sequence.
Tasks:
Build a score table of woman and men:

  1. Calculate the time course of individual athletes.
  2. Determine the order at the finish line - using the RANK (remember the absolute addressing).
  3. Sort the table by ascending order and the first three places indicate color by using conditional formatting.
  4. Use the insert today's date.
  5. Determine how many riders are on the starting list - using NUMBER or NUMBER2.
  6. Determine what is the difference between the function and NUMBER and NUMBER2 .

All tasks are in the attached file: zadani-prikladu-2-en.xls

webdesign, xhtml, css, php - Mgr. Michal Mikláš