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