DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
We want to make a Payment Type Column as a drop-down list. Which feature should we use?
|
|
Conditional formatting
|
|
|
Data validation
|
|
|
Bulleted list
|
|
|
Absolute cell reference
|
Explanation:
Detailed explanation-1: -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. Check the In-cell dropdown box.
Detailed explanation-2: -Select a cell where you want a drop-down list. Click the DATA tab, and click Data Validation. In the Data Validation dialog, set Allow to List; this enables a list in the cell. Leave In-cell drop-down selected; this enables a drop-down list in the cell.
There is 1 question to complete.