Conditional Formatting - Excel

What do all formulas start with?

• Formula Name (e.g. SUM, AVERAGE)

• Comparison (e.g. >= 9)

• Equals (=)

• Cell Reference (e.g. A6)

What are the expected values in an IF function?

• cell_reference, [value_if_false], [value_if_true]

• logical_test, [value_if_true], [value_if_false]

• range, criteria

• number1, number2, ...

What are the expected values in a COUNTIF function?

• cell_reference, [value_if_false], [value_if_true]

• logical_test, [value_if_true], [value_if_false]

• range, criteria

• number1, number2, ...

What are the expected values in an AVERAGE function?

• cell_reference, [value_if_false], [value_if_true]

• logical_test, [value_if_true], [value_if_false]

• range, criteria

• number1, number2, ...

What function would be used to find the largest value in a certain range?

• =LARGEST

• =GREATEST

• =MAXIMUM

• =MAX

What function would be used to find the smallest value in a certain range?

• =SMALLEST

• =MINIMUM

• =MIN

• =LEASTMAX

What is the problem with the statement MAX(2A:8F)?

• There should be a semicolon (;) not a colon

• There should be an equals sign (=)

• The formula should be MAXIMUM, not MAX

• The cell references should have the letter before the number (A2:F8)

How could you simplify the statement =A1+A2+A3+A4+A5+A6

• =SUM(A1:A6)

• =SUM(A1,A6)

• =SUM(A1,A2,A3,A4,A5,A6)

• =A1:A6

How could you count the amount of cells that contained the word "Hello" in the range A4:F9?

• =IF(A4:F9 = "Hello","True","False")

• =COUNT(A4:A9 = Hello)

• =SUM(A4:F9,"Hello")

• =COUNTIF(A4:F9,"Hello")

What is the problem with the statement COUNTIF(A2+A3+B2+B3, Correct)?

• There should be a colon rather than multiple addition signs (A2:B3)

• There should be an equals sign (=)

• The formula is spelled incorrectly

• There should be speech marks around the word "Correct"