Need help finding the correct equations for columns G, H and I according to these directions. Using the numbers from week 1 and week 2 I need to find the week 2 total, current week gain/loss, and the net gain loss for the six stocks

Week 2: Investment Project Complete the Stock Investment Project Excel spreadsheet for week 2. 1. Copy columns A, B, C, D, and E from week 1 to week 2 . 2. Find the closing stocklinvestment prices, as you did in week 1 (instruction item 6) and record those prices in the Excel template under week 2. 3. Create Excel formulas for columns G, H, and I. These columns MUST have Excel formulas. If you are new to Excel, try this video: Basic Excel Formulas and Functions You NEED to KNOW! - YouTube Make sure you review the instructor's announcements about the project and ask any questions you may have. After completing, click the link above to attach your Excel investment information for submission. Points will be deducted for various items. Please see the PPT slides, in week 1 , from your professor in the announcement area. Due by Day 7, 11:59pm ET. For each week, update the Excel template with the end-of-week investment prices and be prepared to answer questions about your project in the discussion area of the course. Please see the instructor's PowerPoint Slide Presentation (Announcement area) for a copy of the Grading rubric used in this assignment. Weeks 1 and 2 Investment project assignments are worth 30 points. All of these points will be awarded in week 2 . Week 1: Complete this section of the template and send with information for week 2 below Complete the appropriate template Each report week ( 2&6 ) provide a worksheet with all weeks upto Week 2 - Provide updated information for this week - Due at the end of class week 2 Week 3 -Provide updated information for this week - Due at the end of class week 6 Week 2: Investment Project Complete the Stock Investment Project Excel spreadsheet for week 2. 1. Copy columns A, B, C, D, and E from week 1 to week 2 . 2. Find the closing stocklinvestment prices, as you did in week 1 (instruction item 6) and record those prices in the Excel template under week 2. 3. Create Excel formulas for columns G, H, and I. These columns MUST have Excel formulas. If you are new to Excel, try this video: Basic Excel Formulas and Functions You NEED to KNOW! - YouTube Make sure you review the instructor's announcements about the project and ask any questions you may have. After completing, click the link above to attach your Excel investment information for submission. Points will be deducted for various items. Please see the PPT slides, in week 1 , from your professor in the announcement area. Due by Day 7, 11:59pm ET. For each week, update the Excel template with the end-of-week investment prices and be prepared to answer questions about your project in the discussion area of the course. Please see the instructor's PowerPoint Slide Presentation (Announcement area) for a copy of the Grading rubric used in this assignment. Weeks 1 and 2 Investment project assignments are worth 30 points. All of these points will be awarded in week 2 . Week 1: Complete this section of the template and send with information for week 2 below Complete the appropriate template Each report week ( 2&6 ) provide a worksheet with all weeks upto Week 2 - Provide updated information for this week - Due at the end of class week 2 Week 3 -Provide updated information for this week - Due at the end of class week 6