I need help with this excel problem. I have never used excel and I need as specific help as I can get. including where i should put calculations and where to find specific functions. "Scenario

You are working for a medical clinic. Your supervisor reached out to see if you can create a spreadsheet to help track information relating to well$-$child check$-$ups. The management team wants to know the number of patients who completed their well$-$child visits and the total amounts for the billed and paid check$-$ups. Using the Rounding function, you will need round various services offered by the clinics. Also, you will need to rank the services.

Requirements

Sheet$1$

Rename Sheet$1$ as "Data".

Replace the patient named "Donovan Kelling" with your name.

Create three named ranges for the "Billed", "Amount Paid", and "Well$-$Child Visit Completed" columns. The ranges should include rows $3$ to $102.$ These named ranges will make the following calculations much easier.

Apply the filter feature to the whole range of data and use it to sort the patients alphabetically by their first name, A to Z$.$ Leave the filter feature ON $($meaning you will still see little arrows on the first row of each column$).$

Use a Count function $($like COUNTA or COUNTBLANK$)$ and named range to calculate the number of well$-$child visits completed. Label the cell with a heading.

Use the SUM function and named range to calculate the total amount billed. Label the cell with a heading.

Use the SUM function and named range to calculate the total amount paid. Label the cell with a heading.

Sheet $2$

Rename Sheet$2$ as "Services".

In the column labeled "Rounded Prices" use the ROUND function to round the "Price" to the nearest hundredth, meaning $$151\mathrm{.}257$ would become $$151\mathrm{.}26,$ and $$44\mathrm{.}239$ would become $$44\mathrm{.}24.$ While a number format makes a price appear to be rounded, using the round function actually changes the value to be the rounded amount.

In the "Overall Ranking" column, use the RANK.EQ function to rank the services in descending order, meaning $1$ will have spent the most money.

The workbook must look professional, meaning that you should take time to clean up each worksheet. Focus on the following areas:

Color each tab.

Format any currency cells with a dollar sign $ $($e$.$g$.,$ billed and paid and columns$).$

Make the headings stand out $($i$.$e$.$ bold OR color OR underline, etc.$)$

Services Prices Rounded Prices Overall Ranking Back pain evaluation $120\mathrm{.}235674$ Bug bites & stings $52\mathrm{.}4543$ Headache & Migraine Evaluation $110\mathrm{.}1111$ Irritable bowel syndrome $($IBS$)$ evaluation $136\mathrm{.}6733$ Minor burns $99\mathrm{.}9699$ Minor cuts, blisters & wounds $54\mathrm{.}4543$ Pelvic pain evaluation $59\mathrm{.}9977$ Splinter removal $56\mathrm{.}331$ Sprains, strains & joint pain $23\mathrm{.}6714$ Suture & staple removal $99\mathrm{.}2215$ Swollen veins & leg pain treatment $49\mathrm{.}8716$ Tick bites $44\mathrm{.}1231$ Skin, hair & nails $38\mathrm{.}3716363636364$ Acne $32\mathrm{.}6201212121212$ Athlete's foot $46\mathrm{.}2390476190476$ Chicken pox $41\mathrm{.}3904761904762$ Cold, canker & mouth sores $36\mathrm{.}5419047619048$ Hairloce $35693333333323$

Patient Name Patient ID # Birthdate City Well$-$Child Visit Completed Billed Amount Paid Donovan Kelling $388-10-28861/6/21$ Rigby, Idaho Yes $$50$ $$0$ Genevie Hipple $388-11-13509/24/16$ Rexburg, Idaho $$0$ $$0$ Claude Darbonne $388-12-16584/30/22$ Rigby, Idaho $$0$ $$0$ Jeanna Landrum $388-13-84231/12/19$ Idaho Falls, Idaho $$0$ $$0$ Kristeen Silsby $388-14-48761/31/16$ Idaho Falls, Idaho Yes $$50$ $$25$ Theresa Nixon $388-15-90799/19/22$ Idaho Falls, Idaho Yes $$50$ $$50$ Pamela Rohman $388-16-93869/24/16$ Rigby, Idaho $$0$ $$0$ Mattie Nave $388-17-38257/17/17$ Idaho Falls, Idaho $$0$ $$0$ Chrystal Deppe $388-18-154011/7/19$ Idaho Falls, Idaho $$0$ $$0$ Concha Mccleskey $388-19-498212/27/14$ Idaho Falls, Idaho $$0$ $$0$ Lavonne Jacko $388-20-29389/25/16$ Idaho Falls, Idaho Yes $$50$ $$0"$ I also included a pic of the rubric. New Project: Healthcare