Project 1 - Data Cleaning and Transformation using Pivot Table and Charts
Answer of a) The excel answer sheet file has been selected.
Answer of b) 1) The excel answer sheet file has been selected.
Answer of b) 2) The excel answer sheet file has been selected.
Answer of b) 3) The excel answer sheet file has been selected.
Answer of b) 4) The excel answer sheet file has been selected.
Answer of b) 5) The excel answer sheet file has been selected.
Answer of b) 6) The excel answer sheet file has been selected.
Answer of c) The excel answer sheet file has been selected.
Answer of d) The excel answer sheet file has been selected.
Answer of e) The excel answer sheet file has been selected.
Answer of f) The excel answer sheet file has been selected.
Answer of g) The excel answer sheet file has been selected.
Answer of h) The excel answer sheet file has been selected.
Answer of i) The excel answer sheet file has been selected.
Answer of j) The excel answer sheet file has been selected.
Answer of 1) The Syntax of UNIQUE Function is -------- =UNIQUE(array,[by_col],[exactly_once])
Answer of 2) Difference between ' Syntax ' and ' Formula ' is ------------------
Syntax refers to the structure and order of a formula, including function, references operators and parameters.
Where formula support app objects, and there is no structure of formula.
Answer of 3) If C5 = 2, What is the output of =SWITCH(C5,1, "Poor",2, "OK",3, "Good","?") then the answer will be --------------- 'ok'.
Answer of 4) The conversion of SMSA.TXT file into excel file has been done and the excel answer sheet has been selected.
Answer of 5) Power Query M Formula Language is for Power Query.
Answer of 6) The steps to transform the SMSA.txt file into excel file is the following ----------------------
Step 1 - Open Excel and create a new workbook, and goto data tab and click ' From text/csv ' option in get & transform data ribbon.
Step 2 - Select the text file (SMSA.txt) and click open button.
Step 3 - In new preview window click on ' transform data ' button.
Step 4 - Next in the new window click on close & load option in the home tab and done.
Answer of 7) The excel answer sheet file has been selected.
Answer of 8) The excel answer sheet file has been selected.
Answer of 9) The excel answer sheet file has been selected.
Answer of 10) The excel answer sheet file has been selected.
Answer of 11) The excel answer sheet file has been selected.
Answer of 1) The excel answer sheet file has been selected.
Answer of 2) 1) The excel answer sheet file has been selected.
Answer of 7) 2) The excel answer sheet file has been selected.
Answer of 7) 3) The excel answer sheet file has been selected.
All choosing file names are ----------------------------
1) Excel Project 1 (Relationship).xlsx
2) Excel Project 1 (Sales Data).xlsx
3) Excel Project 1 (SMSA).xlsx