You have several options when you want to enter data manually in excel. Data can be put into more than one cell, which should be an important key to your answer. In <u>SEVERAL CELLS AT THE SAME TIME</u> or more. The data can be entered in dates, text, times, or numbers. Fortmatting the data can be done in a possibility of ways. Therefore, several settings is what you can adjust.
This is not a question It's free 5 points!
You type the equal (=) sign into a cell to start a formula.
for example, =SUM(B1:B5)
Answer:
#main function start
def main():
#list to store names entered by user
name_list=[]
#variable to take input from user to keep rotating the loop and take input from user again and again
ch='y'
fname=""
lname=""
while ch=='y' or ch=='Y':#keep the loop taking input from user till user do not want to enter more
#take input from user
name=[]
fname=input("Enter first name: ")
lname=input("Enter last name: ")
name.append(fname)
name.append(lname)
#append the previously input first and last name in main list
name_list.append(name)
ch=input("Do you want to continue: (y/Y for yes)")
#main function end
#get file name from user
filename=input("Enter output file name")
#open file in write mode
file=open(filename,"w")
#keep loop add data in file till main list 'name_list' have
for i in name_list:
#Write data in file
file.write("%s, %s\r\n" % (i[0],i[1]))
#close the file
file.close()
#call main function
main()
Explanation:
input the above code and see output