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
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 Enter the worksheet title Eeylops Owl Emporium in cell A and the subtitle EightYear Financial Projection in cell A Format the worksheet title in cell A to be point font of your choosing. Format the worksheet subtitle in cell A to be point font of your choosing. Enter the system date in cell in cell I using the NOW function, NOW Format the date to the Mar style Change the following column widths: A; B through I Change the heights of rows and to Enter the column titles Year through Year in the range B:I by entering Year in cell B and then dragging cell Bs fill handle through the range C:I Format the cell B as follows: a increase the font size to ; b center and italicize; and c rotate the contents degrees. Use the Format Painter button to copy the format assigned to cell B to the range C:I Enter the row titles in the range A:Aa A: Salesb. A: Cost of Goodsc. A: Gross Margind. A: Expensese. A: Advertisingf. A: Maintenanceg. A: Renth. A: Salariesi. A: Suppliesj. A: Total Expensesk. A: Operating Incomel. A: Income Taxesm. A: Net Income Change the font in cells A A A and A to be point font of your choosing. Add thick bottom borders to the ranges B:I and B:I Use the Increase Indent button on the Home tab on the Ribbon to increase the indent of the row titles in cell A the range A:A and cell A Enter the title Assumptions in cell A Enter the following values into the following cells:a A: Units Sold in Prior Yearb. A: Unit Costc. A: Annual Sales Growthd. A: Annual Price Decreasee. A: Marginf. B: g B: h B: i B: j B: Change the font size of the table title to be point font of your choosing and underline it Select the range B:I 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 B:I
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
