List at least five guidelines and rules for naming a range.

What will be an ideal response?

Answers may vary, but should contain five guidelines or rules. Range names may contain up to 255 characters and must begin with a letter or an underscore. You can use a combination of uppercase and lowercase letters, numbers, periods, and underscores. A range name cannot have any spaces or special characters and should describe the contents of the range. Range names cannot be identical to cell contents. It is suggested to keep range names short.