Instructions are on the first screenshot thank you !

D E G H K L M N O P Q R S T V W Price Per Hour Piano Uniform Size XL M L XL XL XL | XXL XL 1 Student Data 2 StudentID StudentName Instrument 3 000001 Zia White 4 000002 Pandora Brock Drums 5 000003 Inez Clements Viola 6 000006 Summer Sweeney Drums 7 000008 Violet Ward Guitar 8 000010 Hyatt Waters Drums 9 000016 Pamela Lambert Cello 10 000018 Kennan Meyer Piano 11 000020 Anastasia Marshall Cello 12 000022 Rina Stanley Guitar 13 000025 Lee Hayden Violin 14 000028 Amena Sanchez Guitar 15 000033 Belle Solomon Trumbone 16 000044 Mari Sweet Violin 17 000049 Grace Reeves Oboe 18 000053 Germaine Mcmillan Flute 19 000057 Merrill Hull Clarinet 20 000059 Rinah Parks Tuba 21 000060 Lisandra Lane Violin 22 000061 Norman Grimes Cello 23 000062 Nicholas Sloan Tuba 24 000067 Carlos Rose Tuba 25 000068 Daquan Cabrera Drums 26 000072 Lani Golden Flute 27 000074 Evangeline Gaines Clarinet 28 000081 Mara Mosley Trumbone 29 000082 Davis Schmidt Guitar 30 000083 Galvin Todd Piano 31 000084 Paula Eaton Guitar 32 000085 Bertha Rios Bass 33 000086 Inez Chapman Bass 34 000087 Xerxes Atkins Tuba 35 36 Teacher Jenny Chuck Chuck Anne Chuck Jenny Jenny Chuck Jenny Chuck Chuck Anne Chuck Jenny Chuck Chuck Jenny Jenny Jenny S Competition? Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes No Permission Slip Skill level No Advanced Yes Intermediate Yes Intermediate Yes Beginner Yes Advanced Yes Yes Beginner Yes Expert Yes No Intermediate Yes Advanced Yes Advanced No Beginner Yes Beginner Yes Expert Yes Intermediate Yes No Advanced Yes Advanced Yes Advanced No Yes Beginner No Intermediate No Intermediate No Advanced S M | Ixx Expert | XXL IS L Jenny L XL No Jenny Jenny Jenny Anne Anne Jenny Jenny Debbie Chuck Chuck Mark Chuck XXL XL L XL XS L M L | Yes Yes Yes Yes Advanced Intermediate Beginner Advanced Advanced Expert No No No NO 37 29 StudentData LessonData DataTables Report + B D E G H I L M N O P Q R S T V W X Lesson Length Skill Level Total Fee 0.50 1 Lesson Data 2 Date StudentID Student Teacher 3 1/7/2018 000018 Kennan Meyer Jenny 4 1/8/2018 000001 Zia White Chuck 5 1/12/2018 000033 Belle Solomon Chuck 6 1/16/2018 000010 Hyatt Waters Chuck 7 1/17/2018 000018 Kennan Meyer Anne 1/19/2018 000028 Amena Sanchez Chuck 9 1/21/2018 000022 Rina Stanley Debbie 10 2/3/2018 000008 Violet Ward Debbie 11 2/14/2018 000008 Violet Ward Chuck 12 2/16/2018 000001 Zia White Mark 13 2/20/2018 000016 Pamela Lambert Chuck 14 3/10/2018 000002 Pandora Brock Mark 15 4/2/2018 000006 Summer Sweeney Debbie 16 4/15/2018|000022 Rina Stanley Jenny 17 4/16/2018 000006 Summer Sweeney Chuck 18 4/19/2018 000018 Kennan Meyer Chuck 19 4/20/2018 000033 Belle Solomon Chuck 20 5/6/2018 000008 Violet Ward Anne 21 5/7/2018000018 Kennan Meyer Anne 22 5/7/2018 000025 Lee Hayden Mark 23 5/8/2018 000008 Violet Ward Debbie 24 5/9/2018 000028 Amena Sanchez Chuck 25 5/12/2018 000016 Pamela Lambert Anne 26 5/15/2018|000016 Pamela Lambert Mark 27 5/17/2018/000001 Zia White Anne 28 5/21/2018 000010 Hyatt Waters Mark 29 5/29/2018 000001 Zia White Debbie 30 31 32 33 34 1.50 0.50 1.50 2.00 1.00 1.00 1.00 0.50 1.00 1.00 2.00 1.50 1.00 2.00 2.001 1.50 1.00 2.00 0.50 2.00 2.000 1.00 1.50 2.00 0.50 1.00 35 36 37 29 StudentData LessonData DataTables Report + E H L M N o P Q R S U V w Y Z AA 1 Data Tables Registration Fee Early Bird Regular $ 250 S 500 $ Late 750 $ 3 Lesson Pricing 4 5 Beginner 6 Intermediate 7 Advanced 3 Expert 0.5 15 20 25 35 1.0 30$ 25 30 1.5 45$ 30 35 2.0 60 35 40 40 45 50 10 Transportation Fees per Person 11 Flight Bus Charter Drive 0 $ 592 $ 86 $ 125$ 190 13 10 426 84 120 190 14 20 382 82 115 190 15 30 277 80 110 190 16 17 Uniform Fees 18 XS S M L 19 0 $ 42.23 $ 43.21 $ 44.19 $ 45.17 $ 20 15 40.59 41.57 42.55 43.53 21 20 39.01 39.99 40.97 41.95 22 25 38.17 39.15 40.13 41.11 XL XXL 46.15$ 47.13 44.51 45.49 42.93 43.91 42.09 43.07 24 25 26 27 28 29 30 31 32 33 34 35 36 37 StudentData LessonData Data Tables Report Scroll Lock Display Settings B D E G . L M . P R SI U 000018 Regular Bus 1 Student Report 2 Student ID 3 Teacher 4 Average Fee 5 Skill Level 6 Total Lessons 7 Total Paid this Year $ 8 Bonus Lessons Competiton Fees Registration Type Travel Type Uniform Size Uniform Fee Registration Fee Transportation Fee Total 9 10 Competition Report Number Needed Price Per Uniform Size Student Name Permission Slip? Uniform Size Ready to go! XS 0 S 0 M 0 0 0 XL XXL 0 11 Student ID 12 000001 13 000002 14 000003 15 000006 16 000008 17 000010 18 000016 19 000018 20 000020 21 000022 22 000025 23 000028 24 000033 25 000044 26 000049 27 000053 28 000057 29 000059 30 000060 31 000061 32 000062 33 000067 34 000068 35 000072 36 000074 StudentData LessonData DataTables Report #

