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.

Question

Computers and Technology

Stinky

10 July, 23:20

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.

+5

Answers (2)

Know the Answer?

America Crawford · Answer 1

America Crawford 11 July, 00:12

0

The answer to the question is B.

Kyler Shepherd · 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