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