Test your data skills ! Take A Skill Test Excel Data Visualization Power BI Python /10 5 Time up !! Data Science Test 1 / 10 1. While building a machine learning model we split the data into ? test and train real and virtual dummy and actual test and sample 2 / 10 2. Which chart would you use for correlation ? Sankey Pie Chart Bar Chart Scatter Plot 3 / 10 3. Machine Learning problems are primarily of 2 types which are ... Variance and Covariance Numeric and Non-Numeric Regression and Variance Classification and Regression 4 / 10 4. In PowerBI one can use following to manage the data ? microquery powerquery sql java 5 / 10 5. While building a machine learning model we split the data into ? real and virtual dummy and actual test and sample test and train 6 / 10 6. Which of the following would you use to minimize the impact of outlier ? Mean Max Median Min 7 / 10 7. Which of the following would you use to check the performance of a classification machine learning model in python ? accuracy score match R2 score rmse 8 / 10 8. Confusion Matrix is used for in machine learning models to ... add confusion adding noise splitting data Testing accuracy 9 / 10 9. What is the image above ? A planet Language IDE Library 10 / 10 10. Which of these is not an excel file type ? .xlsx .xlc .xlsm .xls Your score is LinkedIn Facebook 0% Please rate this quiz Send feedback /9 2 Time up !! Excel Test 1 / 9 1. What does the function =LEN(A1) do in Excel? Counts the number of numerical values in cell A1 Calculates the length of the text in cell A1 Extracts the left part of the text in cell A1 Returns the leftmost character in cell A1 2 / 9 2. Which feature in Excel allows you to filter and summarize data from a large dataset? PivotTable Solver Conditional Formatting Data Validation 3 / 9 3. Which feature allows you to quickly fill a range of cells with a series of values based on the content of other cells? Fill Handle Flash Fill AutoComplete AutoFill 4 / 9 4. Which of the following is NOT a valid chart type in Excel? Pie Chart Sankey Diagram Histogram Scatter Plot 5 / 9 5. How do you start a formula in Excel? By typing an asterisk (*) By typing a slash (/) By typing an equals sign (=) By typing a hash (#) 6 / 9 6. Which feature in Excel allows you to filter and summarize data from a large dataset? PivotTable Data Validation Solver Conditional Formatting 7 / 9 7. Which function can be used to look up a value in a table and return a corresponding value from a specified column? VLOOKUP HLOOKUP INDEX MATCH 8 / 9 8. Which function would you use to find the average of a range of cells in Excel? COUNT AVERAGE MEDIAN SUM 9 / 9 9. What shortcut key combination is used to copy the selected cells in Excel? Ctrl + Z Ctrl + X Ctrl + C Ctrl + V Your score is LinkedIn Facebook 0% Please rate this quiz Send feedback /5 Time up !! Data Visualization Try this quiz ! 1 / 5 1. Which visual would you use to display trends over time in Power BI? Line Chart Bar Chart Scatter Plot Pie Chart 2 / 5 2. Which chart would you use for correlation ? Pie Chart Bar Chart Sankey Scatter Plot 3 / 5 3. Which of the following handles outliers in the best way ? Median Mean Standard Deviation Mode 4 / 5 4. Which type of chart is best suited for showing parts of a whole in Power BI? Bar Chart Scatter Plot Line Chart Pie Chart 5 / 5 5. What is this chart type ? Chord chart Sankey Diagram Line chart Web chart Your score is LinkedIn Facebook 0% Please rate this quiz Send feedback /10 0 Time up !! Machine Learning Test 1 / 10 1. Which of the following handles outliers in the best way ? Median Standard Deviation Mode Mean 2 / 10 2. While building a machine learning model we split the data into ? test and sample test and train real and virtual dummy and actual 3 / 10 3. Machine Learning problems are primarily of 2 types which are ... Numeric and Non-Numeric Classification and Regression Variance and Covariance Regression and Variance 4 / 10 4. What is the purpose of feature scaling in machine learning? To improve model interpretability To reduce overfitting in the model To normalize the feature values To increase the dimensionality of the feature space 5 / 10 5. Which of the following is not a supervised learning algorithm? Decision tree K-nearest neighbors (KNN) Linear regression K-means clustering 6 / 10 6. KNN is used for which kind of machine learning problems ? Polynomial Classification Unsupervised Regression 7 / 10 7. Confusion Matrix is used for in machine learning models to ... adding noise add confusion splitting data Testing accuracy 8 / 10 8. Which of the following evaluation metrics is appropriate for a binary classification problem? Mean Absolute Error (MAE) R-squared (R2) score Root Mean Squared Error (RMSE) Precision 9 / 10 9. Which of the following would you use to check the performance of a classification machine learning model in python ? R2 score match rmse accuracy score 10 / 10 10. While building a machine learning model we split the data into ? dummy and actual real and virtual test and train test and sample Your score is LinkedIn Facebook 0% Please rate this quiz Send feedback /10 0 Time up !! PowerBI Test 1 / 10 1. How can you apply a theme to a Power BI report? By using the Home tab By using the View tab By using the Data pane By using the Format pane 2 / 10 2. How do you publish a Power BI report to the Power BI Service? By clicking the Publish button in Power BI Desktop By exporting the report to Excel By sending the report via email By saving the report as a .pbix file 3 / 10 3. Which of the following is a cloud-based business analytics service? Power Pivot Power Query Power BI Desktop Power BI Service 4 / 10 4. What is the purpose of the "Dataflow" feature in Power BI? To build visualizations To create calculated columns To transform and clean data in the cloud To share reports and dashboards 5 / 10 5. What is the purpose of the "Hierarchy" feature in Power BI? To create data models To export data To transform and clean data To organize data into levels 6 / 10 6. What is the purpose of the "Page Navigation" feature in Power BI? To move between different visuals on a page To move between different pages of a report To export data to Excel To filter data within a report 7 / 10 7. How do you create a calculated measure in Power BI? Using the Visualization pane Using the Relationship view Using the Power Query Editor Using the Data view and DAX formula 8 / 10 8. Which of the following is a valid DAX function? SUMX CONCAT JOIN SPLIT 9 / 10 9. How can you add a new data source to an existing Power BI report? By clicking the "New Data Source" button By reopening the report By saving the report By using the "Get Data" button 10 / 10 10. Which of the following is a data visualization feature in Power BI? Custom Visuals DAX Dataflows Data Models Your score is LinkedIn Facebook 0% Please rate this quiz Send feedback /10 0 Time up !! Python Test 1 / 10 1. How do you remove duplicates from a list in Python? list(list) list(set(list)) list.remove_duplicates() list.unique() 2 / 10 2. What is the output of print(5 > 3 and 2 < 4) in Python? 5 > 3 and 2 < 4 Error TRUE FALSE 3 / 10 3. How do you add an element to a set in Python? set.add(element) set.append(element) set.insert(element) set.push(element) 4 / 10 4. Which method is used to convert a string to lowercase in Python? tolower() low() strtolower() lower() 5 / 10 5. How do you create a new list with elements of an existing list in uppercase in Python? [x.upper() for x in list] [x.uppercase() for x in list] [x.capitalize() for x in list] [x.upper_case() for x in list] 6 / 10 6. What is the output of print("Hello, World!".split(',')) in Python? ['Hello,', 'World!'] ['Hello', 'World'] ['Hello', ' World!'] ['Hello World!'] 7 / 10 7. How do you create a virtual environment in Python? python -m venv myenv python create venv myenv python venv create myenv python -m virtualenv myenv 8 / 10 8. What is the output of print(10 % 3) in Python? 2 3 1 0 9 / 10 9. What is the output of print(2 + 2 == 4) in Python? 4 FALSE 2+2 TRUE 10 / 10 10. How do you check the length of a string in Python? len(string) length(string) string.length() string.len() Your score is LinkedIn Facebook 0% Please rate this quiz Send feedback
