Hi guys I need help this are the instructions but i get stuck on 4 help


can you upload the file to mediafire so i can download, if you can explain me how you did it in would be awesome


Download Project file Excel_B21.xlsx, then save the workbook as YourName_Budget B2.
http://www.mediafire.com/?1b3zhudybrl337j


2. Change the date in cell F1 to read 3/1/2010 .

3. Type your name in cell A30.

4. In cell A23, add a label called Potential Cost Increase and enter the proposed increase in cell A24 as 15%.

5. In cell B23, create a formula adding cells B14 through B16 and then multiplying that answer by the proposed increase in A24.

6. Create a formula in cell F6 to add the salaries.

7. Create a formula in F4 to add the Net Sales using the AutoSum button.

8. Copy the formula in cell F4 to F10 through F17 using the Office Clipboard.

9. In B17, create a formula to add the Qtr1 expenses, and using the fill handle, copy the formula to cell E17*.

10. In B19, create a formula subtracting the Total Expenses from the Net Sales, and using a fill handle, copy it to cell F19.

11. Make the A24 cell reference in the formula in cell B23 absolute.

12. Copy the formula in B23 to all the cells to F23 using the fill handle.

13. In cell A26, create a label Adjusted Income.

14. In cell B26, create a formula subtracting the Proposed Increase amount from the Net Income.

15. Copy that formula from B26 to cell F26.

16. Save it and close Excel.

17. Submit the file in the Excel drop box labeled Assignment # 7 - Excel 2007