DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
B2-F5
|
|
|
F5:B2
|
|
|
B2:5F
|
|
|
(B2:F5)
|
Detailed explanation-1: -A cell range is specified in a spreadsheet by the reference of the upper left cell (minimum value) and the reference of the lower right cell (highest value). The excel range notation A1:D6 denotes from upper left cell A1 to bottom right cell D6.
Detailed explanation-2: -Answer: In Excel, B1: E5 is used to denote a range from B1 through E5. Explanation: The range is used to showing the data that spreads between two fields i.e. Between maximum and minimum values.
Detailed explanation-3: -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.