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 items from a table or range of cells, or you can create a list of items that you type in yourself.
To create a drop-down list with a Lookup Wizard, follow these steps:
- In the cell where you want to create the drop-down list, click the Data tab.
- In the Data Tools group, click Data Validation.
- In the Data Validation dialog box, in the Allow box, select List.
- In the Source box, type the range of cells or the list of items that you want to include in the drop-down list.
- Click OK.
A drop-down list will appear in the cell. When you click the drop-down list, a list of items will appear. You can select an item from the list, or you can type a new item.
A Lookup Wizard is a powerful tool that can help you create accurate and efficient data entry. It is a valuable tool for any user who needs to create a drop-down list of values.
The other options are not correct because they do not create a drop-down list of values to choose from.
- OLE Object is a type of object that can be inserted into a document. It can be a picture, a chart, or a spreadsheet.
- Hyperlink is a link to another document or website.
- Memo is a type of document that can be used to store notes or information.
I hope this helps!