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

Answer 2

The logical functions with their descriptions are

1. IF -> tests for a certain condition and returns one of two values depending on whether the condition is true or false
2. AND -> returns TRUE only if all the values specified are true
3. COUNTIF -> returns the number of cells, in a given range, that satisfies a specific condition
4. SUMIF -> tests for a certain condition and returns the sum of values in a given range of cells

Logical functions in Microsoft Excel are used to make decision depending on the result of the condition or conditions that are being tested.

The COUNTIF and the SUMIF functions are used to test for a condition and then return the count and return the sum of arguments if the condition is true, respectively

The AND function takes two inputs, and returns true if both inputs are true; otherwise, it returns false

Read more about logical functions at:

https://brainly.com/question/19703259