ou have a formula in cell B$2$ as below:

$=$IFERROR$($VLOOKUP$($A$2,$ $D$$1$:$E$$10,2,$ FALSE$)/$ C$2,$ "Error"$).$

Assume C$2$ contains $0,$ and there is no matching value in column D$.$ Which of the following statements are correct? Check all that apply. $(2$ points$)$

$$

Check All That Apply

The formula will return #DIV$/0!$ error due to division by zero.

The formula will return #DIV$/0!$ error due to division by zero. Correct

The IFERROR function will handle the #DIV$/0!$ error and return "Error".The IFERROR function will handle the #DIV$/0!$ error and return "Error". Correct

Changing $D$$1$:$E$$10$ to D$1$:E$10$ in the VLOOKUP range will result in a #REF! error if you copy the formula to another sheet.Changing $D$$1$:$E$$10$ to D$1$:E$10$ in the VLOOKUP range will result in a #REF! error if you copy the formula to another sheet. Incorrect

If the lookup value in A$2$ is not found, VLOOKUP will return #N$/$A$,$ which IFERROR will handle.If the lookup value in A$2$ is not found, VLOOKUP will return #N$/$A$,$ which IFERROR will handle. Correct

The formula $=$IFERROR$($VLOOKUP$($A$2,$ D$1$:E$10,2,$ FALSE$)/$ $C$$2,$ "Error"$)$ will also handle a division by zero error similarly.The formula $=$IFERROR$($VLOOKUP$($A$2,$ D$1$:E$10,2,$ FALSE$)/$ $C$$2,$ "Error"$)$ will also handle a division by zero error similarly. Correct