USING MICROSOFT EXCEL
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
cell
|
|
|
formula
|
|
|
range
|
|
|
function
|
Detailed explanation-1: -A group of cells is known as a cell range. Rather than a single cell address, you will refer to a cell range using the cell addresses of the first and last cells in the cell range, separated by a colon. For example, a cell range that included cells A1, A2, A3, A4, and A5 would be written as A1:A5.
Detailed explanation-2: -Range in statistics is simply the difference between the highest and lowest values in a set of data. For example, the lowest to the highest values of a salary dataset might be $10, 000 to $50, 000. In this case, the range of the data is $40, 000, as $50, 000-$10, 000 = $40, 000.
Detailed explanation-3: -Range of a variable In the case of an integer, the variable definition is restricted to whole numbers only, and the range will cover every number within its range (including the maximum and minimum). For example, the range of a signed 16-bit integer variable is all the integers from −32, 768 to +32, 767.
Detailed explanation-4: -A cell range in an Excel file is a collection of selected cells. This range is usually symmetrical (square), but can exist of separate cells just the same. A cell range can be referred to in a formula as well.