Task 1 Create the First Quarter Budget Worksheet 1. Open the file 9-3 Budget that you created earlier. Save it as 9-4 Budget. 2. Insert a new worksheet, name it First-Quarter Report, and apply a color to the sheet tab. 3. Copy the Owner & CEO worksheet data and paste it in the new sheet. 4. Change cell A5 to Fiscal Year Budget - First-Quarter Report. Delete the data for Owner and CEO expenditures in B7:110 and J11:K18. 5. Delete the dates in column A and then enter the following dates for quar- terly reports in A7:A10: 4/1720--, 7/1/20--.10/1/20--, and 1/1/20-. Use the current year for the first three quarters and next year for the fourth. 6. Refer to the annual budget shown in Figure 9-1. Enter the total annual budget for the company in cells K7:K10. Replace the data in row 21 with figures from the Totals column in Figure 9-1. In cell J21, sum the Annual Budget totals. 7. In cell B7, enter a 3-D formula to sum the Salary expenditures for the first quarter for the four departments. (Hint: Your formula should reference cell B20 in each of the four department worksheets. 8. Use the copy and fill features to enter formulas for the other budget categories in cells C7:17. 9. Modify the conditional formatting on the Percent of Budget Remaining NEXT PAGE date Budget Worksheets 149 67'F Sunny 12:35 PM 4/10/2025 hp f9 f10 144 Insert prt sc & 6 8 O O backspace O P