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