Entering Data in Cell

Entering Data in Cell


To enter any data in a worksheet, practically in the cell, it is required to select the cell. Cell can be selected by positioning the pointer in a cell. The data to be entered can be the label, values or formula.

(a) Label: Label is the any text entered by using a keyboard. It may combine with letters, numbers, and special symbols. By default the labels are left aligned.

(b) Values: The numerical data consisting of only numbers are called values. By default values are right aligned. There are various forms of values, such as integer, decimal and so on.

(c) Formula: Any expressions that begins with an equals ‘=’ is treated as formula. In the expression, the ‘=’ followed by values, cell address and functions are called as formula. When a formula is entered in a cell in a worksheet the value of the equation is displayed in the cell and the formula is shown in the formula bar.


Note: The values do not display the preceding zero. If any value (e.g., telephone numbers), preceded by 0, then the first letter ‘0’ is not displayed, when the data is value. To show the preceding ‘0’, the data type has to be specified as ‘Text’.


CCC Online Test 2021 CCC Practice Test Hindi Python Programming Tutorials Best Computer Training Institute in Prayagraj (Allahabad) Best Java Training Institute in Prayagraj (Allahabad) Best Python Training Institute in Prayagraj (Allahabad) O Level NIELIT Study material and Quiz Bank SSC Railway TET UPTET Question Bank career counselling in allahabad Sarkari Naukari Notification Best Website and Software Company in Allahabad Website development Company in Allahabad