To use the Sheet Reference, which address is appropriate out of the following options a) D4! SHeet1 b) Sheet1, D4 c) Sheet1! D4
Answers
Answered by
15
Answer:
the answer is sheer 1! D4
Answered by
6
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.
Similar questions