Concept of Cell Address
Concept of Cell Address
The column range is the number of cells spread across the column. The cell address is represented by single column letter and multiple row number in a sequence. In this example the column letter C is constant with rows varying from 2 to 7. The range of cells starts in C2 and ends in C7. This range of cells consists of the cells, namely C2, C3, C4, C5, C6, and C7. The range of cells starts in C2 and ends in C7 and it is represented by C2:C7
The row range is the number of cells spread across the row. The cell address is represented by single row number with columns varying from B to D columns. The range of cells starts in B3 and ends in D3. This range of cells consists of the cells, namely B3, C3, D3, and it is represented by B3:D3
The row and column range is the number of cells spread across the row and columns. This range is a matrix with number of rows and number of columns. In this example, the range starts in cell B2 and ends in cell C7. This range of cells consists of the cells from B2 to B7 and cells from C2 to C7. The range it is represented by B2:C7 as shown in Figure 4.7. Note: The control key is used to select more than one ‘range of cells’ in a worksheet. The control key is marked as ‘Ctrl’ on the keyboard.
- 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.