Exel Formulas

What formula needs to be inserted into cell B6?

• =TOTAL(B1:B5)

• =(B1:B5)TOTAL

• =SUM(B1:B5)

• =(B1:B5)SUM

Which formula has been entered into cell D10?

• =2*£0.25

• =D10*C10

• =B10*C10

Which formula is being used in cell D6?

• =4*£1.00

• C6+B6

• =D6*B6

• =B6*C6

Which formula is being used in cell D2?

• =D2*C2

• =B2*C2

• =10*£0.25

Which formula is being used in cell D11?

• SUM(D10 to D2)=

• =SUM(D2,D10)

• =(D2:D10)SUM

• =SUM(D2:10)

What is the cell range for A?

• B2 to B6

• A4:A5

• A4,A5

• A4 to A5

What is the cell range for B?

• B2,B6

• A4:A5

• A8, D8

• B2:B6

What is the cell range for C?

• C1:E1

• C1:D3

• C1,D3

• C1:E3

What is the cell range for D?

• D4:H9

• E5,H9

• E5:H9

• D4,H9

What is the cell range for E?

• A8:D8

• A8,D7

• D7,A8

• A8:D9