Question

What is formula bar? how it is different from name box in excel

Answer 1

Answer:

The difference between the formula bar and the name box is pretty simple.

The formula bar displays the content of the cell.

And the name box displays the cell address.

One can choose certain cells that is a range of cells and rename them in the name box.

Let us take an example:

The cell address ranging from A1 to A10 is selected and renamed in the name box as "Sum".

Now, if we need to perform any mathematical function on the given range of cells, the function can be operated with the help of A1:A10 as as the argument.

Or by writing the name of the range of cell.