Question

iv. The error occurs if the column is not having enough space to accommodate the value,
######## #Name #Value
​

Answer 1

The #name error is the error that occurs in the excel software program when the computer software does not know the text written in the formula.when the syntax or the formula us wrong.

The #value is the error that occurs when the arguments in the formula are not right.

Explanation:

We can correct the #name error by following the method.

One can go to the  Formulas tab, in the Defined Names group and then click on Name Manager.

In the Name Manager dialog box, click on the name that one want to change.

Select one or more names by :

To select a name, and the Click on  Delete.  

And then Click OK to confirm the deletion.