BUSINESS ADMINISTRATION
BUSINESS ANALYTICS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
B1-E5
|
|
|
B1:E5
|
|
|
B1 to E5
|
|
|
B1$E5
|
Detailed explanation-1: -In Excel, B1: E5 is used to denote a range from B1 through E5.
Detailed explanation-2: -Expert-Verified Answer In an Excel file, a cell range is a collection of selected cells. A cell range can also be referenced in a formula. 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).
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.
Detailed explanation-4: -To select a cell range; Therefore, the A1 TO D6 represents the desired cell range that is columns and rows denotes the letters and numbers.
Detailed explanation-5: -Detailed Solution. The correct answer is A1: A10. In Microsoft Excel, a range is a collection of cells.