MO-211 practice question 28 of 35

What is the shortcut to insert a hyperlink in Excel?

Full set: 355 questions

Domain Insert and format text, shapes, and images

Answer options
A: Ctrl + H
B: Ctrl + J
C: Ctrl + L
D: Ctrl + K Correct answer
Correct Answer:
D. Ctrl + K
Explanation

The keyboard shortcut Ctrl + K is the standard command in Microsoft Excel to open the "Insert Hyperlink" dialog box. This function allows a user to create a link from a cell to a webpage, a file, a place within the current document, or an email address. This shortcut is consistent across the Microsoft Office suite, including Word, PowerPoint, and Outlook, providing a uniform user experience for this common task. Its purpose is to streamline the process of adding navigational links to a worksheet, enhancing its interactivity and usability.

Why Incorrect

A. Ctrl + H opens the "Find and Replace" dialog box with the "Replace" tab active, used for substituting text or values.
B. Ctrl + J is not a standard shortcut for inserting hyperlinks. It is sometimes used to insert a line break within a cell.
C. Ctrl + L is a shortcut to open the "Create Table" dialog box, which is used to format a range of cells as an Excel table.

References

1. Microsoft Corporation. (n.d.). Keyboard shortcuts in Excel. Microsoft Support. Retrieved from https://support.microsoft.com/en-us/office/keyboard-shortcuts-in-excel-1798d9d5-842a-42b8-9c99-9b7213f0040f. (See section: "Frequently used shortcuts").

2. Indiana University. (2023, October 24). Keyboard shortcuts for Microsoft Excel. UITS Knowledge Base. Retrieved from https://kb.iu.edu/d/ackw. (See section: "Editing").

3. University of Wisconsin-Madison. (n.d.). Excel: Keyboard Shortcuts. Software Training for Students. Retrieved from https://it.wisc.edu/library/knowledgebase/excel-keyboard-shortcuts/. (See section: "General Program Shortcuts").

Scroll to Top