#NUM! Error- When does this error occurs

CUET Preparation Today

Start Free Mocks

Home Questions 5C296RGW4M

Target Exam

CUET

Subject

Accountancy Part C

Chapter

Spreadsheet

Question:

#NUM! Error- When does this error occurs in excel spreadsheet?

Options:

This error occurs when a cell reference is not valid

This error occurs with invalid numeric values in a formula or function.

This error occurs when a value is not available to a function or formula

This error occurs when a number is divided by zero

Correct Answer:

This error occurs with invalid numeric values in a formula or function.

Explanation:

The correct answer is Option (2) →

This error occurs with invalid numeric values in a formula or function.