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