Want this question answered?
You are editing the active cell.
The cell borders are highlighted, or if a range of cells are selected, the active cell will be a different colour than the others, usually being white. The name of the active cell will always appear in the name box.
cell contents
formula bar
It displays contents of the active cell.
yes
The Active Cell on a spreadsheet is the cell where the cursor is pointing. That means that you can write to or erase the contents that cell location directly. A spreadsheet program has the entire array in memory, but the Active Cell is the place where it is 'looking or thinking about' at any particular moment.
If you insert a new row above B1, the cell contents will move to B2 in the second row. If you insert a new row below B1, the cell contents will not move.
area near the top of the worksheet window that displays the contents of the active cell
If you see a cell with a lot of has symbols in it, like #####, it usually means the cell is not wide enough to display its contents. This normally applies to numbers, not text. If you widen the column that the cell is in, it will display the contents correctly.
Clicking on a different cell, using any of the navigation keys, such as the arrows or Page Up, Page Down etc. or pressing the Return or Enter keys can all change which is the active cell. Only one cell can be the active cell at any time, even if you have lots of cells selected. You can copy/cut and paste the contents of the active cell to another cell, which will then be the active cell.
The contents of the active cell are indented approximately one character width.