Big Data Foundation + Power BI – B8

1. Which tab should we go to for removing gridlines on a worksheet?

A. Formulas

B. View

C. Review

D. Data

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

3. What is the count alphabet formula?

A. CountA

B. CountIfs

C. CountIf

D. Counttext

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

5. What function is used to sum up cells that meet multiple criteria?

A. Countifs

B. CountIf

C. CountA

D. SumIfs

6. What is VLOOKUP in simple words?

A. Horizontal Lookup

B. Vertical Lookup

C. Very lookup

D. Value lookup

7. What is the formula when you need to find match from a range by row?

A. Hlookup

B. Vlookup

C. Lookup

D. CountA

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

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

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

11. What is the formula to find the middle number in a given range of numbers?

A. Mode

B. Median

C. Mean

D. Average

12. What is the formula to find average value in a given range of number?

A. Mean

B. Median

C. Mode

D. Max

13. Which of these tools are not used to compare two quantitative variables?

A. Scatterplot

B. Regression line

C. Correlation coefficient

D. Pie chart

14. Can you calculate a correlation if there is only one sample of data?

A. Yes

B. No

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

16. What is the function of tooltip?

A. Values

B. Tooltip

C. Legend

D. Axis

17. In which tab, we can edit the chart background?

A. Field

B. Format

C. Analysis

D. Visualizations

18. What is the name of the visualization as shown below?

A. Area chart

B. KPI

C. Treemap

D. Line chart

19. Which company develop Power Bi?

A. IBM

B. Google

C. Microsoft

D. Tableau

20. What is the size limit of a dataset can use in Power BI?

A. 300MB

B. 1GB

C. 100GB

D. Unlimited

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

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

23. What is the Power BI file format?

A. Pbi

B. Xlsx

C. Xls

D. Pbix

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

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.

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

27. What is the name of the visualization as shown below?

A. Funnel Chart

B. KPI

C. Line Chart

D. Treemap

28. What is the best chart for change-over-time?

A. Pie chart

B. Bar chart

C. Line Chart

D. Any Chart

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

30. What is the most effective chart in "comparison" of different categories?

A. Line Chart

B. Pie Chart

C. Bar Chart

D. Box Plot

31. Which chart is not recommended by data scientists?

A. Histogram

B. Bar Chart

C. Line Chart

D. Pie Chart

33. What is an alternative chart to the pie chart?

A. Line Chart

B. 100% Stacked Bar chart

C. Box Plot

D. Scatter Plot

Big Data Foundation + Power BI – B8

Leave a comment

Cancel reply