Question

To use the Sheet reference, which address is appropriate out of the following options?
Sheet1!D4?
Sheet1.D4
Sheet1!D4
Sheet1, D4
​

Answer 1

Answer:

sheet1,D4

is the answer i think

Answer 2

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