For the Scores listed below, use Excel Functions to calculate the desired statistic use FORMULATEXT function to show the formula and cell references

$\backslash$table$[[$Scores$],[98],[94],[92],[92],[$N$/$A$],[90],[86],[],[84],[82],[80],[50],[50]]$

$\backslash$table$[[$Measure$,$Answer$],[$Total of all scores,$898],[$Average score,$81\mathrm{.}63636364],[$Median score,$86],[$Low score,$50],[$High score,$98],[$No$.$ of numeric cells,$11],[$No$.$ of empty cells,$1],[$No$.$ of non$-$empty cells,$12],[$No$.$ of cells containing N$/$A$,1.],[$Rounded Average score,$81\mathrm{.}64],[$Rounded Average score,$81\mathrm{.}64]]$

Enter Function or

$81\mathrm{.}63636364$

uses a NAMED reference

need to define a 'Named Range' then use the 'Named Range' in the function select the ronge, Formulas tab, Define Name use the 'Named Range' in the AVERAGE formula

Task:

For the Home costs on the Cell Ref sheet calcuate the average house cost copy the formula in column $F$

uses pointing to a different sheet cell reference