DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Under which Tab, the Data validation options are available in MS Excel?
|
|
Data
|
|
|
Insert
|
|
|
Review
|
|
|
View
|
Explanation:
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: -Step 1-Select The Cell For Validation A data validation dialogue box will appear having 3 tabs-Settings, Input Message, and Error Alerts.
Detailed explanation-3: -The four types of data are text, number, logical and error.
There is 1 question to complete.