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