Question

Instructions are on the first screenshot thank you !

image text in transcribed

D E G H K L M N O P Q R S T V W Price Per Hour Piano Uniform Size XL M L XL XL XL | XXL XL 1 Student Data 2 StudentID StudentName Instrument 3 000001 Zia White 4 000002 Pandora Brock Drums 5 000003 Inez Clements Viola 6 000006 Summer Sweeney Drums 7 000008 Violet Ward Guitar 8 000010 Hyatt Waters Drums 9 000016 Pamela Lambert Cello 10 000018 Kennan Meyer Piano 11 000020 Anastasia Marshall Cello 12 000022 Rina Stanley Guitar 13 000025 Lee Hayden Violin 14 000028 Amena Sanchez Guitar 15 000033 Belle Solomon Trumbone 16 000044 Mari Sweet Violin 17 000049 Grace Reeves Oboe 18 000053 Germaine Mcmillan Flute 19 000057 Merrill Hull Clarinet 20 000059 Rinah Parks Tuba 21 000060 Lisandra Lane Violin 22 000061 Norman Grimes Cello 23 000062 Nicholas Sloan Tuba 24 000067 Carlos Rose Tuba 25 000068 Daquan Cabrera Drums 26 000072 Lani Golden Flute 27 000074 Evangeline Gaines Clarinet 28 000081 Mara Mosley Trumbone 29 000082 Davis Schmidt Guitar 30 000083 Galvin Todd Piano 31 000084 Paula Eaton Guitar 32 000085 Bertha Rios Bass 33 000086 Inez Chapman Bass 34 000087 Xerxes Atkins Tuba 35 36 Teacher Jenny Chuck Chuck Anne Chuck Jenny Jenny Chuck Jenny Chuck Chuck Anne Chuck Jenny Chuck Chuck Jenny Jenny Jenny S Competition? Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes No Permission Slip Skill level No Advanced Yes Intermediate Yes Intermediate Yes Beginner Yes Advanced Yes Yes Beginner Yes Expert Yes No Intermediate Yes Advanced Yes Advanced No Beginner Yes Beginner Yes Expert Yes Intermediate Yes No Advanced Yes Advanced Yes Advanced No Yes Beginner No Intermediate No Intermediate No Advanced S M | Ixx Expert | XXL IS L Jenny L XL No Jenny Jenny Jenny Anne Anne Jenny Jenny Debbie Chuck Chuck Mark Chuck XXL XL L XL XS L M L | Yes Yes Yes Yes Advanced Intermediate Beginner Advanced Advanced Expert No No No NO 37 29 StudentData LessonData DataTables Report + B D E G H I L M N O P Q R S T V W X Lesson Length Skill Level Total Fee 0.50 1 Lesson Data 2 Date StudentID Student Teacher 3 1/7/2018 000018 Kennan Meyer Jenny 4 1/8/2018 000001 Zia White Chuck 5 1/12/2018 000033 Belle Solomon Chuck 6 1/16/2018 000010 Hyatt Waters Chuck 7 1/17/2018 000018 Kennan Meyer Anne 1/19/2018 000028 Amena Sanchez Chuck 9 1/21/2018 000022 Rina Stanley Debbie 10 2/3/2018 000008 Violet Ward Debbie 11 2/14/2018 000008 Violet Ward Chuck 12 2/16/2018 000001 Zia White Mark 13 2/20/2018 000016 Pamela Lambert Chuck 14 3/10/2018 000002 Pandora Brock Mark 15 4/2/2018 000006 Summer Sweeney Debbie 16 4/15/2018|000022 Rina Stanley Jenny 17 4/16/2018 000006 Summer Sweeney Chuck 18 4/19/2018 000018 Kennan Meyer Chuck 19 4/20/2018 000033 Belle Solomon Chuck 20 5/6/2018 000008 Violet Ward Anne 21 5/7/2018000018 Kennan Meyer Anne 22 5/7/2018 000025 Lee Hayden Mark 23 5/8/2018 000008 Violet Ward Debbie 24 5/9/2018 000028 Amena Sanchez Chuck 25 5/12/2018 000016 Pamela Lambert Anne 26 5/15/2018|000016 Pamela Lambert Mark 27 5/17/2018/000001 Zia White Anne 28 5/21/2018 000010 Hyatt Waters Mark 29 5/29/2018 000001 Zia White Debbie 30 31 32 33 34 1.50 0.50 1.50 2.00 1.00 1.00 1.00 0.50 1.00 1.00 2.00 1.50 1.00 2.00 2.001 1.50 1.00 2.00 0.50 2.00 2.000 1.00 1.50 2.00 0.50 1.00 35 36 37 29 StudentData LessonData DataTables Report + E H L M N o P Q R S U V w Y Z AA 1 Data Tables Registration Fee Early Bird Regular $ 250 S 500 $ Late 750 $ 3 Lesson Pricing 4 5 Beginner 6 Intermediate 7 Advanced 3 Expert 0.5 15 20 25 35 1.0 30$ 25 30 1.5 45$ 30 35 2.0 60 35 40 40 45 50 10 Transportation Fees per Person 11 Flight Bus Charter Drive 0 $ 592 $ 86 $ 125$ 190 13 10 426 84 120 190 14 20 382 82 115 190 15 30 277 80 110 190 16 17 Uniform Fees 18 XS S M L 19 0 $ 42.23 $ 43.21 $ 44.19 $ 45.17 $ 20 15 40.59 41.57 42.55 43.53 21 20 39.01 39.99 40.97 41.95 22 25 38.17 39.15 40.13 41.11 XL XXL 46.15$ 47.13 44.51 45.49 42.93 43.91 42.09 43.07 24 25 26 27 28 29 30 31 32 33 34 35 36 37 StudentData LessonData Data Tables Report Scroll Lock Display Settings B D E G . L M . P R SI U 000018 Regular Bus 1 Student Report 2 Student ID 3 Teacher 4 Average Fee 5 Skill Level 6 Total Lessons 7 Total Paid this Year $ 8 Bonus Lessons Competiton Fees Registration Type Travel Type Uniform Size Uniform Fee Registration Fee Transportation Fee Total 9 10 Competition Report Number Needed Price Per Uniform Size Student Name Permission Slip? Uniform Size Ready to go! XS 0 S 0 M 0 0 0 XL XXL 0 11 Student ID 12 000001 13 000002 14 000003 15 000006 16 000008 17 000010 18 000016 19 000018 20 000020 21 000022 22 000025 23 000028 24 000033 25 000044 26 000049 27 000053 28 000057 29 000059 30 000060 31 000061 32 000062 33 000067 34 000068 35 000072 36 000074 StudentData LessonData DataTables Report #