ECDL Exam ECDL-ADVANCED Topic 3 Question 46 Discussion

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.

NOTE

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