The question are: 1. In D16: Use the product code breakdown provided at the top of the worksheet as a guide to create appropriate nested functions to complete the following: If the product is a Dishwasher insert the product Price, otherwise the cell should be blank. Copy the function down to the other cells in the column. In cell D14 use the appropriate function to calculate the total from the results. Format comma style, 0 decimal.. 2. In E16: Use the product code breakdown provided at the top of the worksheet as a guide to create appropriate nested functions to complete the following: If the product is a Black Stove insert the product Price, otherwise the cell should be blank. Copy the function down to the other cells in the column. In cell E14 use the appropriate function to calculate the total from the results.. 3. In F16: Use the product code breakdown provided at the top of the worksheet as a guide to create appropriate nested functions to complete the following: If the product is a Stainless Steel, 240 V, Refrigerator insert the product Price, otherwise the cell should be blank. Copy the function down to the other cells in the column. In cell F14 use the appropriate function to calculate the total from the results. 4.  In G16: Use the product code breakdown provided at the top of the worksheet as a guide to create appropriate nested functions to complete the following: If the product is a Standard, Black, 120 V, Dishwasher insert the product Quantity, otherwise the cell should be blank. Copy the function down to the other cells in the column. In cell G14 use the appropriate function to calculate the total from the results. 5. In H16: Use the product code breakdown provided at the top of the worksheet as a guide to create appropriate nested functions to complete the following: If the product is a Standard, White or Black, Dishwasher insert the product Price, otherwise the cell should be blank. Copy the function down to the other cells in the column. In cell H14 use the appropriate function to calculate the total from the results.   6.  In I16: Use the product code breakdown provided at the top of the worksheet as a guide to create appropriate nested functions to complete the following: If the product is a White or Black, Refrigerator or Stove insert the product Quantity, otherwise the cell should be blank. Copy the function down to the other cells in the column. In cell I14 use the appropriate function to calculate the total from the results If the product is a White or Black, Refrigerator or Stove insert the product Quantity, otherwise the cell should be blank. Copy the function down to the other cells in the column. In cell I14 use the appropriate function to calculate the total from the results. 7. In J16: Use the product code breakdown provided at the top of the worksheet as a guide to create appropriate nested functions to complete the following: If the product is Black or Stainless Steel, Microwave or Stove, 240 V or Premium insert the product Quantity, otherwise the cell should be blank. Copy the function down to the other cells in the column. In cell J14 use the appropriate function to calculate the total from the results. 8.

Week 5 - Final PaperFinal Case Analysis: Organizational Ethical Dilemmas[WLO: 3] [CLOs: 1, 2, 3, 4, 5]For a copy of the transcript for the above video click here.Prior to beginning work on this assignment, read the articles The 5 Biggest Corporate Scandals of 2016 (Links to an external site.) and The 10 Biggest Business Scandals of 2017 (Links to an external site.).You will be writing an eight- to 10-page paper (not including title or reference pages) focused on current events that applies topics covered in this course related to recognized uses and uses you can envision.The articles this week focus on business or corporate scandals. Choose one business or corporate scandal from either The 10 Biggest Business Scandals of 2017 (Links to an external site.) or The 5 Biggest Corporate Scandals of 2016 (Links to an external site.) to research and review.In your paper,Explain whether the organization acted socially and ethically responsible regarding the incident.Describe what the organization should or could have done differently.Describe who or what was responsible for the incident.Explain the best way to ensure that such incidents do not recur, if possible.Recommend the best way for society, and stakeholders, to prevent future incidents of this type.*Note: You are encouraged to integrate any feedback from your instructor and upload the assignment to Portfolium. For assistance using Portfolium, review the Portfolium Student Guide.The Final Case Analysis: Organizational Ethical Dilemmas Final PaperMust be eight to 10 double-spaced pages in length (not including title and references pages) and formatted according to APA style as outlined in the Ashford Writing Center’s APA Style (Links to an external site.)Must include a separate title page with the following:Title of paperStudent’s nameCourse name and numberInstructor’s nameDate submittedFor further assistance with the formatting and the title page, refer to APA Formatting for Word 2013 (Links to an external site.).Must utilize academic voice. See the Academic Voice (Links to an external site.) resource for additional guidance.Must include an introduction and conclusion paragraph. Your introduction paragraph needs to end with a clear thesis statement that indicates the purpose of your paper.For assistance on writing Introductions & Conclusions (Links to an external site.) as well as Writing a Thesis Statement (Links to an external site.), refer to the Ashford Writing Center resources.Must critically address the paper topic. That is, positively or negatively respond to the content and then defend your position. If multiple positions are present and are being rejected, you must also defend rejecting them.Must use at least four scholarly sources in addition to the course text.The Scholarly, Peer-Reviewed, and Other Credible Sources (Links to an external site.) table offers additional guidance on appropriate source types. If you have questions about whether a specific source is appropriate for this assignment, please contact your instructor. Your instructor has the final say about the appropriateness of a specific source for a particular assignment.Must document any information used from sources in APA style as outlined in the Ashford Writing Center’s Citing Within Your Paper