What is the function of the IF function in Excel...? Mcqs

✅ Correct Answer: To perform a logical test and return a value based on the result

✅ Correct Answer: To add up a range of cells

✅ Correct Answer: To find a value in a table based on a matching value in the first column

✅ Correct Answer: organized data

✅ Correct Answer: To perform a vertical lookup and return a value based on a specified criteria

✅ Correct Answer: COUNT

✅ Correct Answer: AVG

✅ Correct Answer: MAX

✅ Correct Answer: MAX

✅ Correct Answer: Performing logical comparisons

✅ Correct Answer: Searches for a value in the column

✅ Correct Answer: Formula

✅ Correct Answer: To add up a range of cells

✅ Correct Answer: Performing logical comparisons

✅ Correct Answer: Searches for a value in a column and returns a value in the same row

✅ Correct Answer: AVG

✅ Correct Answer: AVG