QUESTION $9$

The following data is entered in the cells of an Excel sheet

Range from $B1$ to $B7$:$8,9,5,7,8,12,8$

Range from $C1$ to $C7$:$7,6,7,8,4,3,4$

What will the output of the $=$AVERAGEIF$($B$1$:B$7,8,$C$1$:C$7)$ function?

a$.3$

b$.5$

C$.8$

d$.9$

e$.11$