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