Question $1-$ What function would you use to count the number of entries in the 'YEAR BUILT' column?

a$)$ COUNT$()$

b$)$ COUNTA$()$

c$)$ SUM$()$

d$)$ COUNTIF

e$)$ COUNTIF$($NOT BLANK$)$

Question $2-$ What function would you use to calculate the total sales value for the $30$ properties?

a$)$ AVERAGE$()$

b$)$ SUM$()$

c$)$ COUNT$()$

d$)$ SUMIF$()$

e$)$ TOTAL$()$

Question $3-$ How would you calculate the average GROSS SQUARE FEET for the "ALPHABET CITY"

NEIGHBORHOOD?

a$)$ Use $=$AVERAGE$(12$:$131)$ with a filter for the 'NEIGHBORHOOD' column

b$)$ Use $=$AVERAGEIF$($C$2$:C$31,$"ALPHABET CITY",$12$:$131)$

c$)$ Use $=$AVERAGE$($H$2$:H$31)$ and COUNTIF$($E$2$:E$31,$"Platform"$)$ separately and divide the results

d$)$ All the above methods would work

e$)$ None of the above methods would work

Question $4-$ Assuming all fields $($columns$)$ are named with the values in the first row $($using the Create

from selection $/$ Top Row$),$ which formula can be used to find the minimum SALE PRICE?

a$)=$MIN$($SALE$\_$PRICE$)$

b$)=$MIN$("$SALE PRICE"$)$

c$)=$SMALL$($SALE$\_$PRICE$)$

d$)=$SMALL$("$SALE PRICE"$)$

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

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

would you use to find the sale price of the property located at $"125$ AMSTERDAM AVENUE"?

a$)=$VLOOKUP$("125$ AMSTERDAM AVENUE",ADDRESS,SALE$\_$PRICE$)$

b$)=$XLOOKUP$("125$ AMSTERDAM AVENUE",ADDRESS,SALE$\_$PRICE$)$

c$)=$FIND$("125$ AMSTERDAM AVENUE",ADDRESS,SALE$\_$PRICE$)$

d$)=$XLOOKUP$("125$ AMSTERDAM AVENUE",SALE$\_$PRICE, ADDRESS$)$

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