Font size
WorksheetsConditional Formatting - Excel
Total questions: 22
Worksheet time: 11mins
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"
How would you change all cells containing the word "Pass" to green?
=COUNTIF
Conditional formatting
=IF
Cell Style
How do you combine cells B3, C3 and D3 into one?
Merge & Centre
Combine Cells
=MERGE(B3:D3)
=COMBINE(B3:D3)
How have the coloured flag icons been added to indicate how well the students have done in their exams?
Conditional Formatting (Colour Scales)
Conditional Formatting (Data Bars)
Conditional Formatting (Icon Sets)
Conditional Formatting (Formatting Rules)
How have the coloured cells been added to indicate how well the students have done in their exams?
Conditional Formatting (Colour Scales)
Conditional Formatting (Data Bars)
Conditional Formatting (Icon Sets)
Conditional Formatting (Formatting Rules)
How have the bars been added to indicate how well the students have done in their exams?
Conditional Formatting (Colour Scales)
Conditional Formatting (Data Bars)
Conditional Formatting (Icon Sets)
Conditional Formatting (Formatting Rules)
How could you complete this colour-by-numbers on Excel?
Conditional Formatting (Colour Scales)
Conditional Formatting (Data Bars)
Conditional Formatting (Icon Sets)
Conditional Formatting (Formatting Rules) / Fill Colour
How could you create a scoring system for an Excel quiz?
=COUNT(cell_range, "Correct")
=IF("Correct",Score)
=SUM(cell_range)
=COUNTIF(cell_range, "Correct")
What are the best ways to make the text remain within one cell?
Wrap Text
Merge & Centre
Make the font really small
Write less
Select all the ways to add up the three numbers shown
=SUM(A6:C6)
=A6+B3+C5
=MAX(A6,B3,C5)
=SUM(A6,B3,C5)
How could you calculate the average score for the summer test?
AV(3F:10F)
AVE(3F:10F)
=AVE(F3:F10)
=AVERAGE(F3:F10)
How could you calculate the smallest score for the summer test?
SMALLEST(3F:10F)
NOTMAX(3F:10F)
=MIN(F3:F10)
=MINIMUM(F3:F10)
How could you calculate the largest score for the summer test?
=MAX(F3:F10)
=MAXIMUM(3F:10F)
=GREATEST(F3:F10)
LARGEST(F3:F10)
