I have given names to the cells B1, B2, and B3. I need to calculate the simple interest for the following data. Let us further our understanding with the help of an example. These can then be referenced in any other object. Names can be used to name MS Excel objects like cells, cell ranges, tables, formulas, constants, etc. But today, we will discuss the concept of names, which make it easier to build, use, and understand formulas.
In order to use MS Excel formulas properly we need to have clarity about the different types of cell references.