USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
contiguous range
|
|
|
noncontiguous range
|
|
|
series
|
|
|
active cells
|
Detailed explanation-1: -contiguous range. a block of adjacent cells in a worksheet. noncontiguous range. cells in a worksheet that act as a block, but are not necessarily adjacent to each other. format.
Detailed explanation-2: -RANGE. A range is a group of two or more cells in a worksheet. The cells in a range can be adjacent or nonadjacent. Commands executed by Excel will affect the entire range. A range is identified by the cell references of the cells in the upper left and lower right corners of the range.
Detailed explanation-3: -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. Both contiguous and non-contiguous ranges can include hundreds or even thousands of cells and span worksheets and workbooks.
Detailed explanation-4: -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.
Detailed explanation-5: -In a spreadsheet, a cell range is defined by the reference of the upper left cell (minimum value) of the range and the reference of the lower right cell (maximum value) of the range. Eventually separate cells can be added to this selection, then the range is called an irregular cell range.