USING MICROSOFT EXCEL
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: -Select the cell where you want a drop-down list. Click Data Validation, select List, click in Source, press F3, select the name, click OK, and click OK again. Verify the cell contains the drop-down list with the entries provided by the named range, and copy the list to the other cells.
Detailed explanation-3: -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.