DOW Hours DrPay 5 7 Answer the questions below using sorts or autofilters, or both. 3 (1) The age of the oldest patient who has had a Phrenology appointment. 0 1 (2) What percentage of all patients are both medicare and state resident patients? 2 3 (3) Total of all DrPay for appointments lasting 45 minutes or less? 4 5 (4) Total earnings for Alexandra and Ingrid Fletcher 6 7 (5) How much more money has been spent on state residents than non state residents? 8 9 0 No formulas in any of the cells above. 1 2 3 4 DrLastName DrFirstName DrSpeciality DrRate PaGender PaAge Medicare 5 Fletcher Alexandra Aversion Therapy $75.00 F 67 Yes 6 Cline Juan Brain Surgery $275.00 M 78 Yes 7 Fletcher Alexandra Aversion Therapy $75.00 F 78 Yes 8 Chapas Jodi Podiatry $105.00 F 62 Yes -9 Chapas Jodi Podiatry $105.00 M 87 No 0 Fletcher Alexandra Aversion Therapy $75.00 F 72 Yes 1 Chapas Jodi Podiatry $105.00 M 90 No 2 Fletcher Alexandra Aversion Therapy $75.00 F 59 Yes 3 Lopez Jared Cosmetology $45.00 M 37 No 4 Hadyka Thaisy Substance Abuse $40.00 M 50 No 5 Shuemaker Megan Phrenology $75.00 F 92 Yes 6 Chapas Jodi Podiatry $105.00 M 61 No 7 Shuemaker Barbara Phrenology $75.00 M 90 Yes 8 Hadyka Thaisy Substance Abuse $40.00 M 50 No 9 Shuemaker Megan Phrenology $75.00 M 90 Yes 0 Shuemaker Megan Phrenology $75.00 M 90 Yes -1 Chapas Jodi $105.00 M 52 Yes 2 Hadyka Thaisy Substance Abuse $40.00 M 67 Yes 3 Cline Juan Brain Surgery $275.00 M 50 No 4 Shuemaker Megan Phrenology $75.00 F 88 Yes 5 Shuemaker Megan Phrenology $75.00 F 78 Yes 6 Chapas Jodi Podiatry $105.00 F 58 Yes | Financial1 Financial2 GoalSeek1 GoalSeek2 GoalSeek3 SolverProblem 1 State Res Date Timeln Yes 01-Oct-98 8:15:00 AM Yes 01-Oct-98 8:30:00 AM Yes 01-Oct-98 8:45:00 AM Yes 01-Oct-98 8:45:00 AM Yes 01-Oct-98 9:15:00 AM Yes 01-Oct-98 12:00:00 PM No 01-Oct-98 12:00:00 PM Yes 01-Oct-98 12:30:00 PM Yes 01-Oct-98 12:30:00 PM Yes 01-Oct-98 1:00:00 PM Yes 26-Oct-98 12:45:00 PM Yes 02-Oct-98 9:30:00 AM Yes 12-Oct-98 9:30:00 AM No 02-Oct-98 10:15:00 AM No 20-Oct-98 9:15:00 AM Yes 26-Oct-98 12:15:00 PM Yes 02-Oct-98 1:00:00 PM No 02-Oct-98 1:30:00 PM Yes 05-Oct-98 8:15:00 AM Yes 26-Oct-98 11:15:00 AM Yes 20-Oct-98 11:30:00 AM No 05-Oct-98 8:15:00 AM SolverProblem SolverProblem3 TimeOut 10:15:00 AM 9:15:00 AM 9:45:00 AM 10:30:00 AM 10:45:00 AM 12:45:00 PM 12:30:00 PM 1:00:00 PM 2:45:00 PM 2:30:00 PM 1:15:00 PM 10:15:00 AM 10:30:00 AM 12:30:00 PM 11:15:00 AM 12:30:00 PM 4:00:00 PM 2:00:00 PM 9:15:00 AM 11:30:00 AM 12:30:00 PM 9:30:00 AM Data Questions Podiatry Rules 1
