write a formula in cell d15 to calculate the average verbal scores for each type (t/r) of student application. write the formula so that it may be copied down the column and across the row into cells d15:f16 to calculate the average for regular students verbal sat and then for each catagory math sat ect

D15 Evaluation of Candidates 2 Weight in final score 20% 40% 40% Verbal Math SCi Weighted SAT SAT SATI score 4 Mary Keck 5 Alex Jones 6 Mark Wale 7 Timoty Watkins 8 Scott Sharp 9 Brent Smith 10 AVERAGE 11 MINIMUM 12 MAXIMUM 580 640 670 660 710 730 70167 73167 66500 680 770 700 590 690 780 670 690 730 780 800 720 636 686 700 694 742 736 699.00 636.00 742.00 R 590.00 600 580.00636 78000 80000 73000 #of AVG AVG students (verbal)(math) (SCI) AVG 14 15 transfer students T 16 regular students R 3.00 3.00 Sheet1 Sheet2 Sheet3