USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Data
|
|
|
Insert
|
|
|
Review
|
|
|
View
|
Detailed explanation-1: -On the Data tab, in the Data Tools group, click Data Validation. On the Settings tab, in the Allow box, select List. In the Source box, type your list values, separated by commas.
Detailed explanation-2: -Data validation is a feature in Excel which is used to control what users can enter into a cell. It allows you to dictate specific rules. It also allows users to display a custom message if users try to enter invalid data.
Detailed explanation-3: -Settings Tab The tab helps us choose the desired validation rules from the built-in options we want to allow in selected cells. Moreover, we can also set custom rules with the customized formula to validate user inputs. The settings tab contains all the data validation options present in Excel.
Detailed explanation-4: -To find the cells on the worksheet that have data validation, on the Home tab, in the Editing group, click Find & Select, and then click Data Validation. After you have found the cells that have data validation, you can change, copy, or remove validation settings.
Detailed explanation-5: -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.