Some Web sites impose certain rules for passwords. Write a function that checkswhether a string is a valid password. Suppose the password rules are as follows:A password must have at least eight characters. A password must consist of only letters and digits. A password must contain at least two digits. Write a program that prompts the user to enter a password and displays validpassword if the rules are followed or invalid password otherwise.

def check_password(pwd):

   c=0

   d=0

   for i in pwd:

       if (i>='a' and i<='z') or (i>='A' and i<='Z'):

           c+=1

       elif i>='0' and i<='9':

           d+=1

           c+=1

   if len(pwd)==c and d>=2 and len(pwd)>=8:

       print("valid password")

   else:

       print("Invalid password")

ps=input("Enter password for checking : ")

check_password(ps)

Explanation:

a) click on any cells in the range of data

b) click the data

c) click sort& filter group, click sort

d) select the column to sort by and then select a sort order

e) select the next column to sort by and select the sort order

f) click ok