COMPUTER APPLICATIONS
OFFICE AUTOMATION SOFTWARE
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
The cell reference for cell range of A2 to M12 is ____
|
|
A2!M12
|
|
|
A2.M12
|
|
|
A2;M12
|
|
|
A2:M12
|
Explanation:
Detailed explanation-1: -In the range of cells A2:M12, starting cell is A2 and the ending cell is M12 of that range. In this range of cells total of 143 cells are ranged.
Detailed explanation-2: -A cell reference refers to a cell or a range of cells on a worksheet and can be used in a formula so that Microsoft Office Excel can find the values or data that you want that formula to calculate.
Detailed explanation-3: -What is a range reference in Excel? In Microsoft Excel, a range is a block of two or more cells. A range reference is represented by the address of the upper left cell and the lower right cell separated with a colon. For example, the range A1:C2 includes 6 cells from A1 through C2.
There is 1 question to complete.