Big Data Foundation + Power BI – B6 Posted bymaster October 16, 2021 Leave a comment on Big Data Foundation + Power BI – B6 Welcome to your Big Data Foundation + Power BI - B7 Name Email Enter your DOB (dd/mm/yyyy) 1. Which tab should we go to for removing gridlines on a worksheet? A. Formulas B. View C. Review D. Data None 2. Which of the following features cannot be found in the Data tab in excel? A. What-If Analysis B. PivotTable C. Data Validation D. Text to Columns None 3. What is the count alphabet formula? A. CountA B. CountIfs C. CountIf D. Counttext None 4. What is the Excel formula for count cells in a range that meet a single condition? A. CountIfs B. CountIf C. CountA D. CountS None 5. What function is used to sum up cells that meet multiple criteria? A. Countifs B. CountIf C. CountA D. SumIfs None 6. What is VLOOKUP in simple words? A. Horizontal Lookup B. Vertical Lookup C. Very lookup D. Value lookup None 7. What is the formula when you need to find match from a range by row? A. Hlookup B. Vlookup C. Lookup D. CountA None 8. What is the use of a Pivot Table? A. To summarise, sort, reorganise, group, count, total or average data stored in a table. B. To clean a dataset C. To reorganise a dataset None 9. What is Slicer in pivot charts? A. Graphic filter for pivot chart. B. Summary for pivot chart C. Report for pivot chart D. Change data in chart None 10. What is the use of randbetween formula in excel? A. To find the interquartile range B. To generate random values between two given numbers C. To find same match D. To generate continuous numbers None 11. What is the formula to find the middle number in a given range of numbers? A. Mode B. Median C. Mean D. Average None 12. What is the formula to find average value in a given range of number? A. Mean B. Median C. Mode D. Max None 13. Which of these tools are not used to compare two quantitative variables? A. Scatterplot B. Regression line C. Correlation coefficient D. Pie chart None 14. Can you calculate a correlation if there is only one sample of data? A. Yes B. No None 15. You find a correlation of 0.12. According to Cohen (1988), this effect size is … A. Large B. Medium C. Small D. None of the above None 16. What is the function of tooltip? A. Values B. Tooltip C. Legend D. Axis None 17. In which tab, we can edit the chart background? A. Field B. Format C. Analysis D. Visualizations None 18. What is the name of the visualization as shown below? A. Area chart B. KPI C. Treemap D. Line chart None 19. Which company develop Power Bi? A. IBM B. Google C. Microsoft D. Tableau None 20. What is the size limit of a dataset can use in Power BI? A. 300MB B. 1GB C. 100GB D. Unlimited None 21. The preferred tool for designing or developing report is? A. Power BI Desktop B. Power BI Gateway C. Power BI Report Server D. Power BI service None 22. Which of the following are building blocks of Power BI? A. Tiles, dashboard, databases, mobile devices B. Visualizations, Datasets, Report, Dashboard, tiles C. Visual studio, C# and JSON files None 23. What is the Power BI file format? A. Pbi B. Xlsx C. Xls D. Pbix None 24. Which of these are NOT an option after you've opened your data? A. Combine B. Load C. Transform Data D. All are options None 25. Which of the following is statements is FALSE? A. Filtering data in Power Query filters data in the report. B. Filtering data using slicers filters data in the report C. Hiding data in the Data Model filters data in the report. D. Filtering data in the Data Model does not filter data in the report. None 26. What is a Power BI report? A. A application for clean data B. A Canvas C. Key-Influencers D. Visuals that represent different findings and insight from dataset None 27. What is the name of the visualization as shown below? A. Funnel Chart B. KPI C. Line Chart D. Treemap None 28. What is the best chart for change-over-time? A. Pie chart B. Bar chart C. Line Chart D. Any Chart None 29. A Horizontal Bar chart is useful to display…? A. A list of categories that have long names. B. The different between each category C. Percentage of category D. Bar chart None 30. What is the most effective chart in "comparison" of different categories? A. Line Chart B. Pie Chart C. Bar Chart D. Box Plot None 31. Which chart is not recommended by data scientists? A. Histogram B. Bar Chart C. Line Chart D. Pie Chart None 32. In a line chart, what is the maximum number of the lines that we can use? A. 2 B. 3 C. 4 D. 5 None 33. What is an alternative chart to the pie chart? A. Line Chart B. 100% Stacked Bar chart C. Box Plot D. Scatter Plot None 34. Scatter plots are used extensively by the scientific community. Why might we use scatter plots? A. To illustrate the magnitude of one variable over time B. To visualize the relationship between two variables C. To provide easy comparison for a ‘before’ and ‘after’ None 35. Good Data Storytelling is comprised of two main elements. What are the two main elements? A. Visual & Synopsis B. Story & Synopsis C. Visual & Story D. Voice & Story None 36. What is a concern when using a line graph to visualize categorical data? A. Values at any point in the line are not obvious B. A line implies that categorical data is continuous C. The forecasts we make with line charts are not great D. Categorical variables must be processed before they can be used for visualization None 37. In the context of Data Storytelling, what is a call-to-action? A. It is a statement that tells the audience what you need them to do or perform having viewed the visual B. It is a calculable formula that defines the amount of call to the amount of action in a visual C. It is a catchy header that grabs attention and sticks in the mind D. It is a 20 seconds summary of findings from a given piece of analysis None 38. Hybrid titles are multi-functioning titles that play a variety of roles on a visual. Which of the following is included in a Hybrid Title provide? I. Colour Legend for VisualII. Context of the visualIII. Insightful Information A. II and III B. I, II and III C. I and III D. III only None 39. What are the main elements in the Hybrid title? A. Call to action, Legend and Story B. Call to action, visual and legend C. Call to action, legend and Insight D. Visual, insight and Legend None 40. If the call to action appears first in the hybrid title, it means... A. Toe to Head B. Head to Toe C. Top to Bottom D. Bottom to Top None 1 out of 9 Your quiz is running out of time! few seconds are remaining. Time is Up!
