Question $6-$ Assuming all fields $($columns$)$ are named with the values in the first row, which formula

would you use to find the median SALE PRICE of properties in SOUNDVIEW?

a$)=$MEDIAN$($XLOOKUP$("$SOUNDVIEW$",$NEIGHBORHOOD, SALE$\_$PRICE$))$

b$)=$MEDIAN$($IF$($NEIGHBORHOOD$=$"SOUNDVIEW", K$2$:K$31))$

c$)=$MEDIAN$($FIND$("$SOUNDVIEW$",$NEIGHBORHOOD, SALE$\_$PRICE$))$

d$)=$MEDIAN$($SALE$\_$PRICE, IF$($NEIGHBORHOOD$=$"SOUNDVIEW"$))$

e$)$ None of the above formulas would return the correct answer

Question $7-$ Which formula would you use to find how many properties have commercial units?

a$)$ G$2$:G$31)$

b$)=$COUNTA$($G$2$:G$31,">0")$

c$)=$NOT$(COUNTBLANK(G2$:$G31))$

d$)=$ COUNTIF$($G$2$:G$31,">0")$

e$)$ None of the above formulas would return the correct answer

Question $8-$ Which formula would you use to label the month for property No $1$ as a three$-$letter symbol $($i$.$e$.$

JAN$)$ text format?

a$)$ MONTH$($L$2),"$MMM$")$

b$)$ MONTH$($L$2))$

c$)=$TExT$(MONTH(L2))$

d$)=$CONVERT$($MONTH$($L$2),"$MMM$")$

e$)=$DATE$(=$TEXT$($MONTH$($L$2),"$MMM$"))$

Question $9-$ Assuming all fields $($columns$)$ are named with the values in the first row, which formula

would return TRUE if the SALE PRICE is above average?

a$)=$IF$($K$2\{$:$>$AVERAGE$(SAL{E}_D$ATE$),$TRUE$)$$$2,341,975\mathrm{.}002016-10-280$:$00=IF(K2>$AVERAGE$(SAL{E}_D$ATE$),,$TRUE$)$

$c$