1) Which one is a cell reference? a) 8A b) 8DH c) 0A d) 3E e) A8 2) What does the term cell reference mean? a) The formula used b) The colour of a cell c) The data in a cell d) The location of a cell 3) What will this formatting icon do? a) Change the colour of the text b) Change the colour of the cell c) Change the colour of the background d) Change the colour of the column e) Change the colour of the row 4) =B3/B8 Will do what? a) Add b) Subtract c) Divide d) Multiply 5) What function can I use to add 2 or more cells together a) SUM b) MAX c) Average d) '+' sign e) '/' sign 6) What does this +icon do? a) Add another column b) Add another cell c) Add another row d) Add another worksheet e) Add another heading 7) What must all formulas begin with? a) = b) Cell reference e.g B2 c) SUM d) Function 8) =A2*A6 will do what? a) Add b) Subtract c) Divide d) Multiply 9) What does the =MAX formula do? a) Finds the highest number in a range. b) finds the lowest number in a range. 10) What does the =MIN formula do? a) Finds the lowest number in a range b) Finds the highest number in a range

Leaderboard

Estilo ng visual

Mga pagpipilian

Magpalit ng template

Ibalik ng awtomatikong pag-save: ?