Partager via

Microsoft Technology Guru Contest Round 2 – Question # 11

  • Article

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.

Comments

  • Anonymous
    February 08, 2012
  1. Sheet1!F10:G11 aqeel.ahmed5@hotmail.com
  • Anonymous
    February 08, 2012
    I would use option 3 "Sheet1!F10:G11 " for the hyper link. E Mail: arun.passioniway@hotmail.com
  • Arun Kumar Allu
  • Anonymous
    February 09, 2012
  1. Sheet1!F10:G11 Email : ib_22_dik@yahoo.com

  • Anonymous
    February 09, 2012
    Answer :  Sheet1!F10:G11 Email : rex.rony@hotmail.com

  • Anonymous
    February 09, 2012

  1. Sheet1!F10:G11 Email : adilsiddiq98@yahoo.com
  • Anonymous
    February 12, 2012
  1. Sheet1!F10:G11 ahsan_766@hotmail.com
  • Anonymous
    February 23, 2012
    3.Sheet1!F10:G11 azizarshad@hotmail.com