You want to conduct research to find out the birthdays for 24 of your favourite celebrities. You…

You want to conduct research to find out the birthdays for 24 of your favourite celebrities. You will use that data to calculate their ages and whether you are younger, older, or the same age and by how much. Open e07b2celebs, and then save it as e07b2celebs_LastnameFirstname. Enter your name, gender, and birth date in the range A6:C6. Enter a function to display today’s date in cell C5, and then use a date function to calculate your age in years in cell D6. Use Help to learn which function to use. Research celebrities, entering the information in the same format as the first celebrity’s data that already exists in the worksheet. Use the same date function to calculate their ages to one decimal place. Use a nested IF function in column E to determine if the celebrity is younger by, older by, or The same age! as you. Apply conditional formatting for the three different answers. Calculate the difference in years using the same function as you used to calculate ages. Make sure the difference appears as a positive number by using the ABS function. Use an IF function to display years if the celebrity is not the same age as you. Display a ranking for each person based on his or her birth date compared to everyone else, where the oldest celebrity has a rank of 1. Enter appropriate math, statistical, and lookup functions to answer the questions in the Interesting Facts range. Apply appropriate formats throughout the worksheet. Enable the Analysis ToolPak, and generate Descriptive Statistics using the Age column. Create a footer with your name, the sheet name, and the file name on each worksheet. Save and close the workbook, and submit based on your instructor’s directions.