Question

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?

Answer 1

Answer:

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.