Question

To use the Sheet Reference, which address is appropriate out of the following options a) D4! SHeet1 b) Sheet1, D4 c) Sheet1! D4​

Answer 1

Answer:

the answer is sheer 1! D4

Answer 2

The correct answer is Sheet1! D4.

Explanation:

• Sheet1! Represents the Sheet from which data were fetched.
• Whenever you copy a formula from one row to another, it changes according to the position of the rows and columns.
• For example, if you copy =A1+B1 from row 1 to row 2 the formula becomes =A2+B2.