excel project

I need help with a Excel question. All explanations and answers will be used to help me learn.

Exercise Content

  1. Answer sheets for Week Four assignment are posted in Course Documents. You are expected to compare your work to the answer sheets to identify where you went wrong and learn the correct formulas. If, after your review, you feel your grade should be adjusted you can sent me an email telling me why– I will review and make any justified adjustments or, if not, I will tell you why.This week we cover Chapter 4 “Retrieving Data for Computation, Analysis, and Reference” where we will use the “Sales: Creating Product Order Forms for Equipment Purchases as the learning example. We will cover Levels 1 and 2 only.The Assignment has three parts:Part A: Read the Chapter Introduction and Case Scenario on page 212. Read this page very carefully. It is important that you clearly understand what the Chapter material is all about – otherwise you will just be putting numbers in cells.
    You might also want to watch the youtube.com video for this chapter.Part B:1. Study (LEARN) the material covered in Level 1: Accounting: Establishing a Credit Approval Process for Accounts Receivable on pages 214 to 240. The CH04 Level 1 Figures.xlsx file in Lectures (Student Data Files Chapter Four) replicates all of the Figures in this section so you can easily follow along with the textbook discussions.2. PRACTICE what you learned in the first part by completing the Steps to Success: Level 1 exercise starting on page 241. The starting workbook: PO527.xlsx can be found in Lectures -(Student Data Files Chapter Four). POST A COPY OF YOUR WORK TO BLACKBOARD FOR REVIEW AND GRADING (20 POINTS)3. APPLY what you have learned to a new business marketing situation by completing the Level 1 Case Problem on page 275 of your textbook. The starting workbook Hiring.xlsx can be found in Lectures- Student Data Files Chapter Three . POST A COPY OF YOUR WORK TO BLACKBOARD FOR REVIEW AND GRADING (20 POINTS)4. Write a short essay on what you have learned in Level 1 and how you could apply this to other business situations. POST A COPY OF YOUR WORK TO BLACKBOARD FOR RVIEW AND GRADING (10 POINTS)Part C:1. Study (LEARN) the material covered in Level 2: Analyzing Data Using IF Functions and Nested Functions on pages 177 to 194. The CH04 Level 2 Figures.xlsx file in Lectures (Student Data Files Chapter Three) replicates all of the Figures in this section so you can easily follow along with the textbook discussions. 2. PRACTICE what you learned in the first part by completing the Steps to Success: Level 2 exercise starting on page 256. The starting workbook: Unpaid.xlsx can be found in Lectures -(Student Data Files Chapter Three). POST A COPY OF YOUR WORK TO BLACKBOARD FOR REVIEW AND GRADING (20 POINTS)3. APPLY what you have learned to a new business marketing situation by completing the Level 2 Case Problem on page 277 of your textbook. You have to create your own starting worksheet for this exercise. POST A COPY OF YOUR WORK TO BLACKBOARD FOR REVIEW AND GRADING (20 POINTS)4. Write a short essay on what you have learned in Level 2 and how you could apply this to other business situations. POST A COPY OF YOUR WORK TO BLACKBOARD FOR RVIEW AND GRADING (10 POINTS)A Power Point review of Chapter 4 is posted in LecturesLet me know if there is anything you don’t understand — the earlier the better.

Order this or a similar paper and get 20% discount on your first order with us. Use coupon: GET20