# 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.

Calculate the price
Pages (550 words)
\$0.00
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with Online Academic Experts
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
Testimonials
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Emergency Management
Overall, I think it's a great service. I have yet to submit the assignment, so I don't know what kind of grade I'll get. But customer service was excellent. Reviews were made and the assignment proofed for satisfaction.
Customer 453015, December 15th, 2021
English 101
very good paper thank you.
Customer 453083, February 18th, 2022
Classic English Literature
It was my first time using such a service. Essay was good and nicely formatted.
Customer 452441, February 16th, 2022
History
Looks great and appreciate the help.
Customer 452675, April 26th, 2021
Psychology
Customer 453027, January 15th, 2022
Amazing!
Customer 452985, November 11th, 2021
Health Care
The writer did not follow my choice of topic (Food/Water Insecurity, Hunger, & Poverty), the paper was instead written about Climate Change in Africa. However, the paper was still great and informative. Thank you!
Customer 452777, January 28th, 2022
Nursing
Impressive writing
Customer 452547, February 6th, 2021
awesome work
Customer 453201, June 15th, 2022
Human Resources Management (HRM)
Always great! My son has been in critical health these last few semesters. Many times I have thought he wasn't going to make it and thought about quitting or postponing school until he was healthier but it always happens to be in the middle of the semester. This service has been a lifesaver for my mindset in helping keep my grades up and keep my son alive at the same time. I don't know if I could have made it through this period without it.
Customer 453077, June 6th, 2022
awesome job
Customer 453201, June 24th, 2022
Education
N/A
Customer 453057, May 23rd, 2022
11,595
Customer reviews in total
96%
Current satisfaction rate
3 pages
Average paper length
37%
Customers referred by a friend