Challenge

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

1.  The Syntax of the UNIQUE Function is =UNIQUE(array, [by_col], [occurs_once]).

2.  

3. If C5 = 2,the output of =SWITCH(C5,1, "Poor",2, "OK",3, "Good","?") is "OK".

4.

5.  M Language is used for power query.

6.  

Power query

9.count rows 61 rows

Your portfolio, next

Ship work like this
in your own course.

Talk to a career counsellor

Free 20-minute call. We'll map the right course to where you want to work.

By submitting you agree to our Terms and Privacy Policy.