DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
the LIST function
|
|
|
DATA VALIDATION
|
|
|
NAME MANAGER
|
|
|
a VLOOKUP function
|
Detailed explanation-1: -Select the cell in the worksheet where you want the drop-down list. Go to the Data tab on the Ribbon, then click Data Validation . On the Settings tab, in the Allow box, click List . If it’s OK for people to leave the cell empty, check the Ignore blank box.
Detailed explanation-2: -To create a drop-down list, start by going to the Data tab on the Ribbon and click the Data Validation button. The Data Validation window will appear. The keyboard shortcut to open the Data Validation window is Alt, A, V, V . You’ll want to select List in the drop-down menu under Allow.
Detailed explanation-3: -Go to Data > Data Validation. On the Settings tab, click in the Source box, and then on the worksheet that has the entries for your drop-down list, select all of the cells containing those entries. You’ll see the list range in the Source box change as you select.