need explanation

11. Second, add a timeline slicer that displays Payment date and move it to the Dashboard worksheet. Place between the range J27:034. Show payments between 02 2019 to 02 2020 (ensure your timeline displays in Quarters, not Months). (2 marks) 12. On the Dashboard worksheet, you will calculate some summary statistics. Starting in C11, use COUNTIF to count the number of student records that are enrolled in each language program. Be sure to use the Records Table from the Student Records worksheet and structured names in your formulas. Copy and adjust the function for each of the other program totals. (2 marks) 13. In cell C15 use SUMIF to display a Total Tuition by program. Copy and adjust the function for each of the other program totals, as necessary. (3 marks) 14. In C19 use AVERAGEIF to find the average balance by program. Copy and adjust the function for each of the other program totals, as necessary. (3 marks) Tvel Aedes Dute Help 15 ml 29 Conden we Formatting Title It- NE VOICE MORE COMMUNICATION COLLEGE Student Payment Records Lalle $ 2700000 $ 120000 Eros Erg 4-3-19 5 12.15 6-20-19 7.30-19 Hent Spon Bron 10-15-19 T-37-19 Presh Hindi Po 6000 10000 5 00:00 13.3000 $ 250000 1 100 DO $ 230000 13.000 DO $ 2.000 599 Patie Chow Lee 1 3-20 20 425-30 471 Min 2.15-20 9.20 Wag Boh Engla Cheese Spanish Spanish Spa Englah Era Englan 1-1-19 8 2019 $ 1.000.00 2350700 530000 5 230000 Aban 454 Won Love Ponomato Table Sangh Singh Odore VOICEMORE -- 5 5 B00.00 -C Eng 2.30000 - 20 Program Meals Cost Dashboard Student Records Domy . Type here to search Text 2 A Da Fe Home Page Layout Formulas Data Review View Heb Century Gothic West General Merge & Center - $ % 9 nat Conditional FC Formatting Table Style 1 Part Hint Number 5 N21 A H 4792 Famider 4751 Judo 471 Cathy 530d $10.00 3200 English Soon English Bro 4 43-19 5-12-19 4785 Wendy os 200.00 3 2 2 7.2.1 12:19 83 Catilde Frunch Engi Span French 00000 1.000.00 2.000.00 1.300.00 TO $ 119000 Lee ISI 2 40. Arch 11-93-19 1-1-20 25 Purles Hagan Boyd 4670 French 4 W ene 3 20 20 4-2020 20 7.15-20 2-9-20 -15-20 LS 1-1-19 5 2.404.00 $2.715.00 579.00 10.00 1.2000 310.00 Rosemarie 41 42 4532 Kendo Sposi English Hind Erge Segna Free More 450 Pada 30. Senden 1.800.00 1.000.00 B000 2.800.00 3 45 Choudhar 6-6-19 11-4-30 5.620 3-24-19 18000 1 2 2 4528 Vonont French French English Chaudhary $ $ 200.00 2.000.00 2,200.00 Dashboard Student Records Program Materials Cou DOCT- + DET VDICEMORE Station ENTIR O chous Pete Type here to search RI Hot German w File Hoane Draw Page Layout Formulas View X Century Gothic General Paste 23 Wrap Menge a Center Alignment $ % 92.99 Conditional Format Formatting table CA HBO Clipboard Font Number stes R14 AB 1 VUICE MORE COMMUNICATIVN CULLEGE P 4 5 6 7 Ergish Gemmar Hind Tuition Tuition Tuition 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 Balance Balance Balance Documentation VOICEMORE Dashboard Student Records Program Materials Cost Docum Seed denon and pe D choose Paste Type here to search O RI 11. Second, add a timeline slicer that displays Payment date and move it to the Dashboard worksheet. Place between the range J27:034. Show payments between 02 2019 to 02 2020 (ensure your timeline displays in Quarters, not Months). (2 marks) 12. On the Dashboard worksheet, you will calculate some summary statistics. Starting in C11, use COUNTIF to count the number of student records that are enrolled in each language program. Be sure to use the Records Table from the Student Records worksheet and structured names in your formulas. Copy and adjust the function for each of the other program totals. (2 marks) 13. In cell C15 use SUMIF to display a Total Tuition by program. Copy and adjust the function for each of the other program totals, as necessary. (3 marks) 14. In C19 use AVERAGEIF to find the average balance by program. Copy and adjust the function for each of the other program totals, as necessary. (3 marks) Tvel Aedes Dute Help 15 ml 29 Conden we Formatting Title It- NE VOICE MORE COMMUNICATION COLLEGE Student Payment Records Lalle $ 2700000 $ 120000 Eros Erg 4-3-19 5 12.15 6-20-19 7.30-19 Hent Spon Bron 10-15-19 T-37-19 Presh Hindi Po 6000 10000 5 00:00 13.3000 $ 250000 1 100 DO $ 230000 13.000 DO $ 2.000 599 Patie Chow Lee 1 3-20 20 425-30 471 Min 2.15-20 9.20 Wag Boh Engla Cheese Spanish Spanish Spa Englah Era Englan 1-1-19 8 2019 $ 1.000.00 2350700 530000 5 230000 Aban 454 Won Love Ponomato Table Sangh Singh Odore VOICEMORE -- 5 5 B00.00 -C Eng 2.30000 - 20 Program Meals Cost Dashboard Student Records Domy . Type here to search Text 2 A Da Fe Home Page Layout Formulas Data Review View Heb Century Gothic West General Merge & Center - $ % 9 nat Conditional FC Formatting Table Style 1 Part Hint Number 5 N21 A H 4792 Famider 4751 Judo 471 Cathy 530d $10.00 3200 English Soon English Bro 4 43-19 5-12-19 4785 Wendy os 200.00 3 2 2 7.2.1 12:19 83 Catilde Frunch Engi Span French 00000 1.000.00 2.000.00 1.300.00 TO $ 119000 Lee ISI 2 40. Arch 11-93-19 1-1-20 25 Purles Hagan Boyd 4670 French 4 W ene 3 20 20 4-2020 20 7.15-20 2-9-20 -15-20 LS 1-1-19 5 2.404.00 $2.715.00 579.00 10.00 1.2000 310.00 Rosemarie 41 42 4532 Kendo Sposi English Hind Erge Segna Free More 450 Pada 30. Senden 1.800.00 1.000.00 B000 2.800.00 3 45 Choudhar 6-6-19 11-4-30 5.620 3-24-19 18000 1 2 2 4528 Vonont French French English Chaudhary $ $ 200.00 2.000.00 2,200.00 Dashboard Student Records Program Materials Cou DOCT- + DET VDICEMORE Station ENTIR O chous Pete Type here to search RI Hot German w File Hoane Draw Page Layout Formulas View X Century Gothic General Paste 23 Wrap Menge a Center Alignment $ % 92.99 Conditional Format Formatting table CA HBO Clipboard Font Number stes R14 AB 1 VUICE MORE COMMUNICATIVN CULLEGE P 4 5 6 7 Ergish Gemmar Hind Tuition Tuition Tuition 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 Balance Balance Balance Documentation VOICEMORE Dashboard Student Records Program Materials Cost Docum Seed denon and pe D choose Paste Type here to search O RI