Excel: Project 1 (21 pts) 5pm Points 21 Submitting an external tool 2019 In Practice - Ch 2 Independent Project 2-5 V. Lui che vupy a vu T Edit the formula in cell D5 to show D$4 instead of "D4." The formula should multiply one plus the percentage value in cell D4 by the current rate on the Fleet sheet ($H5). With an absolute reference to row 4 and column H on the Fleet sheet, you can copy the formula down the column (Figure 2-105). a. C. VISIVIISSO. d. DA 5 Available Jun 27 at 12am - Aug 8 at 5pm X B Boat 10 1010 1015 S. 1 San Diego Sailing 2 New Prices at 3% and 10% increases C 1+054) Fleet/SHO Make and Model Length Catalina Wave Catalina Sky D 28'4 5% 28'41-054) Half-Day E $0.00 10% F G Full Day 10% b. Copy the formula in cell D5 to cells D6 D19 without formatting to preserve the border. Select cells D5:D19 and drag the Fill pointer to copy the formulas to cells E5:E19. Click cell E6. The formula is adjusted to use the percentage value in cell E4 in place of cell the reference on the Fleet sheet ($H6)