USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
8 characters
|
|
|
31 characters
|
|
|
250 characters
|
|
|
200 characters
|
Detailed explanation-1: -The file format would allow worksheet names to be up to 255 characters long, but if the Excel user interface forbids you from going over 31, don’t try to.
Detailed explanation-2: -Microsoft Excel does not allow worksheet name longer than 31 characters.
Detailed explanation-3: -Excel, however, seems to limit those names to only 30 characters, so he wonders if there is a way to exceed that limit. The short answer is no, you cannot change the limit on worksheet name length. It is hard coded into Excel at 31 characters.
Detailed explanation-4: -The total number of characters that a cell can contain is 32, 767. A cell can only display 1, 024 characters. At the same time, the Formula bar can show all 32, 767 symbols.
Detailed explanation-5: –Make sure the file/path name doesn’t contain more than 218 characters.