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