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’.
- A spreadsheet, also known as a worksheet, is a row and column arrangement of data and the formulas to manipulate the data.
- A spreadsheet can be used for a variety of applications like business forecasts, inventory control and accounting.
- Every Excel file is a workbook that can contain more than one worksheet.
- Cell is defined as the space where a specified row and a column intersect.
- Worksheets can contain labels, numbers or formulas.
- Worksheet allows selecting both contiguous and non-contiguous cells.
- A range is a group of cells referenced with a name. The range reference consists of the first and last cell addresses separated by a colon.
- The AutoSum button on the Standard toolbar adds numbers automatically and also suggests the range of numbers to be added.
- Formulas and functions are automatically updated with a change in the source cell or position of the formula.
- In Relative referencing, the reference is adjusted relative to the new location of the formula.
- In Absolute referencing, the cell reference does not change but remains fixed while pasting formulas.
- Functions are pre-written formulas which must begin with an “=” sign.
- Cell ranges can be named and used in place of cell references.
- The AutoFill handle is a very useful tool to fill in logical series.
- Cell comments are additional explanatory notes which can be attached to a cell in a spreadsheet.
- Charts are an excellent tool to present data graphically and also help in analysing and comparing data.
- The most powerful feature of a spreadsheet package is the “What-if analysis”. Using this feature, we can change values and immediately see the effect as the entire worksheet is automatically updated, based on the change in the values.