In cell i4 enter a formula using the averageif – Embarking on the exploration of AVERAGEIF, this guide delves into the depths of this powerful function, unraveling its capabilities and…