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