This function calculates the average from a list of numbers. Arguments can either be numbers or names, ranges, or cell references that contain numbers.Logical values and text representations of numbers…