USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
T
|
|
|
FWhat is not allowed in range names?What is not allowed in range names in Excel?Are spaces allowed in cell names?When naming a range there no space is allowed *?What are the rules for naming a range?What are name ranges in Excel?Can a range name have spaces?Are spaces allowed in variable names?Can table names have spaces in Excel?
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -The remaining characters can be letters, numbers, special characters, period, or underscore. You can not use names that also represent cell references in Excel. For example, you can’t use AB1 as it is also a cell reference. You can’t use spaces while creating named ranges.
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: -The first character of a name must be a letter or an underscore character ( ). Remaining characters in the name can be letters, numbers, periods, and underscore characters. In some languages, Excel may replace certain characters with underscores. Spaces are not allowed.
Detailed explanation-4: -Cell references disallowed Names cannot be the same as a cell reference, such as Z$100 or R1C1. Spaces are not valid Spaces are not allowed as part of a name. Use the underscore character ( ) and period (.)
Detailed explanation-5: -There are a few rules to keep in mind when you are naming ranges: The first character must be either a letter, an underscore ( ) or backslash (