Microsoft Excel Quiz

What is the purpose of an equal to (=) sign in a formula?

• To indicate the start of a formula

• To perform addition

• To multiply values

• To divide values

Which operator is used for subtraction in Excel?

• + (plus sign)

• - (minus sign)

• * (asterisk)

• / (forward slash)

What does the percent sign (%) operator do in Excel?

• Calculates the average

• Calculates the percentage

• Calculates the exponentiation

• Calculates the division

What is the purpose of the colon (:) reference operator in Excel?

• To perform addition

• To indicate the start of a formula

• To combine multiple references into one reference

• To calculate the average

What does the #N/A error indicate in Excel?

• The data is unavailable

• The operations given is invalid

• Division by 0 is invalid

• The text is not recognized

How can you find the sum of values in cells A1, A2, and A3 in Excel?

• =SUM(A1; A2,;A3)

• =A1+A2+A3

• =A1-A2-A3

• =A1*A2*A3

What is the purpose of functions in Excel?

• To perform basic mathematical operations

• To compare two values

• To combine values

• To perform predefined calculations

What is the purpose of the SUM function in Excel?

• To multiply a range of numbers.
• To subtract a range of numbers.
• To find the average of a range of numbers.
• To add up a range of numbers.

What is the purpose of the AVERAGE function in Excel?

• To calculate the sum of a range of numbers.
• To find the maximum value in a range of numbers.
• To count the number of cells in a range of numbers.
• To calculate the average of a range of numbers.

What is the purpose of the AutoSum feature in Excel?

• To find the maximum value

• To automatically perform desired calculations in selected cells

• To find the minimum value

• To calculate the average of given values