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