Question

To use a sheet reference, which address is appropriate out of the following options?
a. D4! Sheet 1. b. Sheet1,D4. c. Sheet1! D4

Answer 1

Answer:

Sheet1, D4

I am not sure about the answer.

Answer 2

Answer:

sheet1!D4 option (c).