1. Open Lessons. Lessons 2. Save the workbook with the name 5-Lessons. 3. The current worksheet is shown in Figure 5.1. The hourly rates in the range B4:B12 are linked to the cell named BaseRate, which is cell B15. For intermediate lessons and advanced lessons, $4 and $8, respectively, added to the hourly base rate. 4. The Drum Studio wants to earn $4,770 per month from teaching lessons (instead of the current total of $4,298). Use the Goal Seek feature to chang the base hourly rate to the value required to reach the studio's target. 5. Save, print, and then close 5-Lessons. Figure 5.1 Visual Benchmark 1 A B C THE DRUM STUDIO 2 MONTHLY DRUM LESSON REVENUE Registered Monthly 3 Class Hourly Rate Students Revenue 4 Basic Drum Theory 35.00 10 350.00 5 Beginner Rock Drumming 35.00 15 525.00 6 Intermediate Rock Drumming 39.00 8 312.00 7 Advanced Rock Drumming 43.00 4 172.00 8 Beginner Jazz Drumming 35.00 18 630.00 9 Developing Jazz Style 39.00 10 390.00 10 Single Pedal Drum Beats 35.00 22 770.00 11 Single Pedal Drum Fills 35.00 15 525.00 12 Bass Drum Doubles 39.00 16 624.00 13 TOTAL 4,298.00 14 15 Base hourly rate for all lessons: 35.00