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