DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
meeting between worksheets
|
|
|
meetings between workbooks
|
|
|
intersection of rows and columns
|
|
|
rectangular group of cells
|
Detailed explanation-1: -Cell: A cell is a rectangular area formed by the intersection of a column and a row. Cells are identified by the Cell Name (or Reference, which is found by combining the Column Letter with the Row Number. For example the cell in Column “C” in Row “3” would be cell C3.
Detailed explanation-2: -A cell is the intersection point of a column and a row. Data entered into Excel is always stored in a cell.
Detailed explanation-3: -In the worksheet, rows range from 1 to 1, 048, 576, while columns range from A to XFD.
Detailed explanation-4: -Intersect Operator in Excel can be used to find the intersecting value(s) of two lists/ranges. This an unusual operator as it is represented by a space character (yes that’s right). If you use a space character in between two ranges, then it becomes the Intersect operator in Excel.
Detailed explanation-5: -A cell range in Ms Excel is a collection of chosen cells. It can be referred to in a formula. This is defined in a spreadsheet with the reference of the upper-left cell as the minimum value of the range and the reference of the lower-right cell as the maximum value of the range.