Question

To use the sheet reference, which address is appropriate out of the following option

Answer 1

Answer:

Sheet 1 D4 Is The Correct Answer

Explanation:

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

Answer 2

Answer:

sheet1 D4

Explanation:

I hope it is right answer please follow me on brain list