Microsoft Excel Quiz: Formulas

JavaScript isn't enabled in your browser, so this file can't be opened. Enable and reload.

Learn with Yasir: https://yasirbhutta.github.io/
Learn Microsoft Excel: https://yasirbhutta.github.io/ms-excel/

What is the result of the following formula in Excel:

=10 + 5 * 2

1 point

What is the difference between an arithmetic operator and a relational operator? *

1 point

An arithmetic operator performs a mathematical operation on two or more values, while a relational operator compares two values and returns a date.

An arithmetic operator performs a mathematical operation on two or more values, while a relational operator compares two values and returns a string.

An arithmetic operator performs a mathematical operation on two or more values, while a relational operator compares two values and returns a TRUE or FALSE value

An arithmetic operator performs a mathematical operation on two or more values, while a relational operator compares two values and returns a number.

The formula =A1/A2 returns an error if A2 contains a zero. *

1 point

True

False

In Excel, the % operator multiplies the value by 100. *

1 point

True

False

What is the result of the following formula: =A1>B1? *

1 point

True (if A1 is greater than B1)

Error (if A1 and B1 are equal)

False (if A1 is Not Equal to B1)

None of the above

Which operator is used for division in Excel? *

1 point

Which operator is used for “not equal to” in Excel? *

1 point

To multiply values in Excel, you use the "+" operator. *

1 point

True

False

Which of the following operators has the highest precedence in Excel? *

1 point

Addition (+)

Multiplication (*)

Exponentiation (^)

Division (/)

If cell B1 contains the value 8 and cell B2 contains the value 2, what is the result of the formula

=B1^B2

1 point

What is the result of the expression “10 <= 5” in Excel? *

1 point

True

Cannot be determined

Error

False

If A1 contains the value 20 and B1 contains the value 5, what is the result of the formula:

=A1-B1*2

1 point

What is the result of the expression “=A1 > B1” if the value in cell A1 is 10 and in cell B1 is 5? *

1 point

False

Not applicable

Error

True

What is a formula? *

1 point

A cell in a spreadsheet

A range of cells

The address of a cell

A rule that tells Excel how to calculate something

Submit

Clear form

Forms

This content is neither created nor endorsed by Google.