Enter the following formula, without quotes, into the cell: "=MEDIAN(A:A)". Press "Enter" and the median of your set of numbers will appear in the cell. Click cell B3.

The first function anyone should know tells Excel to carry out basic arithmetic. Let’s say you wanted the numbers in cell A2 and cell B2 to be added together in cell C2. All you’d do is enter ...