Back to lesson
1. What is the keyboard shortcut for editing an existing hyperlink?
CTRL + E
SHIFT + K
CTRL + K (Insert Hyperlink)
2. When hyperlinking to another worksheet (in general, rather than a specific section), which cell is best selected as the destination cell?
Cell A5, as this cues the sheet to be displayed after the Headings section
Cell A1, as this resets the worksheet to the top of the page
The CTRL + HOME cell, as this resets the worksheet to the top of the page
3. Why should the destination of a hyperlink be given a range name?
It is not essential that the destination cell is given a range name
The model is more transparent for end users
If the worksheet name were to change, the hyperlink would still work
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement