Question $1$

The formula $\text{'}=$vlookup$(100036,$CustInfo,$4,$false$)\text{'}$ is entered in a cell. Which of the following is NOT a reason it might return an error?

Your workbook contains no range named 'CustInfo'

The range 'CustInfo' contains no entry with $100036$ in the first column

The entry with $100036$ in the first column has no data in column $4$

The range 'CustInfo' contains less than $4$ columns

Any of the above reasons would return an error

$0\mathrm{.}9$ points $$

Question $2$

The AND formula takes a list of Booleans and returns TRUE if all of them are true, and FALSE otherwise.

True

False

$0\mathrm{.}9$ points $$

Question $3$

You enter a cell reference into row $21,$ column E$.$ You want to copy paste the formula so that, when pasted, it always refers to row $21,$ but floats which column it refers to$.$ Which of the following references is appropriate?

$E$$21$

$E$21$

E$$21$

E$21$

none of the above