Question

3) Manish Sharma wants to refer his questions within same document with figures. Which advance option of MS Excel he should use?​

Answer 1

A user can refer to any text or figure within the same sheet on Microsot Excel by adding a hyperlink of the cell address of the referred word to the designated location. This can be done with the help of the given steps:-

1. Click on the text you want to add the hyperlink to. For instance, select the word which (upon clicking) will direct you to the question(s) within the same document

2. Right-click on that word and the drop-down list appears. Select the Hyperlink... option.

3. On your lefthand side, click on the thumbnail Place in this Document

4. In the Text to display bar, check the word you want to add the hyperlink to.

5. In the Type the cell reference bar, type the cell address (B9, C84, H12, etc) of the question you want to refer to.

6. Click on Ok

In this way, you can refer to the questions within the same document, including words and figures.

Answer 2

There are many advanced options in MS Excel that can be used to place figures within a document.

Explanation:

• First of all, add the hyperlink into the text can be added with a simple click.
• After that, right click on any word and a list will appear on the right side.
• Choose the word in the text display bar and then type the cell address.
• By following the above steps, words and figures can be added to a document.