If you move or delete an endpoint worksheet in a $3-$D reference $\_\_\_\_\_\_\_\_.$

You developed a sales quotation workbook that you will share with your sales staff to help them quote prices. It shows #DIV$/0$ in some cells where there are empty quantities in a column. Which function would handle the error and replace it with another value?

IFERROR

ERRORHANDLER

ERRORTRACK

ERRRORRETURN

Excel adjusts the $3-$D references to reflect the change

Excel opens a dialog box to correct the changed reference

you must update the reference

nothing changes