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