Question

What does it mean when #DIV/0! is displayed and a green triangle is added to the upper-left corner of a cell? A. The formula cannot be calculated because there is an error. B. The formula can be calculated but there is an error. C. The formula doesn't start with a = sign. D. The Error Checking feature is disabled.

Answer 1

The answer to the question is B.

Answer 2

Answer: B. The formula can be calculated but there is an error.

Explanation:

Excel checks a formula when you enter it. When a formula can’t be calculated, an error is displayed and a green triangle is added to the upper-left corner of the cell. For example, the formula =4/0 displays #DIV/0!. This displays because numbers can’t be divided by 0. You can select the cell with the error and click Error Checking to display a description of the error and a list of options. PF