USING MICROSOFT EXCEL
HOW TO INSERT HEADERS FOOTERS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
4-D
|
|
|
3-D
|
|
|
2-D
|
|
|
1-D
|
Detailed explanation-1: -3-D range. a range that spans two or more worksheets in a workbooks such as ‘Westgate Mall: Reston Plaza ‘! C6 is called a 3-D range.
Detailed explanation-2: -A reference that refers to the same cell or range on multiple sheets is called a 3-D reference.
Detailed explanation-3: -As noted above, an Excel 3D reference lets you refer to the same cell or a range of cells in several worksheets. In other words, it references not only a range of cells, but also a range of worksheet names. The key point is that all of the referenced sheets should have the same pattern and the same data type.
Detailed explanation-4: -Range represents a set of one or more contiguous cells such as a cell, a row, a column, or a block of cells.
Detailed explanation-5: -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.