In order for the AND function to yield TRUE all the argument

In order for the AND function to yield TRUE all the arguments must be true.

Which function should you use when counting empty cells.

Solution

In order for the AND function to yield TRUE all the arguments must be true.

Answer: True

(An AND function returns trues only if all the arguments are true, if any one argument is false it return False)

Which function should you use when counting empty cells?

Answer: COUNTBLANK

(The COUNTBLANK function returns the number of blank cells within a specified range. Syntax: COUNTBLANK (range), here range represent the range up to which we need to check for blank cells, legal values for range are B1:B5, here cells from B1 to B5 are checked and the number of blank cells within this range is returned)