The correct answer is D. Lookup wizard.
A lookup wizard is a tool that helps you create a drop-down list of values to choose from. You can use a lookup wizard to create a list of values from a table or range of cells in your workbook, or from a list of values that you type in.
A lookup wizard is a great way to make sure that your data is consistent and accurate. It can also save you time, because you don’t have to type in the same values over and over again.
To create a drop-down list of values using a lookup wizard, follow these steps:
- In the cell where you want to create the drop-down list, click Data > Data Tools > Lookup Wizard.
- In the first step of the wizard, select the option to create a list from a range of cells or a table.
- In the second step, select the range of cells or table that contains the values you want to include in the drop-down list.
- In the third step, select the column that contains the values you want to appear in the drop-down list.
- In the fourth step, select the format you want to use for the drop-down list.
- In the fifth step, review your choices and click Finish.
The lookup wizard will create a drop-down list in the cell you selected. When you click on the drop-down list, you will see a list of the values you selected in the wizard. You can then select the value you want to use.
Here is a brief explanation of each option in the question:
- A. Ole object: An OLE object is an object that is created in another program and inserted into a Microsoft Office document. For example, you can insert a Microsoft Excel chart into a Microsoft Word document.
- B. Hyperlink: A hyperlink is a link to another file or web page. When you click on a hyperlink, it will open the file or web page that it is linked to.
- C. Memo: A memo is a type of document that is used to communicate information to one or more people. Memos are typically short and to the point.
- D. Lookup wizard: A lookup wizard is a tool that helps you create a drop-down list of values to choose from.