Charles is having a lot of problems with errors in a very complicated spreadsheet that he inherited from a colleague, and he turns to another co-worker, seymour, for tips on how to trace errors in the sheet. if charles sees which of the following, seymour explains, there is a mistyped function name in the sheet.
a.#form?
b.#name?
c.
d.#fnct?

b.#NAME?

Explanation:

Remember, in Spreadsheet programs like Ms Excel several types of errors can occur such as value error.

However, since Seymour explains that there is a mistyped function name in the sheet it is more likely to display on the affected cell as #NAME?.

For example the function =SUM is wrongly spelled =SOM.

Therefore it is important to make sure the function name is spelled correctly.