Excel Functions and Formulas

What is the formula to add two numbers in Excel?

• =PLUS(number1, number2)

• =ADD(number1, number2)

• =SUM(number1, number2)

• =number1 + number2

How do you subtract one number from another in Excel?

• =A1+B1

• =A1*B1

• =A1/B1

• =A1-B1

What is the formula to multiply two numbers in Excel?

• =A1^B1

• =A1*B1

• =A1/B1

• =A1+B1

How do you divide one number by another in Excel?

• You can divide one number by another in Excel by using the subtraction operator (-)

• You can divide one number by another in Excel by using the addition operator (+)

• You can divide one number by another in Excel by using the division operator (/) or the DIVIDE function.

• You can divide one number by another in Excel by using the multiplication operator (*)

What is the formula to calculate the average of a range of cells in Excel?

• =MODE(range)

• =MEDIAN(range)

• =AVERAGE(range)

• =SUM(range)/COUNT(range)

How do you find the maximum value in a range of cells in Excel?

• MAX function

• MIN function

• AVERAGE function

• SUM function

What is the formula to find the minimum value in a range of cells in Excel?

• =SUM(range)

• =MAX(range)

• =MIN(range)

• =AVERAGE(range)

How do you calculate the square root of a number in Excel?

• =SQRT(number)

• =SQUARE(number)

• =POWER(number, 0.5)

• =number^(1/2)

What is the formula to calculate the sum of a range of cells in Excel?

• =SUM(start_cell*end_cell)

• =SUM(start_cell, end_cell)

• =SUM(start_cell+end_cell)

• =SUM(start_cell:end_cell)

How do you round a number to a specific number of decimal places in Excel?

• Use the ROUND function

• Use the CEILING function

• Use the FLOOR function

• Use the TRUNC function