Quizizz Questions on Excel IF and SUM

What is the main function of the IF formula in Microsoft Excel?

• Calculate the total of numbers in a range

• Return a value based on a specific condition

• Sort data alphabetically

• Insert a new row in the worksheet

What is the correct syntax for the IF formula?

• =IF(condition, if_true, if_false)

• =IF(if_true, if_false, condition)

• =IF(if_false, condition, if_true)

• =IF(if_true)

If you want to use a nested IF formula, what should you do?

• Use multiple IFs in one formula

• Use the SUM formula inside IF

• Insert a pivot table

• Insert a chart in the worksheet

What is the result of the following formula: =IF(5>3, 'Yes', 'No')?

• No

• Yes

• TRUE

• FALSE

What is the main function of the SUM formula in Microsoft Excel?

• Display the average of numbers in a range

• Add all numbers in a range

• Multiply numbers in a range

• Compare two ranges of numbers

The IF formula can only be used to check one condition.

• True

• False

The SUM formula can add numbers from several ranges at once.

• True

• False

Syntax =IF(A1>10, 'Pass', 'Fail') is a valid syntax.

• True

• False

You can use the IF formula within the SUM formula.

• True

• False

If the condition in the IF formula is false, Excel will always display the number 0.

• True

• False