Question $11-$ Assuming all fields $($columns$)$ are named with the values in the first row, what would this

Excel formula $=$COUNTIFS$($SALE$\_$PRICE,"$>=100000",$GROSS$\_$SQUARE$\_$FEET,"$>=10000")$ return?

a$)2$

b$)1$

c$)5$

d$)7$

e$)0$

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

formula would return the value $1633?$

a$),$ LAND$\_$SQUARE$\_$FEET, LAND$\_$SQUARE$\_$FEET$)$

b$)=x\frac{L}{O}O$ KUP$(A2,NO,LAN{D}_{S}QUAR{E}_F$EET$)$

c$)=$XLOOKUP$("153$ AVENUE B$",$ADDRESS,LAND$\_$SQUARE$\_$FEET$)$

d$)$ a$),$ b$)$ and c$)$

e$)$ b$),$ c$)$

Question $13-$ Which of the following Excel function$($s$)/$feature$($s$)$ only applies to numbers?

a$)$ SORT$()$

b$)$ COUNT$()$

c$)SM()$

d$)$ a$,$ b$,$ and c$)$

e$)$ b$)$ and c$)$

Question $14-$ Which of the following Excel formula$($s$)$ would return the error message #N$/$A$.$

a$)=x\frac{L}{O}OKP(MAx(K2$:$K31),K2$:$K31,A2$:$A31)$

b$)=x\frac{L}{O}O$ KUP$(MIN(K2$:$H31),K2$:$K31,A2$:$A31)$

c$)=x\frac{L}{O}O$ KUP$(LARGE(D2$:$D31,2),F2$:$F31,D2$:$D31)$

d$)$ None of the above formulas would return the #N$/$A error message

e$)$ a$)$ and c$)$ returns the #N$/$A error message

Question $15-$ Which of the following formula$($s$)$ would return $"153$ AVENUE B in ALPHABET CITY"

a$)=$MERGE$($E$2,"",$C$2)$

b$)=$CONCAT$($E$2,"$ in $",$C$2)$

c$)=$MERGE$($E$2,"",$ in$,"",$ C$2)$

d$)$ b$)$ and c$)$

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