08:14 -
Computer Fundamentals
Write short note on A) Cell and Cell Address B) Status Bar in MS-Excel
A) Cell and Cell Address
Ø
Cell:
In Excel the intersection of a column and a row is called as a cell . Each cell
has a name or cell address. A cell is basic block of MS Excel. It hold data and
formulas in tabular format. In a worksheet there has 65536 row and 256 columns.
The total cells in a worksheet are
256*65536 =16777216
Ø
Cell
Address: Each cell has a name or a cell address. The cell address consists of
the column letter and row number. For example the first cell is in first column
and first row. First column name is A and first row number is 1. Therefore the
first cell address is A1. Similarly the
address of last cell is IV65536 i.e. column IV and row number is 65536.
B). Status Bar in MS-Excel:
The Status bar is at the bottom of the Excel spreadsheet and provides
useful information from the Excel software or issued from a running macro. It
displays, on the left side various modes like Ready Or Edit mode. It also shows
status of num lock, caps lock and scroll lock keys on the keyboard on the right
side. If missing it can
be restored on Tools --> View. The status bar provides a convenient
method of summing a range of cells (SUM not included for a single cell).
SUM will not be shown unless at least one of the cells is numeric and at least
a second cell has content (not ISBLANK). Some of the other indications
are for keys depressed. It also do some math’s function like min, max, count,
avg etc. Here is screen shot of status bar.