1. Download the Assignment 12-50 Student File and open it within Microsoft Excel. 2. Highlight the range D3 D5 and choose Autosum from the Editing group of the Home menu. 3. Within cell B6 enter the formula = (B3/$D$3)*$D$6. Copy cell B6 and paste within cell C6. 4. Within cell B7 enter the formula = B5-B6. Copy cell B7 and paste within the range C7 D7 5. Highlight the range D11 D13 and choose Autosum from the Editing group of the H 6. Within cell B14 enter the formula = (B11/$D$11)*$D$14. Copy cell B14 and paste wil 7. Within cell B15 enter the formula = B13-B14. Copy cell B15 and paste within the ranc 8. Highlight the range D19:D21 and choose Autosum from the Editing group of the 9. Within cell C30 enter the formula = C28-C29. 10. Within cell B23 enter the formula = ($C$30/$D$3)*B19. Copy cell B23 and paste within cell C23. 11. Within cell B24 enter the formula = (B3/$D$3)*$C$29. Copy cell B24 and paste within cell C24. 12. Highlight the range D23:D24 and choose Autosum from the Editing group of the Home me