Data 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, Formula and dates/times.

1. Value cell entry: A cell that contains numbers with or without a + or – symbols is called a value cell. These cells can be used in mathematical calculations. For example marks, age, salary, etc., 

2. Label Cell entry: A cell that contains a to z alphabets, numbers and symbols is called label cell. For example, place name, employee code, etc.,

3. Formula cell entry: A cell where the cell entry begins with a = and a formula appended to calculate something is called a formula cell entry. For example (= a10 + 25).

4. Cell Range: A range is a series of two or more cells. If they are adjoining, they are called as adjacent range on contiguous. If the are non contiguous, they are called a non-adjacent range.

A range is identified by the cell references of the cells in the upper left and lower right comers of the range. These two references are separated by a colon (:) which tells Excel to include all the cells between these start and endpoints. An example of a range of adjacent cells would be B5: D10.

• To select an adjacent range, click on a cell in a corner of your selection and drag the mouse over the remaining cells. For example, A1 through D6, D8 through E9, and B14 through D15 are written as A 1:D6 or D8: E9 or B14: D15.
• To select a non-adjacent range, first select an adjacent range of cells. Now, press and hold down the Ctrl key while you select another adjacent range of cells. Release the mouse button and the Ctrl key.
• The adjacent ranges can be combined into a variety of different non-adjacent ranges. For example, one non-adjacent range is A1 through D6 and D8 through E9 is written as A1: D6; D8: E9.