profilehercules224

 

  1. In column G, insert a calculated column using the PMT function to calculate the monthly payment for each of the properties.
  2. In column H, insert a calculated column using the IF function to determine the amount of the if discount
    property qualifies for it.
  3. Determine the totals for columns F:H.
  4. Apply conditional formatting to cells with a selling price between $40,000,000 and $70,000,000.
  5. Copy the Payments worksheet to a new worksheet,
  6. Rename the new worksheet as Pleasant Properties
  7. Filter the table to display only the data for the Pleasant. Insert your name in the footer so that it displays on all worksheets.