Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. please answer on an excel spreadsheet with formula

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

90.2K

Verified Solution

Question

Accounting

please answer on an excel spreadsheet with formula and explanations, thank you!
image
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

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students