Name the error which occurs when there is some invalid numeric value (e.g. you try to calculate square root of some negative number) is placed in the…

Correct #NUM! Error appears when some invalid numeric value is placed in formula or function. Possible Causes: Using an unacceptable argument in a function that requires a numeric argument. Make sure that the arguments used in the function are numbers. Using a worksheet function that iterates such as IRR or RATE and the function cannot find a result. Next night use a different starting Use a different starting value for the worksheet function. Change Change the number of I times Microsoft office nitrates formulas. Solution: 1. Click the Microsoft Office Button Click Excel options and then click the formulas category. 2. In the calculation option section select the Enable iterative calculations check box. 3.To set the maximum number of times that Excel will recalculate type the number of iterations in the Maximum iterations box. The higher the number of iterations the more time the Excel needs to calculate a worksheet. 4. To set the maximum amount of change that we will accept between calculation results, type the amount in the Maximum change box. The smaller the number, the more accurate the result and the more time the Excel needs to calculate a worksheet.