Formulas and Functions Drill

Choose the correct formula:

Cells: A1, B1

Operation: Addition

• =A1+B1

• =A1-B1

• =A1*B1

Choose the correct formula:

Cells: A1, B1

Operation: Subtraction

• =A1+B1

• =A1-B1

• =A1/B1

Choose the correct formula:

Cells: A1, B1

Operation: Multiplication

• A1*B1=

• =A1xB1

• =A1*B1

Choose the correct formula:

Cells: A1, B1

Operation: Division

• A1/B1=

• =A1/B1

• =A1÷B1

Choose the correct syntax:

Cells: A1:A20

Function name: SUM

• =SUM(A1:A20)

• =TOTAL(A1:A20)

• =(A1:A20)SUM

Choose the correct syntax:

Cells: A1:A20

Function name: AVERAGE

• =AVERAGE(A1,A20)

• =AVERAGE(A1:A20)

• =(A1:A20)AVERAGE

Choose the correct syntax:

Cells: A1:A20

Function name: COUNT

• =COUNT(A1:A20)

• =COUNT(A1,A20)

• =COUNT[A1:A20]

Choose the correct syntax:

Cells: A1:A20

Function name: MAX

• =MAX[A1:A20]

• =MIN(A1:A20)

• =MAX(A1:A20)

Choose the correct syntax:

Cells: A1:A20

Function name: MIN

• =MIN[A1:A20]

• =MIN(A1:A20)

• =MAX(A1:A20)

Choose the correct formula:

Cells: A1, B1, C1

Operation: Addition

• =A1+B1+C1

• =A1-B1*C1

• =A1+B1-C1