The name box is the box at left end of the formula bar that
identifies the selected cell, chart item, or drawing object. The
Name Box displays the cell reference of the active cell.
The Name Box can also be used to assign names to cells or
ranges of cells. To name a cell or range, highlight the cell or
range you would like to name, type the name in the Name box, and press ENTER. To later
move to and select a named cell or range, click its name in the Name box.
7. DATA
Data is information that is stored in a spreadsheet. Data is stored in the individual cells of a
worksheet. Only one piece of data is stored in each cell. In addition to being stored in the
spreadsheet, the data can be used in calculations, displayed in graphs, or sorted and filtered to
find specific information. The three types of data in Excel are numbers, text, and dates/times.
8. FORMULA BAR
The formula bar in Excel is located next to the name box
and above the worksheet area. It displays the data stored in
the active cell. The formula bar is used to view, enter, and
edit values and formulas in cells.
9. FORMULA
A spreadsheet formula is a mathematical equation that will calculate a result. Formulas are
typed into the formula bar.
A formula always begins with an equal sign (=). For example the formula =1+1 will result in 2
being displayed.
In spreadsheet formulas, normally we use the cell reference of the data rather than the data
itself. For example:
=A1*B1
=(A1+A2)/B1
10. FUNCTION