NEED NOW!! Josiah needs to create an internal link to cell A4 on a worksheet named Sales Data within the same workbook that he is presently working in.
What is the correct syntax for this scenario?
=A4
=Sales!A4
=A4!Sales!
=A4Sales!

Respuesta :

Answer:

=Sales!A4

Explanation:

The correct method is as explained above. However, there is an alternative as well. You are just required to right-click on the cell and select the hyperlink, and select place in the document. Now enter the cell to be referenced, text to display and select the right sheet, and finally press OK. And you are done. Or you can directly get this done with the help of the above formula. Both of the options are correct.