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