Excel Formulas and Functions Quiz

What symbol must every formula in Excel start with?

• +

• *

• =

• /

Which of the following is a predefined formula in Excel?

• Formula

• Function

• Operand

• Operator

In the formula =A1 + B1, what are A1 and B1 considered?

• Functions

• Operators

• Operands

• Arguments

What does the SUM function do?

• Calculates the average

• Finds the largest number

• Adds all the numbers in a range

• Subtracts values

Which operator is used for division in Excel formulas?

• +

• -

• *

• /

A formula can only include numbers, not cell references.

• True

• False

The MIN function returns the largest number in a specified range.

• True

• False

The AVERAGE function is used to find the sum of a range of numbers.

• True

• False

In the formula =A1 - B1, the operator used is subtraction.

• True

• False

Excel functions cannot be used in combination with basic formulas.

• True

• False