MO-211 practice question 28 of 35
What is the shortcut to insert a hyperlink in Excel?
Full set: 355 questionsDomain Insert and format text, shapes, and images
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.
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.
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").
Keep practicing
Take the free MO-211 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other MO-211 practice questions
- Question 1What formula can be used to calculate the sum of a range of cells in Excel?
- Question 2Which chart type is best used to display trends over time?
- Question 3What is the formula used in Excel to calculate the percentage change between two numbers?
- Question 4What is a slicer in Excel?
- Question 5What is the shortcut key to insert a new worksheet in Excel?
- Question 6What is the shortcut key for copying a formula in Excel?
