Check your understanding

Answer all 5 questions, then check your answers. You need 4 correct to pass and unlock your certificate. You can try as many times as you like.

Question 1 of 5What does the cell address C4 refer to?

Row C, column 4Column C, row 4The fourth sheet in the workbookThe fourth cell in row C

Question 2 of 5Which formula adds up the values in B2 through B10?

=ADD(B2:B10)SUM(B2-B10)=SUM(B2:B10)=B2:B10

Question 3 of 5You copy =A2*$F$1 from row 2 down to row 3. What does the copied formula become?

=A3*$F$2=A3*$F$1=A2*$F$1=A3*F2

Question 4 of 5What does =IF(D2>100,"High","Normal") show when D2 is 80?

High80NormalAn error

Question 5 of 5Why is =B2*C2 better than typing the answer 420 into the cell?

It makes the file smallerThe result updates automatically when B2 or C2 changesTyped numbers cannot be formatted as currencySpreadsheets do not allow typed numbers

You need 4 out of 5 to pass.