DATABASE FUNDAMENTALS
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: -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.
Detailed explanation-4: -A cell reference or cell address is a combination of a column letter and a row number that identifies a cell on a worksheet. For example, A1 refers to the cell at the intersection of column A and row 1; B2 refers to the second cell in column B, and so on.