Question

3To use the sheet reference, which address is appropriate out of the following options. What

is the purpose of sheet reference?

D4!Sheet1

Sheet1,D4

Sheet1!D4​

Answer 1

Answer:

I can't understand the question itself bro...

Mark me as brainliest bro.

Thanks

Gud night

Answer 2

Explanation:

QUESTION

To use the Sheet Reference, which address is appropriate out of the following options a) D4! SHeet1 b) Sheet1, D4 c) Sheet1! D4

ANSWER-

Right Answer is Sheet1! D4

✴️Sheet1!  Representing the Sheet from which data need to be fetched.

✌️D is the column

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