DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
rectangular group of cells
|
|
|
intersection of lines and columns
|
|
|
meetings between workbooks
|
|
|
meeting between worksheets
|
Detailed explanation-1: -Range: A range is a group of cells in a spreadsheet that have been selected. If the cells are all together in a rectangular or square shape, it is an adjacent range. An adjacent range is identified by the cell reference in the upper left and lower right corners of the selection separated by a colon. (Example: A3:B5).
Detailed explanation-2: -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-3: -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-4: -Answer: A cell range is a collection of selected cells. This cell range is usually symmetrical (square).