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))}

Don't use plagiarized sources. Get Your Custom Essay on
Question & Answer: For a range named 'Data', the formula bel…..
GET AN ESSAY WRITTEN FOR YOU FROM AS LOW AS $13/PAGE
Order Essay

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!