I’m unsure of the correct way to do this as it is strong suit

I’m unsure of the correct way to do this as it is strong suit. I need the landing page fixed, the other sheets are simply information that lays out the assignment. Data audit report is the sheet to refer to. 

Instructions

Complete the following steps for cleaning the internal data provided.

Steps

• 1Download and Review the Data File
  The file below contains conversion data from Buhi’s website. Identify any extreme outliers, incorrect value formats, impossible values, null values, and data outside of Q3. These values are errors in the data.
• 2Clean Landing Page – Conversions Data
  Remove the erroneous values you identified by clearing the individual cells containing them, not entire rows. After clearing a cell, simply leave it empty. Then, upload your cleaned file and check the correctness of your cleaned data by clicking Validate.

  Note: If there are any errors remaining when you validate your file, you’ll receive feedback pointing out the rows and columns where the errors are. When referring to column numbers, the numbering starts at zero. Therefore, column 0 in the feedback refers to the ID column, column 1 is Landing Page, and so on.

(If you’re using a spreadsheet application, deleting erroneous values in one column may cause a long value from an adjacent column to appear to bleed into the now-empty cell. This only affects the way the spreadsheet is displayed, not the actual value of the cell in question, which is still empty.)

Upload Cleaned Internal Data

Accepted File Requirements

1. File must be uploaded as a csv
2. File must contain 7 columns with the names: “ID”, “Landing Page”, “Date Range”, “Country”, “Ad Campaign Clicks”, “Converted Sales”, “Instructions”
3. File must contain 391 rows (+-10)