DATABASE FUNDAMENTALS
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
range
|
|
|
contiguous range
|
|
|
noncontiguous range
|
|
|
group
|
Detailed explanation-1: -Expert-Verified Answer. A block of adjacent cells in a worksheet that is highlighted or selected is called a range.
Detailed explanation-2: -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-3: -A range that contains no blank rows or columns. A range that contains a good header row. A range that had consistent data types down each row of the column.
Detailed explanation-4: -RANGE. A range is a group of two or more cells in a worksheet. The cells in a range can be adjacent or nonadjacent.
Detailed explanation-5: -To select a range, select a cell, then with the left mouse button pressed, drag over the other cells. Or use the Shift + arrow keys to select the range. To select non-adjacent cells and cell ranges, hold Ctrl and select the cells.