Alan is a student of DFH Public School. He is creating a project report using Microsoft Excel XP. In the process of creating a project, he needs to frequently open a file that he has already created. Therefore, he wants to assign this file as a hyperlink to the 'Research' button on the Standard toolbar. Which of the following steps will he take to accomplish the task?
According to the question, Alan has to assign a file as a hyperlink to the 'Research' button on the Standard toolbar. In order to accomplish the task, he should use the Customize dialog box to assign a hyperlink to a toolbar button or menu command.
Take the following steps to assign a hyperlink to a toolbar button or menu command:
Choose Tools > Customize from the menu bar.
NOTE: The toolbar that has to be changed should be visible.
The Customize dialog box will open. With the Customize dialog box open, perform one of the following actions:
To assign a hyperlink to the toolbar button, right-click on the toolbar button, and then choose Assign Hyperlink > Open from the short-cut menu.
To assign a hyperlink to the menu command, right-click on the menu command on the menu, and then choose Assign Hyperlink > Open from the short-cut menu.
The Assign Hyperlink dialog box will appear. Use this dialog box to select the file or Web page to be linked to. A user can also type the file path or Web address in the Address box.
Click the OK button to close the Assign Hyperlink dialog box. In the Customize dialog box, click the Close button.
The main function of the toolbar button and menu command is replaced by a hyperlink.
A hyperlink can not be assigned for a button that displays a list or menu.
Answer option A is incorrect. These steps are used to change the appearance of a hyperlink text. The Hyperlink option is found in the Style name box when a worksheet contains a hyperlink text. Answer option D is incorrect. These steps are incorrect since there is no Hyperlink option available in the shortcut cut menu if a user right-click on the toolbar button.
Answer option C is incorrect. These steps are used to turn off the automatic formatting of a hyperlink. Reference: Microsoft Excel Help, Contents: ' Assign a hyperlink to a toolbar button or menu command'
Chapter: ADVANCED SPREADSHEETS
Objective: Data Handling
Top of Form
Bottom of Form