Need help with this asap please!:)

B6 fx First Name: N 0 Q R S T U V W 1 2 3 4 5 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. 6 7 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 8 9 Use data validation as appropriate and change the background color of favorite color to match 10 11 Format to a common professional standard 12 Go Stumpies! 13 14 15 Last name Apple Baker Chang Dole Earl Farmer Grace Hollister Ingram 16 First Name Alan Brenda Charlie Danny Earl Fannie Gerald Hank Ike 17 Spouse Anna Bob Clair Deloris Ethyl Frank Geraldine Deceased Isadore 18 Occupation Author Butcher Cashier Dance Instructor Essayist Farmer Grocer Horseman Inker 19 #Children 5 3 2 1 4 0 10 3 20 #Grandchildren 15 10 2 3 8 3 0 20 0 21 Favorite Color Red Blue Red Blue Red Purple Green Green Yellow 22 Favorite Food Apples Beans Cheese Doughnuts Eggplant Franks Gummies Ham Ice cream 23 24 25 26 27 SLOCKS All Data Colu et & Transform Data Queries & Con... Data Types Sort & Filter B6 fx First Name: A B C D 1 2 3 East Tree Stump High School Alumnus Data Sheet 4 5 6 7 8 First Name: Last Name: Spouse Occupation: Children: Grandchildren: Favorite Color: Favorite Food: 9 10 11 12 13 4 15 16 17 18 19 20 21. 22 23 24 25 26 B6 fx First Name: N 0 Q R S T U V W 1 2 3 4 5 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. 6 7 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 8 9 Use data validation as appropriate and change the background color of favorite color to match 10 11 Format to a common professional standard 12 Go Stumpies! 13 14 15 Last name Apple Baker Chang Dole Earl Farmer Grace Hollister Ingram 16 First Name Alan Brenda Charlie Danny Earl Fannie Gerald Hank Ike 17 Spouse Anna Bob Clair Deloris Ethyl Frank Geraldine Deceased Isadore 18 Occupation Author Butcher Cashier Dance Instructor Essayist Farmer Grocer Horseman Inker 19 #Children 5 3 2 1 4 0 10 3 20 #Grandchildren 15 10 2 3 8 3 0 20 0 21 Favorite Color Red Blue Red Blue Red Purple Green Green Yellow 22 Favorite Food Apples Beans Cheese Doughnuts Eggplant Franks Gummies Ham Ice cream 23 24 25 26 27 SLOCKS All Data Colu et & Transform Data Queries & Con... Data Types Sort & Filter B6 fx First Name: A B C D 1 2 3 East Tree Stump High School Alumnus Data Sheet 4 5 6 7 8 First Name: Last Name: Spouse Occupation: Children: Grandchildren: Favorite Color: Favorite Food: 9 10 11 12 13 4 15 16 17 18 19 20 21. 22 23 24 25 26