Post-Test for data cleaning Workshop

Which Excel tool helps to remove duplicate records in your day-to-day datasets?

• Conditional Formatting

• Remove Duplicates

• Data Validation

• VLOOKUP

If a patient's Temperature is recorded as “Unknown,” what should you do?

• Replace with the dataset’s average temperature

• Leave as “Unknown”

• Replace with 0

• Delete the entry

What formula can be used in Excel to convert text-formatted numbers to actual numbers?

• =TEXT(A2, "0")

• =VALUE(A2)

• =UPPER(A2)

• =LEN(A2)

Which of the following methods ensures date consistency in a dataset?

• Manually checking each row

• Using Excel’s TEXT function to standardize formatting

• Ignoring different date formats

• Replacing all dates with today’s date

Why is it important to clean datasets before analysis?

• It ensures accurate epidemiological reports

• It makes the dataset smaller

• It helps eliminate old records

• It’s not necessary