Question

2.difference between cell and cell address.

Answer 1

A cell is a single box in the excel spreadsheet which has only one row and one column address. In Excel, the rows are listed as numbers and the columns are named as letters. For example, the address of a single data in the 3rd row and 4th column in Excel will be named as D3, where D stands for the column and 3 stands for the row location.

We can define cell range as an area created with different cells combined, or we can say that it is the area created by multiple single boxes in the spreadsheet. We show cell range in Excel with two different parameters, which are the up left corner and the bottom right corner of the data range. For example, if we select a 3x3 area in excel starting from the cell B2, the address of the cell range will be shown as B2:D4.

Answer 2

cell is a intersection of a row and a column but cell address is the location of the cell