BUSINESS ADMINISTRATION
COMPUTER APPLICATION IN BUSINESS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
If I am trying to apply Sheet Referencing to cell A3 of Sheet2, I should use ____
|
|
=!Sheet2A3
|
|
|
=Sheet2!A3
|
|
|
=A3Sheet2!
|
|
|
=!A3Sheet2
|
Explanation:
Detailed explanation-1: -To reference a cell or range of cells in another worksheet in the same workbook, put the worksheet name followed by an exclamation mark (!) before the cell address. For example, to refer to cell A1 in Sheet2, you type Sheet2!A1. For example, to refer to cells A1:A10 in Sheet2, you type Sheet2!A1:A10.
Detailed explanation-2: -Formula to refer a cell A3 in sheet named S1 is(1 Point) =S1A3. =S1.
There is 1 question to complete.