MSEXCEL FORMULA

If you have a list of numbers in cells B2 through B20 and you wanted the average of these numbers, what would be the formula?

• =AVERAGE(B2:B20)/2

• =AVERAGE(B2-B20)

• AVERAGE(B2:B20)

• =AVERAGE(B2:B20)

What types of calculations can you perform using the SUM function?

• Add

• Multiply

• Divide

• All of these answers are correct.

Which formula below will add the value of B2 to the value of C3

• =B2+C3

• =C3+B3

• =6+4

•  

  =B+C

Which of the following option is a formula?

• =SUM(A1:A5)

• Add A1 - A5

• Subtract the numbers from A1 to A5

• A1 = A5

A selection of multiple cells is called a

• Group

• Range

• Reference

• Package

The multiplication arithmetic operator is represented by which of the following symbols?

• ^

• *

• /

• X

To add two cells (A1 and A2) together you use the following formula

• =A1 + A2

• =Add(A1+A2)

• =together(A1:A2)

• A1 plus A2

The cell reference fro a range of cells that starts in cell B1 and goes over to column G and down to row 10 is……

• B1-G10

• B1.G10

• B1;G10

• B1:G10

To calculate the highest marks formula is

• maximum(C2:C7)

• ==max(C2:C8)

• max(C2:C7)

• =max(C2:C7)

To calculate Total Price we use

• =G3+H8

• =G3*H3

• =SUM(G3*H3)

• =I3/I8