Microsoft Technology Guru Contest Round 2 – Question # 11

You are trying to link to the region demonstrated by cells F10 through G11 in Sheet1 from another sheet, Sheet3. You are using the cell J9 on Sheet3 as the hyperlink. Which of the following texts will you type in the 'Cell Reference" box while creating the hyperlink so that the region is linked to?
By 'region', we mean a rectangular box made of cells as its part.

1. Sheet1!F10,G11
2. Sheet3!J9:F10,G11
3. Sheet1!F10:G11
4. Sheet3!G11:F10

 

How to participate:

  • Answer the above question and providing your email address along.
  • Only the answer provided with email address will be marked.
  • Only the first correct answer will be considered.
  • For further details kindly refer to the Competition Rules and Guidelines.