Question

Match each logical function with its description. AND COUNTIF SUMIF IF tests for a certain condition and returns one of two values depending on whether the condition is true or false arrowRight returns TRUE only if all the values specified are true arrowRight returns the number of cells, in a given range, that satisfies a specific condition arrowRight tests for a certain condition and returns the sum of values in a given range of cells

Answer 1

1. IF
2. AND
3. COUNTIF
4. SUMIF