Microsoft Excel 2016 - Other Common Functions

This guide will show you how to perform various other common functions within Excel.



The Rank function gives a numerical ranking to each set of data depending on its place in a certain column.
  1. In the desired cell, type =RANK(X#, 1:1). The X# represents the the cell being ranked.
  2. To copy this formula to the other cells, hover the cursor over the bottom right cursor of the cell until the cursor turns into the black/thin +. 
  3. Then, left click and drag the formula into the cells which the formula should go into. 


The median function finds the median number in a set of data.

Standard Deviation

The standard deviation function provides the standard deviation for a set of data.

If you need further assistance please contact the Information Technology Help Desk at 920-424-3020 or