Data File needed for this Case Problem: Green.xlsx 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.

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

Case Problem 1 Data File needed for this Case Problem: Green.xlsx 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:A5.

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:C4,A9:C9 with the 40% - Accent1 cell style.

c). Format cell B5 in the Accounting style with no decimal places.

d). Format cell B6 and the range B10:B17 in the Comma style with no decimal places.

8. Add the following calculations to the workbook:

a). In cell C7, calculate the gross profit, which is equal to the gross sales minus the cost of sales.

b). In cell C18, calculate the company’s total operating expenses, which is equal to the sum of the values in the range B10:B17. Format the value in the Accounting format with no decimal places.

c). In cell C20, calculate the company’s operating profit, which is equal to its gross profit minus its total operating expenses.

d). In cell C21, calculate the company’s incomes taxes by multiplying its total operating profit by the corporate tax rate (cell G25). Format the value in the Accounting format with no decimal places.

e). In cell C22, calculate the company’s net profit, which is equal to the total operating profit minus the income taxes.

9. Finalize the formatting of the Projected Income statement by adding the following:

a). Add a bottom border to the ranges A6:C6, A17:C17, and A20:C20. Add a single top border and a double bottom border to the range A22:C22.

b). Indent the expenses categories in the range A10:A17 twice.

10. Format the Financial Assumptions section as follows:

a). Add borders around all of the cells in the range E4:G25.

b). Format the range E3:G3 with the Heading 1 cell style.

c). Merge the cells in the ranges E4:E7, E9:E13, E14:E15, E16:E18, and E20:E22.

d. Top-align and left-align the range E4:E25.

e. Change the fill color of the range E4:F25 to Green, Accent 1, Lighter 60%. 

 

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Form
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education