Case-Based Critical Thinking Questions
Case 9-1
Christian 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,Sebastian,for tips in how to trace errors in the sheet.
-If Christian sees which of the following,Sebastian explains,there is a mistyped function name in the sheet.
A) #FNCT?
B) #FORM?
C) #NAME?
D) Any of the above

Question

Quizplus · Accepted Answer

The #NAME? error is usually displayed when a formula contains a reference to a name that cannot be resolved. This can be caused by a mistyped function name or a cell reference that doesn't exist. Therefore, if Christian sees #NAME? in the spreadsheet, Sebastian explains that there may be a mistyped function name in the sheet. A and B are not correct as they are not commonly used error messages in spreadsheets.