FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -In any spreadsheet program such as Excel, each rectangular box in a worksheet is referred to as a cell. A cell is the intersection point of a column and a row. Data entered into Excel is always stored in a cell.

Detailed explanation-2: -Intersection of a Single Row and Column Now if you use =C2:C13 B5:D5 [Note there is a single space in between the ranges, which is also our intersect operator in Excel], it will return 523 (the value in cell C5), which is the intersection of these 2 ranges.

Detailed explanation-3: -A intersection of Row and column in a spreadsheet template is known as Cell.

Detailed explanation-4: -By default, Excel uses the A1 reference style, which refers to columns as letters (A through IV, for a total of 256 columns), and refers to rows as numbers (1 through 65, 536). These letters and numbers are called row and column headings. To refer to a cell, type the column letter followed by the row number.

Detailed explanation-5: -Find intersection of two lists with formula Select a blank column, copy formula =IF(ISERROR(MATCH(B2, $C$2:$C$9, 0)), "", B2) into the Formula Bar and then press the Enter key. See screenshot: Note: In the formula, B2 is the first cell of the first list, $C$2:$C$9 is the range of the second list.