Which formula adds up a series of cells?

1.   ?    =C2+C3
2.   ?    =C2-C3
3.   ?    =C2/C3
4.   ?    =C2*C3

Which formula takes away one cell from another cell?

1.   ?    =C2+C3
2.   ?    =C2-C3
3.   ?    =C2/C3
4.   ?    =C2*C3

Which formula will not add up a series of cells?

1.   ?    =C2+C3
2.   ?    =C2+C5
3.   ?    =C2-C3
4.   ?    =SUM(C2:C4)

Which formula will divide a cell by 2?

1.   ?    =C2*2
2.   ?    =C2/3
3.   ?    =C2/2
4.   ?    =C2*3

Which formula will multiply a cell by 50?

1.   ?    =C2*20
2.   ?    =C2*50
3.   ?    =C2/20
4.   ?    =C2/50

Which formula will add up the content of cells C2 and B5?

1.   ?    =C2+B6
2.   ?    =C3+B5
3.   ?    =C2+B5
4.   ?    =C3+B6

We can work out 50% of a cell by using ....

1.   ?    =C2*100
2.   ?    =C2*0.4
3.   ?    =C2*0.5
4.   ?    C2*0.6

80% of a cell is worked out using ...

1.   ?    =C2/100*80
2.   ?    =C2*100/80
3.   ?    =C2/100*8
4.   ?    =C2/80*100

If we want to work out what C2 divided by B6, add 2 we can use ...

1.   ?    =(C2/B6)+2
2.   ?    =C2/B6+2
3.   ?    =C2*B6+2
4.   ?    =C2*B6-2

Which formula will find the average of 3 cells ?

1.   ?    =AVERAGE(C2:C4)
2.   ?    =AVERAGE(C2:C7)
3.   ?    =AVERAGE(C2-C3)
4.   ?    =AVERAGE(C2/C3)