Question 2 & 3 New Perspectives Excel 2019 | Module 5: SAM Project 1a
- In cell C5, remove the hyperlink, leaving the unlinked text "Bozeman, MT" in the cell.
- In cell D7, create a hyperlink to an email address as follows:
a. Link to the email address:
washingtonmgr@example.com
b. Use washingtonmgr@example.com as the text to display.
c. Use Email the statewide manager for Washington as the ScreenTip text.
davidmacago asked a year ago
Go ahead and click on cell C5. Noticed that blue, underlined text? That's a hyperlink.
To remove it, simply right-click on the cell and choose 'Remove Hyperlink' from the dropdown.
Voilà! The link's gone!
Now, let's move over to cell D7.
Right-click on the cell and pick 'Hyperlink'. This will open up a little box where we can add our details.
On the left side, you'll see a tab saying 'E-mail Address'. Click on that.
Where it says 'E-mail address', type in: washingtonmgr@example.com.
For the 'Text to display', type in the same: washingtonmgr@example.com.
Now, click on the 'ScreenTip' button. In the box that pops up, type: Email the statewide manager for Washington. This will be a little note that shows up when someone hovers over the link.
Hit 'OK', and you're done!