USING MICROSOFT EXCEL
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: -The intersection of a column and row in a spreadsheet is called a bon or cell.