1 For a range named \'Data\', the formula below would return: {AVERAGE(IF(Data<>

Question

1 For a range named 'Data', the formula below would return: {AVERAGE(IF(Data<>0,Data))} the average of all values in Data the average of each array in Data the average value of all cells in Data an array of the average values in Data none of the above 1 For a range named 'Data', the formula below would return: {AVERAGE(IF(Data<>0,Data))} the average of all values in Data the average of each array in Data the average value of all cells in Data an array of the average values in Data none of the above

Explanation / Answer

{AVERAGE(IF(Data<>0,Data))}

This formula creates a new array which has all non-zero values in the range . Then the average function is performed

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.