USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
T
|
|
|
F
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -All named ranges must begin with a letter, a backslash (")¨ or an underscore (" "). Named ranges can contain numbers but spaces are not allowed (use the underscore instead). Named ranges cannot resemble any actual cell references (e.g. A4 or H7 etc).
Detailed explanation-2: -The name string must begin with a letter or underscore character. Remaining characters in the name can be letters, numbers, periods, and underscore characters. Spaces are not allowed, but two words can be joined with an underscore ( ) or period (.).
Detailed explanation-3: -Select the range you want to name, including the row or column labels. Select Formulas > Create from Selection. In the Create Names from Selection dialog box, designate the location that contains the labels by selecting the Top row, Left column, Bottom row, or Right column check box. Select OK.