Question

Computer 2. Write the rules for naming a range.​

Answer 1

Answer:

Naming Convention for Named Ranges in Excel

The first character of a Named Range should be a letter and underscore character(_), or a backslash(\). ...You can not use names that also represent cell references in Excel. ...You can't use spaces while creating named ranges. ...A Named Range can be up to 255 characters long.

Answer 2

Answer:

When creating named ranges, follow these rules:

• Names must begin with a letter, an underscore (_), or a backslash (\)
• Names can't contain spaces and most punctuation characters.
• Names can't conflict with cell references – you can't name a range "A1" or "Z100".