What is the purpose of the IFS function in Excel?1 pointIt replaces nested IF functions where more than one condition is tested.It combines the IF function with conditional formatting.It counts the number of cells that meet a specific criterion.It returns the sum of the cells that meet a specific criterion.

What is the purpose of the IF function in Excel?a.To perform logical tests and return one value if the condition is true and another value if it's falseb.To count the number of cells in a rangec.To calculate the average of a range of cellsd.To add up the values in a range of cells

What is the purpose of the conditional if statement within the loop?*1 pointA. To ensure that the sum variable does not exceed 10.B. To add each number unconditionally to the sum.C. To check if the current number is divisible by 2 and add it to sum if true.D. To terminate the loop if an even number is found.

Which of the following is not among the Logical functions category of excel?  IFNA IFERROR AND DAVERAGE

How many arguments does the IF Function have?

What does the "if" statement do in Python?(1 Point)It repeats a block of code until a condition is metIt defines a function in PythonIt evaluates a condition and execute code based on result.