1) What does SUMIF do? a) Rounds numbers b) Checks conditions c) Counts text d) Adds numbers if met the condition 2) What is the syntax for IF? a) IF(range, sum) b) IF(logical_test, true, false) c) IF(number, digits) d) IF(criteria, sum) 3) What does COUNT do? a) Adds numbers b) Counts numbers c) Rounds numbers d) Counts text 4) What does COUNTA count? a) Non-empty cells b) Only text c) Empty cells d) Only numbers 5) What is the syntax for ROUND? a) ROUND(range, sum) b) ROUND(logical_test, true) c) ROUND(criteria, sum) d) ROUND(number,num_digits) 6) What does IF return if true? a) Criteria b) Sum_range c) Value_if_true d) Value_if_false 7) What does IF check? a) Numbers b) Conditions c) Ranges d) Text 8) What is COUNT's syntax? a) =ROUND(A1:A4) b) =COUNT(A1:A4) c) =SUMIF(A1:A4) d) =IF(A1:A4)

Excel Functions Game 2

Print
Embed

Leaderboard

Visual style

Options

Switch template

Continue editing: ?