Use the sheet reference which address is appropriate
Answers
Answered by
8
Answer:
To use the Sheet Reference, which address is appropriate out of the following options a) D4! SHeet1 b) Sheet1, D4 c) Sheet1! D4
Right Answer is Sheet1! D4
Sheet1! Representing the Sheet from which data need to be fetched.
D is the column
4 is the row
We can use $ before column , if we need to fix column
& We can Use $ before row , if we need to fix row
Sheet1! D4 is right answer
Explanation:
Similar questions