In cell K$1,$ type heading: "Decision". In cell K$2,$ write an IF formula which says if price is less than or equal to $$350,000,$ calculate $30\%$ of price, otherwise calculate $15\%$ of price. Copy this formula down to the other cells.

Which is the best$/$closest answer found in cell K$5?$

Question $1$ options:

Between $97,000$ and $98,000$

Between $40,000$ and $49,000$

Between $60,000$ and $97,000$

Between $98,000$ and $100,000$

Question $2(2$ points$)$

Saved

Listen

In Cell L$1,$ type heading "Square Tax". In cell L$2,$ write a nested if to say $"$if sq$\_$ft is $<700,$ let Square Tax be $50,$ else if sq$\_$ft is $<1300,$ let Square Tax be $100,$ else if sq$\_$ft is $<2000,$ let Square Tax be $150,$ else if sq$\_$ft is $<2500,$ let Square Tax be $200,$ otherwise, let Square Tax be $250.$ Copy the formula to all cells below that. What value is found in L$2?$

Question $2$ options:

$250$

$100$

$200$

$150$

Question $3(2$ points$)$

Saved

Listen

In Cell H$311,$ write an AverageIF formula, to find the average square feet $($sq$\_$ft$)$ if home$\_$size is "Standard". What's the closest answer?

Question $3$ options:

Greater than $2400$

Less than $1800$

Between $1800$ and $2399$

Greater than $2500$

Question $4(2$ points$)$

Saved

Listen

Create a subtotal on column called Type, and provide the average price. What's the average price of Residential?

Go back to subtotal settings, and select "Remove All" button to reset data before attempting the next question.

Question $4$ options:

Between $200,000$ and $300,000$

Less than $100,000$

Greater than $300,000$

Between $100,000$ and $200,000$

Question $5(2$ points$)$

Listen

Use a multi$-$level sort. Sort on home$\_$size in descending alphabetical order and then on price in descending order. The street address for the last record is $?$

Question $5$ options:

$2981$ Wringer Dr

$8208$ Woodyard Way

$7921$ Doe Trail Way

None of the above