Multiple Choice
Case-Based Critical Thinking Questions Case 7-3 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 an example of a valid defined name Juan can provide to you?
A) .FY2010
B) F-Y2010
C) FY2010
D) FiscalYear2010
Correct Answer:

Verified
Correct Answer:
Verified
Q15: In the Allow list box in the
Q26: Range names must begin with _.<br>A)a letter
Q28: To remove workbook protection click the Unprotect
Q41: A macro _ uses a program's own
Q43: Defined names are automatically substituted for existing
Q62: The Excel data _ feature restricts data
Q94: Input messages appear as _ next to
Q99: A(n)_ is a spreadsheet written or tailored
Q104: One way to run a macro is
Q114: Every cell in a workbook has a(n)_