DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -A contiguous range is any group of selected cells that form either a square or a rectangle. A single cell that is selected is also considered to be a range. Ranges can be selected using the mouse, the keyboard or a combination of the two.
Detailed explanation-2: -Answer: a group of contiguous cells is called a range of cells in Microsoft Excel.
Detailed explanation-3: -A contiguous range of cells is a group of highlighted cells that are adjacent to each other, such as the range C1 to C5 shown in the image above. A non-contiguous range consists of two or more separate blocks of cells. These blocks can be separated by rows or columns as shown by the ranges A1 to A5 and C1 to C5.
Detailed explanation-4: -Range represents a set of one or more contiguous cells such as a cell, a row, a column, or a block of cells.