Which of the following options will you use in the spreadsheet to accomplish the task?

You are working on a report on Microsoft Excel 2010 for your organization. You need to link a cell to
a Web page that displays some graphical reports of the past accounting year. Which of the following
options will you use in the spreadsheet to accomplish the task?

You are working on a report on Microsoft Excel 2010 for your organization. You need to link a cell to
a Web page that displays some graphical reports of the past accounting year. Which of the following
options will you use in the spreadsheet to accomplish the task?

A.
Pivot Table in the Tables ribbon at the Insert tab.

B.
Conditional Formatting in the Styles ribbon at the Home tab.

C.
Hyperlink in the Links ribbon at the Insert tab.

D.
Screenshot in the Illustrations ribbon at the Insert tab.

Explanation:
According to the question, you are required to link a cell to a Web page. In order to accomplish the
task, you will have to create a hyperlink for the cell. For this, use the Hyperlink option in the Links
ribbon at the Insert tab. In Excel 2010, a hyperlink refers to the setting where a cell can be linked to a
Web page, a picture, an e-mail address, or a program. A cell can be hyperlinked through the
Hyperlink option in the Links ribbon in the Insert Tab.

When a hyperlink is applied to a cell, on clicking the link, it opens the linked item in a separate window.
Answer A, B, and D are incorrect. These steps will not accomplish the task.



Leave a Reply 0

Your email address will not be published. Required fields are marked *