USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
55
|
|
|
125
|
|
|
255
|
|
|
355
|
Detailed explanation-1: -Based on a web search it looks like Excel places a 255 character limit on named ranges.
Detailed explanation-2: -Text values in formulas are limited to 255 characters. To create text values longer than 255 characters in a formula, use the CONCATENATE function or the concatenation operator (&).
Detailed explanation-3: -8 bit means that 2^8 different characters can be referenced. 2^8 equals 256, and as counting starts with 0, the maximum ASCII char code has the value 255.
Detailed explanation-4: -There appears to be no limit to the number of names you can define, but a name may contain no more than 255 characters.
Detailed explanation-5: -The limit occurs due to an optimization technique where smaller strings are stored with the first byte holding the length of the string. Since a byte can only hold 256 different values, the maximum string length would be 255 since the first byte was reserved for storing the length.