Question $10$

What will happen if$,$ in an IF function, you accidentally omit the quotes from the value$\_$if$\_$true and

value$\_$if$\_$false arguments as follows?

$,$ eligible, ineligible$)$

Excel will not allow you to complete the function

Excel will automatically put quotes around these for you and the function will execute without error

Excel will default to putting in zero $(0)$ for the if$\_$value$\_$true argument and zero $(0)$ for the

if$\_$value$\_$false argument when the condition is met

Excel will look for a range named eligible or ineligible $($depending on which condition was met$)$ and

either returns the value from that range or gives a #NAME? error if the named range does not exist