Project 1 - Data Cleaning and Transformation using Pivot Table and Charts
2. ans: Syntax refers to the structure and order of a formula, including functions, references, operators, and parameters.
3. ans: The output will be "OK".
4. ans: Convert the SMSA.TXT File into excel SMSA.XLSX.
5. ans: the Power Query M formula language, also known as M.
6. ans: Step 1: Data interpretation. Step 2: Pre-translation data quality check. Step 3: Data translation. Step 4: Post-translation data quality check.