FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -The column header is located above row 1 in the worksheet. The row heading or row header is the gray-colored column located to the left of column 1 in the worksheet containing the numbers (1, 2, 3, etc.) used to identify each row in the worksheet.

Detailed explanation-2: -A cell reference is the set of coordinates that a cell occupies on a worksheet. It identifies the location of a cell in the spreadsheet. A cell reference is always the column letter followed by the row number. For example, the first cell in the top left-hand corner of a worksheet is cell A1.

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: -Rows are referenced by numbers that appear on the left and then run down the Excel screen. The first row is named row 1, while the last row is named 65536.

Detailed explanation-5: -A row header is the column at the left of the table that identifies each row within the table. Row headers are needed if the cells in a column identify the contents of the row, in effect providing a label for the row. These labels are often a key or ID column for the rest of the data.