To apply data validation rules to a selected cell or range, head to the "Data" tab on the ribbon, and click the top half of ...
However, this might not always give you an accurate average, which is where functions like GEOMEAN and HARMEAN come in. The ...