Calculations in MS Excel

Which of the following is an operator for multiplication in Excel?

• /

• *

• %

• &

The _______ feature is particularly useful when we want to add numbers in a contiguous row or column quickly.

An error occurs when a formula is not recognised by Excel?

The formula =2+3*5 gives the result as

• 25

• 17

• 22

• 11

What is formula?

The AVG function is used to calculate the average numbers in a range of cells.

• True

• False

The operator to divide two numbers is * in Excel?

• True

• False

__________ are the addresses of the cells contain values to be used for calculations.

To make cell references absolute, we use '#' symbol?

• True

• False

What are operators?