The function AVERAGE in Excel calculates the average of a range of data. If you enter a dataset of 20 rows and 5 columns. The Excel function AVERAGE will give you one number, the average of the whole dataset. Create a user defined function to calculate column averages. So for an input dataset of 20 rows and 5 columns. The output should have 5 numbers, each number is the average of a column in the dataset.