please answer on an excel spreadsheet with formula and explanations, thank you!

Instructions: East Tree Stump High School is planning a 50 year reunion "Back to your Roots". As part of the reunion, the class president is putting together little data sheets for each attendee. Use a lookup function to create the data sheets for each alumnus as soon as the last name is entered. When no last name is present, the data sheet should be blank Use data validation as appropriate and change the background color of favorite color to match Format to a common professional standard Go Stumpies! Last name First Name Spouse Occupation Children #Grandchildren Favorite Color Favorite Food Apple Baker Chang Alan Brenda Charlie Anna Bob Claire Author Butcher Cashier 5 3 15 10 Red Blue Red Apples Beans Cheese Dole Earl Farmer Danny Earl Fannie Deloris Ethyl Frank Dance Instructor Essayist Farmer 2 1 4 3 8 Blue Red Purple Doughnuts Eggplant Franks Grace Hollister Ingram Gerald Hank Ike Geraldine Deceased Isadore Grocer Horseman Inker 3 0 10 3 0 20 Green Green Yellow Gummies Ice cream NN Ow