Hello dear tutor, the screen shot attached in the below is my Excel assignment file. Can you help me with the Formula for each question? I couldn't put the file here because it shows an error. So, I wrote each question just write down the formula for each question. It's not necessary to write the formula with all the details, just show me how is it look like and I figure out the rest by myself. Thank you!

1)In cellI15, enter a function to extract the StartYearof Membership. Copy the function down to the other cells in the column.

InI1enter a function to calculate how many members started membership after the year2008.

2)In cellJ15,enter a function to extract the StartMonthof Membership. Copy the function down to the other cells in the column.

InJ1enter a function to calculate how many members started membership afterthe month ofMay.

3)In cellK15, enter a function to extract the StartDayof Membership. Copy the function down to the rest of the cells in the column.

InK1enter a function to calculate how many members started membershipon orafter the 15th dayof the month.

4)In cellL15, enter a function to calculate theDaysof Membership. Copy the function down to the rest of the cells in the column.

InL1enter a function to calculate theaverageDays of membership for all the members.Format as comma style, 0 decimal.

5)In cellM15, enter a formula to calculate theYearsof Membership. Copy the formula down to the other cells in the column.

InM1enter a function to calculate theaverageYears of membership for members in the Gardening Club.Format as comma style,1decimal.

6)In cellN15, enter a formula to calculate theDaily Cost of Membership.Copy the formula down to the other cells in the column.

InN1enter a function to calculate theaverageDaily Cost of membership forfemalemembers.Format as currency style, 2 decimals.

7)In cellO15, enter a formula to calculate theMonthly Cost of Membership.Copy the formula down to the other cells in the column.

InO1enter a function to calculate thetotalMonthly Cost of membership for memberships which started before the month of July.Format as currency style, 2 decimals.

8)In cellP15, enter a formula to calculate theMembership Cost for the period(from start to end of membership).(Hint:Multiply the Annual Cost of membership by the Years of Membership).Copy the formula down to the other cells in the column.

InP1enter a function to calculate thetotalMembershipCost for the period for all members.Format as currency style, 2 decimals.

9)In cellQ15, enter an IF function:

If theMembership Cost for the periodis more than $10,000,enter Yes,otherwise the cell should be bank.Copy the function down to the other cells in the column.

InQ1enter a function to calculate how manymembers got yes.

10)In cellR15, enter an IF function:

If theYears of Membershipis 5 or more, reduce the Annual membership by50%(Hint: multiply the Annual Cost of Membership by 50%),

If theYears of Membershipis 3 or more, reduce the Annual membership by25%(Hint: multiply the Annual Cost of Membership by 75%),

otherwise reduce the Annual Cost of Membership by10%(Hint: multiply the Annual Cost of Membership by 90%).Copy the function down to the other cells in the column.

InR1enter a function to calculate thetotalLoyalty Membership Renewal.Format as comma style,0decimal.

11)In cellS15, enter nested IF functions:

If theClubisScuba,enter500,

If the ClubisGardening,enter400,

If theClub isRock Climbing, enter700, otherwise enter300.Copy the function down to the other cells in the column.

InS1enter a function to calculate thetotalClub Discount.Format as comma style,0decimal.

12)In cellT1, enter the SUMIFS function to calculate thetotalAnnual Cost of Membership forfemalemembers of theWeight watchersclub.Format as comma style,0decimal.

13)In cellU1, enter the AVERAGEIFS function to calculate theaverageAnnualCost of Membership formalemembers in thegardeningclub.Format as comma style,0decimal.

14)Use theSimple Filter to answer the following question.

How many members arefemaleAND started membershipafter the Year 2005AND are in aWeight Watchers Club? Enter the answer inQ1.

AutoSave OFF QUIZ 4 MEMBERSHIP CLUB STUDENT FILE Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Arial Narrow v 12 A A ab v General Conditional Formatting Insert v ex Delete v Paste 2 7 V >T V $ ~ % " Format as Table BIUV Cell Styles v Format v X v Sort & Find & Ideas Filter Select 115 X fx B C D E F G H I J K L M N 0 P Q R S U V Purpose: To calculate club membership payments over a period using various date functions How many members 2 Date 6/24/20 started membership after 2008? Created By: Kimia Ansari Ram Club Membership 10 11 12 13 Annual Cost Start Month Daily Cost of Membership High Loyalty Membership ID Last Name First Start Day of| Days of Years of Monthly Club Name Gender Of Club Start Date End Date Start Year of of Cost of Membership |Membershi Membershi Membershi Membersh Membershi Membershi Cost over Membershi Membership p Payment Discount 14 Membership p ip the Period Renewal 15 1 10279 Alvardo Marion $1,641.00 Weight Watcher 1-Mar-13 11-Jan-18 16 11094 Ramirez Jorge $1,423.00 Book 24-Oct-04 12-Dec-14 11494 Gines Becky $1,257.00 Scuba 30-Sep-12 7-Aug-15 18 11517 Smith Alvin $2,076.00 Scuba -Jun-02 19-Aug-10 19 111832 Wallace Anthony $2,233.00 Gardening 5-Apr-04 16-Jun-15 11903 Zahn Xavier $1,264.00 Rock Climbing 29-Mar-13 7-Nov-17 12242 Bonny Karina $1,227.00 Book 7-Jul-11 2-Sep-15 12660 Connolly Aaron $1,552.00 Rock Climbing 30-Apr-14 7-Oct-17 12790 Ellerman Claretta $1,569.00 Book 2-Jul-09 18-May-18 12979 Anderson Amy $1,657.00 Rock Climbing 20-Feb-02 2-Dec-16 13135 Carlson Tyler $1,626.00 Book 23-Jun-17 2-Dec-19 113452 Coleman Patrick $2,144.00 Weight Watchenov-12 23-Oct-16 13584 Allan Kim $1,321.00 Gardening 17-Sep-03 16-Jan-07 13592 Wensien Karen $1,978.00 Weight Watchers 15-Jul-15 2-Jan-20 13803 Longmore | Cecil $2,484.00 Rock Climbing 23-Sep-08 20-Jul-12 14088 Caine Francis $1,264.00 Scuba 8-Aug-14 22-Mar-18 114093 Carsley Mark $1,807.00 Hiking 23-Dec-06 28-Dec-13 114332 Coombs Hailey $1,282.00 Weight Watche 22-Apr-03 29-Jun-14 114404 Moses Marcella $1,640.00 Gardening 13-Jan-05 18-Feb-13 1 14512 Benson Maxim $1,439.00 Scuba 25-Jun-11 28-Jul-19 1 14573 Henshaw Jeffrey $1,966.00 Scuba 20-Dec-14 12-Oct-19 1 14626 Fredericksen Johnathan M $1,615.00 Weight Watche 19-Jun-09 16-Jun-19 . . .. . . 1 - . Sheet1 + Cell 11 note by dulcie + 86%