COMPUTER SOFTWARE
APPLICATION SOFTWARE
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Cell
|
|
|
Text Box
|
|
|
Label
|
|
|
None of the above
|
Detailed explanation-1: -A cell is the intersection point of a column and a row.
Detailed explanation-2: -The intersection of a row and a column is called a cell.
Detailed explanation-3: -Items in row are aligned from left to right, while columns are aligned from top to bottom. A row is a horizontal alignment of data, while a column is vertical. Data in a row contains information that describes a single entity, while data in a column describes a field of information all entities possess.
Detailed explanation-4: -The intersection of row and column is called a cell. Each cell in Excel has its own address, which is made up of the column letter and row number.
Detailed explanation-5: -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. Here is the formula that can do that: =B2:C13 B5:D5. More items