The formula to calculate the average of a given range of data from cell B2…