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