1. Active Cell
The active cell is the cell surrounded by a black border. The black border is referred to as the active cell highlight
Data can only be entered into the active cell.
Even if more than one cell is selected, there is still only one active cell.
Use the mouse pointer or the arrow keys on the keyboard to move the active cell highlight from one cell to another.
It is also known As the Current Cell.
A cell reference consists of the column letter and the row number that intersect at the cell's location. Note that when listing a cell reference, the column letter is always listed first.
The current cell reference can always be found in the Name Box (see below).
In some spreadsheet programs, a cell reference is referred to as a cell address.
3. DataData is information that is stored in a spreadsheet program.
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.
There are three types of data in Excel: values, labels, and dates/times.
Examples of simple formulas : = A3 - C6 / D2 or = ( B4 + B5 ) * E7
In spreadsheet formulas, normally we use the cell reference of the data rather than the data itself.
In Excel, formulas begin with an equal ( = ) sign.
In other spreadsheet programs, such as Lotus 1-2-3 and Quattro Pro, formulas begin with a plus ( + ) sign.
Alternate Spellings: formulae
Like formulas, functions in Excel begin with the equal sign ( = ) followed by the function’s name and its arguments.
The function name tells Excel what calculation to perform. The arguments are contained inside round brackets and tell Excel what data or other information to use in the calculation.
For example, the SUM function is one of the most commonly used functions in Excel. It is used to add together the data in selected cells. The SUM function is written as -
= SUM ( D1 : D6 )
Here the function adds the contents of cells D1 to D6 and stores the answer in cell D7.
6. Name Box
7. Formula Bar
8. RangeA range is a group of cells in a worksheet that have been selected or highlighted. When cells have been selected they are surrounded by a black outline or border.
Using the mouse, keyboard or name box, a number of cells can be selected to create a range. Commands executed by Excel will affect the entire range.
A range is identified by the cell references of the cells in the upper left and lower right corners of the range. These two references are separated by a colon ( : ) which tells Excel to include all the cells between these start and end points.
An example of a range of adjacent cells would be B5 : D10.
The Ribbon replaces the menus and toolbars found in earlier versions of Excel.
Above the Ribbon are a number of tabs, such as Home, Insert, and Page Layout. Clicking on a tab displays the options located in this section of the ribbon.