Project 1 - Data Cleaning and Transformation using Pivot Table and Charts

1. =UNIQUE(range of cell)

like:- =UNIQUE(C3:C10)

2. Syntax refers to the structure and order of a formula.

3. ans is "ok"

4. data->get external data->from text-> browse the text file ->import

5. m language

6. home->transform -> data type

7/8. select "Query" -> Edit -> Select Add Column Example -> tye a sample value for the new created column data -> press Ctrl+Enter -> Ok

9. choose any column that doesn't contain blanks or nulls, and on the Transform tab choose Statistics -> Count Values.

10. select a column, and then select Transform -> Detect Data Type.

11. Query -> Edit -> Home -> Use First Row As Headers.