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: