Question & Answer: For a range named 'Data', the formula bel…..

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

Expert 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

Still stressed from student homework?

Get quality assistance from academic writers!

Order now