Need help

figuring out #6 which is the last column.

As an intern for Lion Oil \& Gas LLC, your employer asks you to derive the production income worksheet (example shown on page 2). The following are tasks (requirements) that you need to perform: 1. The Excel Data Workbook is posted in the course content area. Use this Data Workbook as your starting point. 2. Adjust column widths and column centering as needed (to match page 2 output example). 3. Calculate Gross Monthly Production cells H3-H2O with the appropriate excel calculations GMP =( bls x PPb) + (mcf PPm). (Ref: Topic 2 for cell calculations) Make sure any cells associated with dollars are formatted as such to 2 decimal places. Requirement: Use absolute reference for PPb cell $F$25 and PPm cell $F$26 to receive credit. (Ref: Topic 2 ) 4. Calculate monthly production cost cells 13-120 based on the percentage noted in cell \$F\$27 on gross monthly production. Requirement: Use absolute reference for cost percentage cell \$F\$27. (Ref Topic 2) 5. Calculate net monthly production cells J3-J20. (GMP - MPC) 6. Calculate Predictive Yearly Production cells K3-K20 with the appropriate excel monthly calculations (PYP = (NMP x Pred\%) + NMP and then adjust for yearly. 7. Provide column totals and averages as noted in the final worksheet requirement below for columns F through K with same format. All calculated values and totals must match those provided in this assignment. Requirement: Must use the SUM and AVERAGE functions for all values. (Ref: Topic 5) 8. Make sure the Lion Oil \& Gas LLC Heading is provided and centered using the Merge \& Center function across cells A-K and color shading as well. (Ref: Topic 4) 9. The "look and feel" of the spreadsheet should correspond exactly to what is provided in this assignment including color orientation for headings, totals, and tab label. (Ref: Topic 3) 10. Be sure the "Lion Production" tab is appropriately labeled. 11. Be sure the row 21 separator is provided as shown to match page 2 output example. 12. In order to get full credit, you need to submit an Excel file to the Assignment Dropbox and fulfill all of the 1. The Excel Data Workbook is posted in the course content area. Use this Data Workbook as your starting point. 2. Adjust column widths and column centering as needed (to match page 2 output example). 3. Calculate Gross Monthly Production cells H3-H2O with the appropriate excel calculations GMP = (bls X PPb) + (mcf X PPm). (Ref: Topic 2 for cell calculations) Make sure any cells associated with dollars are formatted as such to 2 decimal places. Requirement: Use absolute reference for PPb cell $F$25 and PPm cell SF\$26 to receive credit. (Ref: Topic 2) 4. Calculate monthly production cost cells I3-120 based on the percentage noted in cell \$F\$27 on gross monthly production. Requirement: Use absolute reference for cost percentage cell \$F\$27. (Ref Topic 2) 5. Calculate net monthly productin cells J3-J20. (GMP - MPC) 6. Calculate Predictive Yearly Production cells K3K20 with the appropriate excel monthly calculations ( PYP= (NMP Pred\%) + NMP and then adjust for yearly. 7. Provide column totals and averages as noted in the final worksheet requirement below for columns F through K with same format. All calculated values and totals must match those provided in this assignment. Requirement: Must use the SUM and AVERAGE functions for all values. (Ref: Topic 5) 8. Make sure the Lion Oil \& Gas LLCHeading is provided and centered using the Merge \& Center function across cells A-K and color shading as well. (Ref: Topic 4) 9. The "look and feel" of the spreadsheet should correspond exactly to what is provided in this assignment including color orientation for headings, totals, and tab label. (Ref: Topic 3) 10. Be sure the "Lion Production" tab is appropriately labeled. 11. Be sure the row 21 separator is provided as shown to match page 2 output example