I need help with the formulas on this excel spread sheet.

TextBook:

Your Office: Microsoft Excel 2016 Comprehensive Pearson With MyITLab.

ISBN: 978-0-13-447956-09

A B DE G K M N PaR Age Group Overall Place Donor Level Place Award Donation Award 600 vu WN Age Group Place Amount Donated 1200 650 300 1400 1500 2500 650 890 510 480 200 150 6 v w NANA 10 11 12 13 14 000 u 100 100 100 1 First Name Last Name 2 Joe Massart 3 Shawn Storms 4 Abbie Brimmer 5 Ciera Torrance 6 Sara Clendenen 7. Brooke Caron 8 Jesse Gilmore 9 Rowben Davis 10 Zoe Brenton 11 Nick Young 12 Carol Steward 13 Trevor Engel 14 Zane Finley 15 Tracy Jones 16 Ryan Angelo 17 Jane Tuttle 18 Samantha Stout 19 Ethan Rose 20 James Moritz 21 Kaden Kennedy 22 Riley Fishback 23 Liz O'Conner 24 Scott Bell 25 Richard Andrews 26 Ava Flanigan 27 Nathan Kirks 28 Adam Pickett 29 Suzie Knabe 30 Blake Knight 31 Jon Korben 32 Ann Williams 15 State West Virginia New York New York Virginia Ohio New York Ohio Ohio New York Ohio Virginia Ohio Ohio New Jersey New York Indiana New York Ohio Ohio New Jersey Ohio Ohio Ohio New York Ohio Montana Virginia Montana New York Ohio Ohio Age Gender 20 M 23 M 23 F 22 F 21 F 23 F 22 F 19 M 18 F 22 M 18 F 23 M 23 M 19 F 19 M 21 F 22 F 20 M 21 M 21 M 18 F 18 F 20 M 18 M 22 F 21 M 21 M 21 F 23 M 22 M 18 F H Relay Pace Relay Time 0.233333333 0.050949074 0.235416667 0.051433912 0.284722222 0.062164352 0.286111111 0.062465278 0.295833333 0.064930556 0.299305556 0.065388889 0.299305556 0.065407407 0.302777778 0.06625 0.304166667 0.066436343 0.304166667 0.066546296 0.304861111 0.066685185 0.314583333 0.068769676 0.315972222 0.069005787 0.316666667 0.069271991 0.317361111 0.069415509 0.327777778 0.071609954 0.329861111 0.072131944 0.334722222 0.073103009 0.336805556 0.073635417 0.342361111 0.074768519 0.34375 0.07509375 0.345138889 0.075458333 0.345138889 0.07546412 0.351388889 0.076758102 0.355555556 0.07772338 0.355555556 0.077724537 0.356944444 0.077934028 0.372222222 0.081283565 0.372222222 0.081305556 0.372222222 0.081383102 0.375 0.08199537 Class Junior Senior Senior Senior Senior Senior Senior Sophomore Freshman Senior Freshman Senior Senior Sophomore Sophomore Senior Senior Junior Senior Senior Freshman Freshman Junior Freshman Senior Senior Senior Senior Senior Senior Freshman 16 00 8 11 17 12 18 19 20 200 300 250 620 325 1100 360 520 13 21 22 23 16 100 24 25 26 27 100 100 320 250 850 400 600 29 30 31 Members Lookup Table Documentation + F G H I J K L M N O P Q R S T 1 Donor Levels 2 Amount Level 5 Basic 10 Basic Plus 25 Bronze 50 Bronze Plus 100 Silver 250 Silver Plus 500 Gold 1000 Gold Plus 2500 Platinum 5000 Platinum Plus 3. Create a formula that determines which age group each member is in based on the member's age. The age groups are Final (over 21), Mid-Level (over 19), and Beginner (over 17). 4. Determine the donation level each member has met based on the Amount Raised column. Use also information on the Lookup Table worksheet. 5. Determine whether a member will be eligible for a place award. A place award is for any members who place first, second, or third in their Age Group or first, second, or third in the Overall Place. If a member qualifies for a place award, the result should be Award. If a member does not qualify for a place award, the cell should be left blank. 6. Determine whether a member will be eligible for a donation award. Members who place in the top 10 of their age group place and have an amount raised of $1,000 or more are eligible for a donation award. If a member is eligible for a donation award, the result should be Award. If a member does not qualify for a donation award, the cell should be left blank. Create a new worksheet containing a summary report table. The committee wants to have the following fundraising results by gender: Total Donors and Total Donations. Format the table to look professional. A B DE G K M N PaR Age Group Overall Place Donor Level Place Award Donation Award 600 vu WN Age Group Place Amount Donated 1200 650 300 1400 1500 2500 650 890 510 480 200 150 6 v w NANA 10 11 12 13 14 000 u 100 100 100 1 First Name Last Name 2 Joe Massart 3 Shawn Storms 4 Abbie Brimmer 5 Ciera Torrance 6 Sara Clendenen 7. Brooke Caron 8 Jesse Gilmore 9 Rowben Davis 10 Zoe Brenton 11 Nick Young 12 Carol Steward 13 Trevor Engel 14 Zane Finley 15 Tracy Jones 16 Ryan Angelo 17 Jane Tuttle 18 Samantha Stout 19 Ethan Rose 20 James Moritz 21 Kaden Kennedy 22 Riley Fishback 23 Liz O'Conner 24 Scott Bell 25 Richard Andrews 26 Ava Flanigan 27 Nathan Kirks 28 Adam Pickett 29 Suzie Knabe 30 Blake Knight 31 Jon Korben 32 Ann Williams 15 State West Virginia New York New York Virginia Ohio New York Ohio Ohio New York Ohio Virginia Ohio Ohio New Jersey New York Indiana New York Ohio Ohio New Jersey Ohio Ohio Ohio New York Ohio Montana Virginia Montana New York Ohio Ohio Age Gender 20 M 23 M 23 F 22 F 21 F 23 F 22 F 19 M 18 F 22 M 18 F 23 M 23 M 19 F 19 M 21 F 22 F 20 M 21 M 21 M 18 F 18 F 20 M 18 M 22 F 21 M 21 M 21 F 23 M 22 M 18 F H Relay Pace Relay Time 0.233333333 0.050949074 0.235416667 0.051433912 0.284722222 0.062164352 0.286111111 0.062465278 0.295833333 0.064930556 0.299305556 0.065388889 0.299305556 0.065407407 0.302777778 0.06625 0.304166667 0.066436343 0.304166667 0.066546296 0.304861111 0.066685185 0.314583333 0.068769676 0.315972222 0.069005787 0.316666667 0.069271991 0.317361111 0.069415509 0.327777778 0.071609954 0.329861111 0.072131944 0.334722222 0.073103009 0.336805556 0.073635417 0.342361111 0.074768519 0.34375 0.07509375 0.345138889 0.075458333 0.345138889 0.07546412 0.351388889 0.076758102 0.355555556 0.07772338 0.355555556 0.077724537 0.356944444 0.077934028 0.372222222 0.081283565 0.372222222 0.081305556 0.372222222 0.081383102 0.375 0.08199537 Class Junior Senior Senior Senior Senior Senior Senior Sophomore Freshman Senior Freshman Senior Senior Sophomore Sophomore Senior Senior Junior Senior Senior Freshman Freshman Junior Freshman Senior Senior Senior Senior Senior Senior Freshman 16 00 8 11 17 12 18 19 20 200 300 250 620 325 1100 360 520 13 21 22 23 16 100 24 25 26 27 100 100 320 250 850 400 600 29 30 31 Members Lookup Table Documentation + F G H I J K L M N O P Q R S T 1 Donor Levels 2 Amount Level 5 Basic 10 Basic Plus 25 Bronze 50 Bronze Plus 100 Silver 250 Silver Plus 500 Gold 1000 Gold Plus 2500 Platinum 5000 Platinum Plus 3. Create a formula that determines which age group each member is in based on the member's age. The age groups are Final (over 21), Mid-Level (over 19), and Beginner (over 17). 4. Determine the donation level each member has met based on the Amount Raised column. Use also information on the Lookup Table worksheet. 5. Determine whether a member will be eligible for a place award. A place award is for any members who place first, second, or third in their Age Group or first, second, or third in the Overall Place. If a member qualifies for a place award, the result should be Award. If a member does not qualify for a place award, the cell should be left blank. 6. Determine whether a member will be eligible for a donation award. Members who place in the top 10 of their age group place and have an amount raised of $1,000 or more are eligible for a donation award. If a member is eligible for a donation award, the result should be Award. If a member does not qualify for a donation award, the cell should be left blank. Create a new worksheet containing a summary report table. The committee wants to have the following fundraising results by gender: Total Donors and Total Donations. Format the table to look professional