Yes, that is normally what happens. However, there are exceptions. For example, you can select a column of numbers and when you click Autosum, it will put a total in the cell below the column. It is also possible to have it entered in more than one cell. For example, if you have a group of columns with numbers, you can select the line of cells below those columns or all of the columns. There will still only be one active cell, but clicking the Autosum button will put a total under each column.
As you type, Excel displays the entry in the FORMULA BAR, and also displays the active cell reference int he Name box on the left.
It displays contents of the active cell.
The Name box.
There is always one active cell. Its address will be displayed in the Name box, or the name of a named cell or named range. If a named range is selected, there is still only one active cell, but the name of the range will be shown in preference to the active cell's address.
Name Box
name box
area near the top of the worksheet window that displays the contents of the active cell
The name box displays the name or cell reference of the active cell.
any where in a active table or cell
It has a bold border and the name box (top right, to the left of the formula bar) displays the cell address or name.
The Formula Bar.
By using ATP.