Question

Which of the following describes the result of AND function in Excel

• A. It returns TRUE if any of its arguments are true
• B. It returns a numerical value indicating the count of TRUE argument
• C. It returns TRUE only if all the conditions are true
• D. It always returns the value of the last logical argument evaluated

Answer 1

Answer:

C. It returns TRUE only if all the conditions are true

It returns TRUE only if all the conditions are true