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

1) UNIQUE(array, [by_col], [exactly_once])

2) Syntax refers to the structure and order of a formula, including functions, references, operators, and parameters. But, Formulas are expressions or equations that can be used to perform calculations and return information.

3) OK.

5) Power Query is written in M.

6) Data --> Get External Data --> From Text --> (Select the text file) --> import --> Finish --> (Let Excel know where you want to put the data) --> OK