USING MICROSOFT EXCEL
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: -When working with large amounts of data in Microsoft Excel, it is often necessary to select a contiguous range of cells. This can be done easily by clicking on the first cell in the range, holding down the Shift key, and then clicking on the last cell in the range. The entire range will then be selected.
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.