USING MICROSOFT EXCEL
USING DATA VALIDATION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
true
|
|
|
false
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -When mailing your clients, you may often see more than one invalid email. Thanks to Microsoft Excel, you can identify these email addresses and correct them as required. This process is also known as data cleansing.
Detailed explanation-2: -Google, Yahoo, and Microsoft have a handy feature called the email address checker, whose purpose is to identify whether the user entered the email address of the account they want to recover correctly. And this simple tool can help you verify whether an email address is legitimate and valid.
Detailed explanation-3: -Most email service providers (ESPs) provide email validation services. There are many free tools that also validate email addresses; ValidateEmailAddress, EmailValidator and Pabbly Email Verification are few of such examples.
Detailed explanation-4: -You can use data validation to restrict the type of data or values that users enter into cells.