Microsoft Excel Formulae

What is the formula to add two numbers in Excel?

• =ADD(number1, number2)

• =TOTAL(number1, number2)

• =SUM(number1, number2)

• =PLUS(number1, number2)

How do you subtract numbers in Excel using a formula?

• =A1-B1

• =B1-A1

• =SUM(A1,B1)

• =B1+A1

What is the formula to multiply two numbers in Excel?

• =A1^B1

• =A1+B1

• =A1/B1

• =A1*B1

How do you divide numbers in Excel using a formula?

• Use the multiplication operator (*) within a formula.

• Use the addition operator (+) within a formula.

• Use the subtraction operator (-) within a formula.

• Use the division operator (/) within a formula.

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

• =AVERAGE(range)

• =MODE(range)

• =MEDIAN(range)

• =SUM(range)/COUNT(range)

How do you calculate the sum of a range of cells in Excel using a formula?

• =SUM(start_cell+end_cell)

• =SUM(start_cell*end_cell)

• =SUM(start_cell:end_cell)

• =SUM(start_cell, end_cell)

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

• =MAX(range)

• =SUM(range)

• =AVERAGE(range)

• =MIN(range)

How do you find the minimum value in a range of cells in Excel using a formula?

• =SUM(range)

• =AVERAGE(range)

• =MIN(range)

• =MAX(range)

What is the formula to concatenate two text strings in Excel?

• =+

• =concatenate()

• =&

• =join()

How do you apply conditional formatting to a range of cells in Excel?

• Select the range, then choose Format > Conditional Formatting.

• Select the range, then choose Edit > Conditional Formatting.

• Select the range, then choose View > Conditional Formatting.

• Select the range, then choose Insert > Conditional Formatting.