The Instructions are given to make an excel file, The excel file made according to the given instructions is required

1 RSVP Y Y N Y Adults 2 1 3 0 2 3 Kids 2 0 0 2 3 4 5 6 7 8 N Y N 0 0 0 2 1 0 1 N N Y N 2 0 2 0 0 2 Y Y Guest SARA AMIN JOHN Jerome Dan John Clint David Angela Timothy Vic James Sharon Mike Alan Harold Paul Mark William Jay Thad Mathew Jose Jared Teague Jeff Goro Pegg Brian Steve Invited By Groom Bride Bride Groom Bride Groom Bride Groom Bride Groom Groom Bride Groom Groom Bride Groom Groom Bride Groom Groom Groom Bride Bride Bride Bride Groom Bride Bride Groom Groom Relation Colleague Family Friend Family Colleague Colleague Family Colleague Family Friend Friend Colleague Family Family Friend Colleague Friend Colleague Family Friend Friend Colleague Friend Colleague Friend Colleague Family Friend Colleague Family 1 0 0 0 0 0 5 0 0 1 Y N Y Y 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 1 0 2 1 0 0 0 2 N Y Y N N Y Y N 0 1 2 2 0 1 1 0 0 0 Y Y 0 1 1 0 0 2 1 0 1 1 1 N N 1 0 N 1 31 32 33 34 Tony Smith Julia James baker Robins Groom Groom Bride Bride Groom Family Colleague Family Friend Colleague Y N Y 2 3 2 2 0 0 0 0 N N 0 0 0 35 Y 0 The Excel file labeled WEDDING contains a guest list for an upcoming wedding. The file contains the names of the people invited, who invited them (i.e., bride or groom), whether they have responded that they are coming or not (Y or N), and how many people are coming (broken down by adults and children). As the wedding coordinator, you must provide the bride and groom with a number as to how many people are coming to the wedding. Create a template in Excel that contains the following information. *Total number of guests who will be attending, broken down by adults and children. *A total amount for the cost of the reception ($17.50 per adult, children only cost 67% of this amount). Do not forget to add on the 8.25% tax. *Sort this guest list first, by who invited them (i.e., bride or groom). Then sort by the relation of the guest to the bride or groom. *In your Template, create two charts. One offers the number of guests who will be attending by who invited them (i.e., bride or groom). The second provides the breakdown of the number of adults and children who will be attending. Save your file with the name XXXwed.xls (where XXX are your initials