Please solve this in excel for me showing all formulas

Part 1-Data tab of the Excel template shows information about winners of the best actress and best actor awards at the Academy Awards, a film industry awards show better known as the Oscars, between the years 1929 and 2018. The data shows the Oscar number (sequential number to represent each Oscar ceremony, starting with the first Academy Awards in 1929), the year each award was given, the title for the award (best actress or best actor), the recipient of the award, the movie the actress/actor appeared in to earn the award, the age the actress/actor was when they earned the award, the birthplace (the location where the actress/actor was bornlisted as either a US state or a country), birth month (1 representing January, and so on), birth day, and birth year.

Using this dataset, please answer the questions below. Please show all your work, provide commentary if necessary.

1. Who are the most decorated (with the most wins) actor and actress? Please state the number of wins and list the movies they appeared to win these awards. Please use a pivot table.

2. For a given year and type of award (best actor or actress), please return the name of the winner and the corresponding movie. Please use the appropriate data validation techniques and VLOOKUP/XLOOKUP or INDEX/MATCH functions.

3. Provide a list of actors and actresses with a non-US birthplace. What is the international location with the most winners? Please comment.

4. For a given birthplace, please calculate the average age of winners from a specific birthplace.

5. Provide a list of actors/actresses with the same birthdays. Please make sure that your list has the winners name only once (in case a person wins multiple times).