1. Download and save the file, Final Project Data File from Laylimu. 2. Start Excel and...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1. Download and save the file, Final Project Data File from Laylimu. 2. Start Excel and retrieve the file, "ICS101_Final Project." 3. Enter an appropriate formula or function to calculate "Total Income" for each of the four stores in cells B7, C7, D7 & E7. 4. Enter an appropriate formula to calculate "Personnel" expense for each of the four stores in cells B9, C9, D9 & E9. Personnel expense is 21% of Total Income. 5. Enter an appropriate formula or function to calculate "Total Expense" for each of the four stores in cells B15, C15, D15 & E15. 6. Enter an appropriate formula to calculate "Net Income" for each of the four stores in cells B17, C17, D17 & E17. Net income is the "Total Income" of the store minus the "Total Expense" of the store. 7. Enter an appropriate function or formula to calculate the cells in the "Total" column, column F. 8. Enter an appropriate function or formula to calculate the cells in the "Average" column, column G. 9. Format each of the cells of the spreadsheet that are displaying numbers to display them in currency format, with a dollar sign and two decimal places. 10. Merge & Center the label, "Wayne's Water World" in cell Al over the range of cells, A1:G1. 11. Add background color to the cells of the spreadsheet. 12. Change the text color of the cells of the spreadsheet. 13. Change the size of the font for cell A1 to 24. 14. Make each of the labels, boldface. 89 A 8 1 Wayne's Water World 2 11 Uitbes 12 Advertising 13 Supples 14 Macallan 15 Total Expense 16 17 Net Income 18 19 20 21 22 23 24 25 26 27 20 29 30 3 4 Diving Waiskia Vaianae Wakane Waimanalo Total 3297.75 4192.78 1279.34 2191.63 5 Fishing 8915.55 12792.43 10706.48 7634.18 6 Surfing 5719 27 7239.42 3176 82 4139 84 7 Total Inco 17932.57 24224.63 15182.64 13985.65 9 9 Personnal 10 Rant 31 32 33 34 35 38 37 4 ▶ Ready ✓ fx Sheet1 D 23155 2428.75 2227 65 473.5 587.5 454.25 600 650 650 1395.5 1574.2 1325.75 629.5 249.75 125.3 Sheet2 F Screen Shot 2021-12...9.05 PM 2297.25 454.25 600 990.8 8065 F Sheet3 + G Average Likert scale.webp H m Dior.jpeg I Doc 1. Download and save the file, Final Project Data File from Laylimu. 2. Start Excel and retrieve the file, "ICS101_Final Project." 3. Enter an appropriate formula or function to calculate "Total Income" for each of the four stores in cells B7, C7, D7 & E7. 4. Enter an appropriate formula to calculate "Personnel" expense for each of the four stores in cells B9, C9, D9 & E9. Personnel expense is 21% of Total Income. 5. Enter an appropriate formula or function to calculate "Total Expense" for each of the four stores in cells B15, C15, D15 & E15. 6. Enter an appropriate formula to calculate "Net Income" for each of the four stores in cells B17, C17, D17 & E17. Net income is the "Total Income" of the store minus the "Total Expense" of the store. 7. Enter an appropriate function or formula to calculate the cells in the "Total" column, column F. 8. Enter an appropriate function or formula to calculate the cells in the "Average" column, column G. 9. Format each of the cells of the spreadsheet that are displaying numbers to display them in currency format, with a dollar sign and two decimal places. 10. Merge & Center the label, "Wayne's Water World" in cell Al over the range of cells, A1:G1. 11. Add background color to the cells of the spreadsheet. 12. Change the text color of the cells of the spreadsheet. 13. Change the size of the font for cell A1 to 24. 14. Make each of the labels, boldface. 89 A 8 1 Wayne's Water World 2 11 Uitbes 12 Advertising 13 Supples 14 Macallan 15 Total Expense 16 17 Net Income 18 19 20 21 22 23 24 25 26 27 20 29 30 3 4 Diving Waiskia Vaianae Wakane Waimanalo Total 3297.75 4192.78 1279.34 2191.63 5 Fishing 8915.55 12792.43 10706.48 7634.18 6 Surfing 5719 27 7239.42 3176 82 4139 84 7 Total Inco 17932.57 24224.63 15182.64 13985.65 9 9 Personnal 10 Rant 31 32 33 34 35 38 37 4 ▶ Ready ✓ fx Sheet1 D 23155 2428.75 2227 65 473.5 587.5 454.25 600 650 650 1395.5 1574.2 1325.75 629.5 249.75 125.3 Sheet2 F Screen Shot 2021-12...9.05 PM 2297.25 454.25 600 990.8 8065 F Sheet3 + G Average Likert scale.webp H m Dior.jpeg I Doc
Expert Answer:
Answer rating: 100% (QA)
Solution 4 Click on the cell B9 enter the formula B721 In ... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these programming questions
-
I need the formulas needed to find the Vertical Analysis:2021 and Horizontal Analysis. The formulas you put into eachcell to find the answer not just the answer. Comparative Income Statements: 2020...
-
List the formulas of three soluble bromide salts and three insoluble bromide salts. Do the same exercise for sulfate salts, hydroxide salts, and phosphate salts (list three soluble salts and three...
-
Please complete an essay of approximately 500 words in length addressing the following questions. Please be sure to include at least one reference with your assignment and use correct APA format for...
-
True or False? Azure storage is used by both Infrastructure as a Service ( ( laaS ) ) virtual machines, and Platform as a Service ( ( PaaS ) ) cloud services. True False
-
ATV Inc. sells off-road motorcycles and vehicles. The following data were selected from the records of ATV Inc. for the current fiscal year ended March 31, 2008: Advertising expense...
-
Are the intercepts of the two regressions consistent with the CAPM? Interpret their values. Suppose that the index model for stocks A and B is estimated with the following results: RA = .03 + .70RM +...
-
Do the following: a. Find the first four nonvanishing terms of the Maclaurin series expansion of \(f(x)=\frac{x}{e^{x}-1}\). b. Use the result in part a. to determine the first four nonvanishing...
-
Using Microsoft Project, set up the network and determine the critical path for Phase 1 of the project. The project workweek will be 5 days (MF). Given the coming 2010 Winter Olympics in Vancouver...
-
9. The following transactions take place in March: Day Description Source 1 Paula Pollack's initial investment (found on page 1) 2 Purchased cameras and photographic equipment for cash from Kodak...
-
Bear Park, a camping ground in the Lake District, has compiled the following financial information as of December 31, 2020. Instructions a. Determine Bear Parks net income for 2020. b. Prepare a...
-
The rock-based reinforced concrete base slab is anchored with steel to the rock according to the attached picture. The edge distance of the steel anchor is c. The foundation slab is affected by two...
-
What are Industry 4.0 and Service 4.0? Give an example in manufacturing and health care or other service industries.
-
The favored type of negotiation that generally provides the best results is called what?
-
What factors might affect the decisions of economic actors to save more today for consumption in the future? Why are the decisions of economic actors today important for the welfare of economic...
-
Explain the mechanics of exercising and closing an \(\mathrm{S \& P} 500\) futures call options contract with an exercise price of 2,250 and multiplier of \(\$ 250\) when the underlying futures...
-
Are standard terms and conditions for a contract often referred to as boilerplate or as ABC policy?
-
What are some of the sources of tension between managing a career and other developmental tasks of middle adulthood? Brainstorm possible conflicts between management of career and nurturing an...
-
The polar coordinates of a point are given. Find the rectangular coordinates of the point. (-1, - /3)
-
Ray and Maria Gomez have been married 3 years. They live at 1610 Quince Ave., McAllen, TX 78701. Ray works for Palm Oil Corporation and Maria works for the City of McAllen. Maria's Social Security...
-
For each of the following cases, indicate the filing status for the taxpayer(s) for 2012 using the following legend: A - Single B - Married, filing a joint return C - Married, filing separate returns...
-
In 2012, Michael has net short-term capital losses of $2,000, a net long-term capital loss of $45,000, and other ordinary taxable income of $45,000. a. Calculate the amount of Michael's deduction for...
-
Your brother recently graduated from college and started his first job. He rents half a duplex, but the owner has put the building up for sale. Your brother thinks that purchasing the building would...
-
What are the steps to complete a W-4 form?
-
Explain how deductions and tax credits affect the amount of income tax you pay.
Study smarter with the SolutionInn App