Test your data skills !

1. What is this chart type ?

2. Which of the following would you use to check the performance of a classification machine learning model in python ?

3. Machine Learning problems are primarily of 2 types which are …

4. While building a machine learning model we split the data into ?

5. What is the image above ?

6. Confusion Matrix is used for in machine learning models to …

7.

x= "KLAYMATRIX"print([::-1])

What is the output of above code ?

8. Which of the following would you use to minimize the impact of outlier ?

9. Which of these is not an excel file type ?

10. While building a machine learning model we split the data into ?

1. Which function would you use to find the average of a range of cells in Excel?

2. What shortcut key combination is used to copy the selected cells in Excel?

3. Which feature allows you to quickly fill a range of cells with a series of values based on the content of other cells?

4. Which feature in Excel allows you to filter and summarize data from a large dataset?

5. Which feature in Excel allows you to filter and summarize data from a large dataset?

6. What does the function =LEN(A1) do in Excel?

7. Which function can be used to look up a value in a table and return a corresponding value from a specified column?

8. How do you start a formula in Excel?

9. Which of the following is NOT a valid chart type in Excel?

1. Which of the following handles outliers in the best way ?

2. What is this chart type ?

3. Which visual would you use to display trends over time in Power BI?

4. Which chart would you use for correlation ?

5. Which type of chart is best suited for showing parts of a whole in Power BI?

1. Which of the following would you use to minimize the impact of outlier ?

2. What is the purpose of feature scaling in machine learning?

3. KNN is used for which kind of machine learning problems ?

4. While building a machine learning model we split the data into ?

5. Which of the following is not a supervised learning algorithm?

6. While building a machine learning model we split the data into ?

7. Which of the following handles outliers in the best way ?

8. Which of the following would you use to check the performance of a classification machine learning model in python ?

9. Confusion Matrix is used for in machine learning models to …

10. Which of the following evaluation metrics is appropriate for a binary classification problem?

1. How can you add a new data source to an existing Power BI report?

2. Which of the following is a cloud-based business analytics service?

3. What is the purpose of the “Hierarchy” feature in Power BI?

4. How do you create a calculated measure in Power BI?

5. Which of the following is a valid DAX function?

6. Which of the following is a data visualization feature in Power BI?

7. How do you publish a Power BI report to the Power BI Service?

8. What is the purpose of the “Page Navigation” feature in Power BI?

9. How can you apply a theme to a Power BI report?

10. What is the purpose of the “Dataflow” feature in Power BI?

1. How do you remove duplicates from a list in Python?

2. What is the output of print(“Hello, World!”.split(‘,’)) in Python?

3. How do you check the length of a string in Python?

4. How do you create a new list with elements of an existing list in uppercase in Python?

5. How do you create a virtual environment in Python?

6. What is the output of print(5 > 3 and 2 < 4) in Python?

7. How do you add an element to a set in Python?

8. What is the output of print(10 % 3) in Python?

9. What is the output of print(2 + 2 == 4) in Python?

10. Which method is used to convert a string to lowercase in Python?