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