IF function used in Excel for _____...? Mcqs

✅ Correct Answer: Performing logical comparisons

✅ Correct Answer: 1048576

✅ Correct Answer: Rectangular box

✅ Correct Answer: 400%

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

✅ Correct Answer: Shift + F11

✅ Correct Answer: =PRODUCT()

✅ Correct Answer: Tab

✅ Correct Answer: You can not set page border in Excel

✅ Correct Answer: Formula

✅ Correct Answer: Boolean

✅ Correct Answer: 10 minutes

✅ Correct Answer: organized data

✅ Correct Answer: VLOOKUP

✅ Correct Answer: To add up a range of cells

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

✅ Correct Answer: Worksheet

✅ Correct Answer: AVG

✅ Correct Answer: AVG

✅ Correct Answer: Searches for a value in the column

✅ Correct Answer: Ctrl+9

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

✅ Correct Answer: To add up a range of cells

✅ Correct Answer: MAX

✅ Correct Answer: MAX

✅ Correct Answer: AVG

✅ Correct Answer: Function

✅ Correct Answer: COUNT

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

✅ Correct Answer: =SUM()

✅ Correct Answer: =AVERAGE (B3:B6)

✅ Correct Answer: Joystick