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