I really need help on this one. I need a step to step. I don't like using excel so this is kind of hard for me.

EXCEL: 40. Add the following column headings in the Lastname_Firstname_18PR_Excel file that opens from the above step: ? In cell G1 enter Discount, ? In cell H1 enter Discount Percent, ? In cell I1 enter Discount Cost, ? In cell J1 enter Total Cost, and ? In cell K1 enter Payment as column headings. 41. Select the column headings A1:K1 and apply Cell Style of Heading 3. 42. Widen the Product Name (column B) to 25, the Discount Percent (column H) and Discount Cost (column I) columns to 10. 43. Select row 1 and Wrap Text to display column headings in H1 and I1 as multiple lines within the cell. 44. ? In cell G2, insert an IF function that displays Discount with a Y or N if the Unit Cost is less than or equal to 100. ? Use the fill handle to copy this formula down to row 8. 45. Create a Discount Percent Lookup Table as follows: ? In cell G10 enter 0, in H10 enter 0.1, ? In G11 enter 25, in H11 enter 0.2, 1 Page 8 of 11 Steps Instructions Points ? In G12 enter 50, in H12 enter 0.3, ? In G13 enter 75, in H13 enter 0.4, ? In G14 enter 100, and in H14 enter 46. In cell H2, insert a VLOOKUP function that returns the Discount Percent that corresponds with the ? Unit Cost in cell E2. ? The function will refer to the Lookup Table created in G10:H14 and ? return the corresponding Discount Percent value from the second column of the Lookup Table. ? Make sure appropriate cell references (relative/absolute references) are made. ? Use the fill handle to copy this formula down to row 8. ? Set column H to Percent style with 0 decimal places. 47. ? In cell I2 create a formula (NOT A FUNCTION!) to insert the new Discount Cost (which is the Unit Cost multiplied by Discount Percent). ? Use the fill handle to copy this formula down to row 8. ? Set Column I to Currency Number Format. 48. ? In cell J2, create a formula (NOT A FUNCTION!) to calculate the Total Cost (which is Unit Cost minus the Discount Cost). ? Use the fill handle to copy this formula down to row 8. 49. In cell K2, insert a PMT function to calculate the monthly product Payment ? using an interest Rate of 7% (per year which means 7%/12), ? an Nper loan term of 3 months, and ? refer to the Pv as the Total Cost in J2. ? Make sure that the (Pv) monthly Payment displays as a positive number (i.e., use a negative sign in front of J2) ? Use the fill handle to copy this formula down to row 8. 50. Use appropriate functions to do the following in cells J10:J13: ? In cell J10 enter a function to sum the range J2:J8, ? In cell J11 enter a function to average the cells in the same range, ? In cell J12 enter a function to display the lowest value in the same range, and ? In cell J13 enter a function to display the highest value in the same range. 51. ? Format cells J10:J13 with Accounting format. ? Use the fill handle to copy the cells J10:J13 to K10:K13 52. Change the Page Layout of the Products worksheet so that it: ? Is set to Landscape orientation, ? Has a Customer Header with Your name in the left section, Sheet Name in the center section, and Date on the right section (choose any style but make sure to update automatically), and ? Will print with Gridlines. 53. Insert a 3-D Pie chart using the Product Name data and the Payment data and do the following: ? Move and resize the pie chart so that it is located in cells A10:F30 (you might want to change your zoom settings so that you can view the entire sheet on one screen), ? Change the Chart Title to Excel Project ? Change the Chart Style to Style 7, ? Add inside end Data Labels. 54. Copy the Pie chart created in the above step.