Question

write a short note on the following​

Answer 1

Explanation:

Marking Scheme - Sample Paper – Accountancy (2020-21)

(with suitable explanation)

32

Answer:

The error is #NUM! Error. The steps to correct it are:

1. Optionally, click the cell that displays the error, click the button that appears and then click show

calculation steps.

2. Review the following causes and solutions:

 Using an unacceptable argument in the 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 the

result.

 Use a different starting value for the worksheet function.

3. Then click the Microsoft button >Excel option and then click the formulas category.

6