Page 243 - CITS - Computer Software Application -TT

COMPUTER SOFTWARE APPLICATION - CITS

Naming Convention for Named Ranges in Excel
There are certain naming rules you need to know while creating Named Ranges in Excel:
• The first character of a Named Range should be a letter and underscore character(_), or a backslash(\). If
it’s anything else, it will show an error. 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. For example, you can’t have Sales Rep as a named
range. If you want to combine two words and create a Named Range, use an underscore, period or uppercase
characters to create it. For example, you can have Sales_Rep, SalesRep, or SalesRep.
• While creating named ranges, Excel treats uppercase and lowercase the same way. For example, if you
create a named range SALES, then you will not be able to create another named range such as ‘sales’ or
‘Sales’.

• A Named Range can be up to 255 characters long.

What Are Excel Errors

Excel is a powerful tool for working with data, but it can also be frustrating when errors occur. While some errors
are easy to fix, others can be more difficult to troubleshoot. By understanding the different types of Excel errors,
you can learn how to avoid them and quickly fix them when they occur. This will help you save time and ensure
that your Excel workbooks are accurate and error-free.
Below is the list of some most common errors that we can find in the Excel formula
1 #NAME? Error: This Excel error usually occurs because of the non-existent function.
2 #DIV/0! Error: This Excel error because if we try to divide the number by zero or vice-versa.

3 #REF! Error: This error arises due to a reference missing.
4 #NULL! Error: This error comes due to unnecessary spaces inside the function.
5 #N/A Error: The function cannot find the required data. Maybe the wrong reference is given.
6 ###### Error: This is not a true Excel formula error, but it occurs because of a formatting issue. Probably, the
value in the cell is more than the column width.
7 #VALUE! Error: This is one of the common Excel formula errors we see in Excel. It occurs due to the wrong
data type of the parameter given to the function.

8 #NUM! Error: Excel formula error because the number we have supplied to the formula is not proper.
#1 #NAME? Error
The #NAME? Excel formula error is when Excel cannot find the supplied function or the parameters we gave do
not match the standards of the function.
Just because of the display value of #NAME? It does not mean Excel is asking your name. Rather, it is due to the
wrong data type for the parameter.

230

CITS : IT&ITES - Computer Software Application - Lesson 63 - 77