The average number is found by adding all data points and dividing by the number of data. To find the Mode or modal value Alex places the numbers in value order then counts how many of each number. Note that you dont have to sort the data yourself before you apply Median just select the range of data.
Learn how to use Microsoft Excel free online tutorial.
How to find Mean Median Mode and Standard Deviation using MS Excel. For consistency it helps to enter the number in consecutive cells in either a row or column and for. Note that you dont have to sort the data yourself before you apply Median just select the range of data. In the formula A2A17 is the range you want to median excluding zeros.