Multiple Choice
Juan 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. Juan offers to help you.
-Which of the following is a true statement Juan 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) The name should start with a hash tag
Correct Answer:

Verified
Correct Answer:
Verified
Q41: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB2166/.jpg" alt=" -To keep a
Q41: A macro _ uses a program's own
Q42: To remove workbook protection,click the Unprotect Workbook
Q43: Defined names are automatically substituted for existing
Q45: Running a macro means Excel performs a
Q47: Which of the following tabs in the
Q50: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB2166/.jpg" alt=" -Clicking the Edit
Q74: Each sub procedure in VBA begins with
Q91: When you lock a workbook you control
Q96: A digital _ is often used to