Case-Based Critical Thinking Questions
Case 8-3
Javier tells you that your work in Excel will go a lot faster if you start using defined names instead of cell and range addresses.You believe him but you have been frustrated by defined names in the past because you did not know the rules for naming them and you have run into errors as a result.Javier offers to help you.
-Which of the following is true statement Javier can make about defined names as he is explaining the rules to you?
A) The name can include letters,numbers,periods,and underscores
B) To distinguish multiword names,use a hyphen between the words
C) Defined names are case sensitive
D) All of the above

Question

Quizplus · Accepted Answer

Defined names in Excel can include letters, numbers, periods, and underscores, but they cannot include spaces or hyphens. They are not case sensitive.