For example, the third column of row F on a spreadsheet would be referenced as F3. Column width originally defaults to a standard size upon creation of the worksheet. These can be changed based on user requirements. Users can change the characteristics of each column and row, as well as those within each cell. Likewise, columns and rows can be added to, or deleted from the spreadsheet.
Calculations are the primary purpose in using spreadsheet software.
A formula is created that uses there is values in the cells, columns, rows, or ranges of spreadsheet. If the spreadsheet starts out with the value of 1 in A1 and the value of 2 in A2, the result of 3 in A3 bold automatically be calculated. The type of data being entered onto a spreadsheet dictates the activities that can be performed on it. Any alphanumeric text that is entered to identify a specific portion of the worksheet i.e. titles, column headings, row headings or other text is considered to be a label and cannot be used in data calculation. Numeric values that are entered into a cell can be part of a calculation, or formula.