Final answer:
In Excel 2016, internal hyperlinks are created using the Hyperlink function and can reference named ranges, enhancing document navigation and efficiency.
Step-by-step explanation:
Users can create internal hyperlinks in Excel 2016 using Hyperlink function and named ranges. Hyperlinks in Excel can be used to link to different parts of the same workbook, which makes navigation through large amounts of data more efficient. Utilizing named ranges allows users to reference cells by names instead of cell numbers, creating a more intuitive way of navigating through data.
When creating hyperlinks, it is important to ensure that the links guide users to the intended location within the document, similar to how one would navigate using hyperlinks in a PDF document. To further enhance user experience, visual cues such as color changes (like blue text) or symbols (such as a red square) can be added to indicate the presence of a hyperlink.