1) What does the '>' symbol represent? a) Greater than b) Less than 2) Which number is >5? a) 2 b) 7 3) What symbol do we use for an absolute cell reference? a) * b) £ c) ! d) $ 4) Which function would you use to work out the highest value in a range of cells? a) =MIN() b) =COUNT() c) =MAX() d) =COUNTA() 5) Which number would meet this criteria: >= 100? a) 20 b) 100 c) 75 d) None 6) Which function would you use to work out the total of a range of cells? a) Autosum b) =(A1+A2+A3*A4) c) =Sumif() d) =Count() 7) What does '<' represent? a) Less than b) Greater than 8) Which function would you use to count how many cells have text in a range of cells? a) =Count() b) =Average() c) =Sum() d) =CountA() 9) Which number is <10? a) 2 b) 11 10) Which function would you use to show the smallest value in a range of cells a) =Max() b) =Min() c) =count() d) =sum()

Operator Knowledge Check

by
Print
Embed

Leaderboard

Visual style

Options

Switch template

Continue editing: ?