FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -A cell reference, or cell address, is an alphanumeric value used to identify a specific cell in a spreadsheet. Each cell reference contains one or more letters followed by a number. The letter or letters identify the column and the number represents the row.

Detailed explanation-2: -A reference is a cell’s address. It identifies a cell or range of cells by referring to the column letter and row number of the cell(s). For example, A1 refers to the cell at the intersection of column A and row 1.

Detailed explanation-3: -These letters and numbers are called row and column headings. To refer to a cell, type the column letter followed by the row number. For example, D50 refers to the cell at the intersection of column D and row 50.

Detailed explanation-4: -Understanding cells Columns are identified by letters (A, B, C), while rows are identified by numbers (1, 2, 3). Each cell has its own name-or cell address-based on its column and row. In the example below, the selected cell intersects column C and row 5, so the cell address is C5.

Detailed explanation-5: -The cell is called a block which is the insertion point of rows and columns. It is used to hold the data. It is present in all the table which is made up of rows and columns. When any user wants to read any particular cell, then he can do it with the help of rows number and column number.