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
151
Answer:
Sheet1! D4
Explanation:
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
Answered by
38
Answer:
(c) sheet1! D4 ....
.
.
I think it will help u....
Similar questions