Multiple Choice
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
Correct Answer:

Verified
Correct Answer:
Verified
Q17: The most serious error alert is the
Q64: In the Allow list box in the
Q74: In Office 2010,you can define a set
Q75: The current data in the ParkingFee cell,according
Q76: Sometimes when you build a worksheet for
Q79: When you set up worksheet protection,you can
Q80: You drag the comment's border to resize
Q81: A(n)_ message provides additional information about the
Q84: In the Allow list box in the
Q93: If your data is organized in a