Question: 1 . Apply any theme you like to the worksheet by using the Themes button on the Page Layout tab of the Ribbon. Bold the

1. Apply any theme you like to the worksheet by using the Themes button on the Page Layout tab of the Ribbon. Bold the entire worksheet by selecting the entire worksheet and using the Bold button on the Home tab of the Ribbon.2. Enter the worksheet title Eeylops Owl Emporium in cell A8 and the subtitle Eight-Year Financial Projection in cell A9. Format the worksheet title in cell A8 to be 36-point font of your choosing. Format the worksheet subtitle in cell A9 to be 20-point font of your choosing. Enter the system date in cell in cell I9 using the NOW function, =NOW(). Format the date to the 14-Mar-01 style.3. Change the following column widths: A=25.00; B through I =15.00. Change the heights of rows 7,10, and 21 to 42.004. Enter the column titles Year 1 through Year 8 in the range B10:I10 by entering Year 1 in cell B10 and then dragging cell B10s fill handle through the range C10:I10. Format the cell B10 as follows: (a) increase the font size to 14; (b) center and italicize; and (c) rotate the contents 45 degrees. Use the Format Painter button to copy the format assigned to cell B10 to the range C10:I10.5. Enter the row titles in the range A11:A24.a. A11: Salesb. A12: Cost of Goodsc. A13: Gross Margind. A14: Expensese. A15: Advertisingf. A16: Maintenanceg. A17: Renth. A18: Salariesi. A19: Suppliesj. A20: Total Expensesk. A22: Operating Incomel. A23: Income Taxesm. A24: Net Income6. Change the font in cells A14, A20, A22, and A24 to be 14-point font of your choosing. Add thick bottom borders to the ranges B10:I10 and B12:I12. Use the Increase Indent button on the Home tab on the Ribbon to increase the indent of the row titles in cell A12, the range A15:A19, and cell A23. Enter the title Assumptions in cell A1. Enter the following values into the following cells:a. A2: Units Sold in Prior Yearb. A3: Unit Costc. A4: Annual Sales Growthd. A5: Annual Price Decreasee. A6: Marginf. B2: 14,467,514g. B3: 16.70h. B4: 4.50%i. B5: 4.25%j. B6: 51.38%7. Change the font size of the table title to be 14-point font of your choosing and underline it. Select the range B11:I24 and then click the Format Cells: Number Dialog Box Launcher on the Home tab of the Ribbon to display the Format Cells dialog box. Use the Number category in the Format Cells dialog box to assign the Comma style with no decimal places and negative numbers enclosed in parenthesis to the range B11:I24.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!