Question

Data File needed for this Case Problem: Green.xlsx 0 Green Clean Homes Sean Patel is developing a business plan for Green Clean Homes, a new professional home cleaning service in Toledo, Ohio. As part of his business plan, Sean needs to predict the company's annual income and expenses. You will help him finalize and format the Excel workbook containing the projected income statement. Complete the following 1. Open the Green workbook located in the Excel2 >Case1 folder, and then save the workbook as Green Clean in the location specified by your instructor 2. In the Documentation sheet, enter your name in cell B3 and the date in cell B4. 3. Display the date in cell B4 in the Long Date format and left-aligned. 4. Change the theme of the workbook to Facet. 5. Make the following formatting changes to the Documentation sheet: a. Merge and center cells A1 and B1. b. Apply the Accent2 cell style to the merged cell A1 and to the range A3:AS C. In cell A1, set the font size to 22 points and bold the text. Italicize the word "clean" in the company name d. Add borders around each cell in the range A3:B5. Top-align the text in the range A3:B5. e. Change the font color of the text in the range B3:B5 to Dark Green, Accent 2. 6. In the Income Statement worksheet, merge and center the range A1:C1, and then apply the Accent2 cell style to the merged cell. Change the font size to 24 points and the text style to bold. Italicize the word "Clean" within the company name. 7. Make the following changes to the Income Statement worksheet: a. Format the range A3:C3 with the Heading 1 cell style. b. Format the range A4:C4A9:C9 with the 40%-Accent 1 cell style. Format cell B5 in the Accounting style with no decimal places.

Answer 1

In B3 cell enter the name as "Jon"

In B4, enter the date as "09-Apr-2019"

Select B4, under Home tab and Number section, select Long Date

Select B4, under Home tab and Alignment section, choose left alignment

Select A1 and B1, under Home tab and Alignment section, choose Merge and Center

I have answered first 5 questions