Big Data Foundation + Power BI – B13

1. 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

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. Which tab should we go to for removing gridlines on a worksheet?

A. Formulas

B. View

C. Review

D. Data

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

32. In data mining, which machine learning models are well-known?

i. Neural Network
ii. Cross-Validation
iii. Decision Tree

A. II and III

B. I, II and III

C. I and II

D. I only

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

A. Line Chart

B. 100% Stacked Bar chart

C. Box Plot

D. Scatter Plot

34. In WEKA Explorer, how we call the rows?

A. Relation

B. Instances

C. Attributes

35. Which of these not a data sources?

A. Social Media

B. Public Data

C. Database

D. Enterprise

36. What is API stand for?

A. Application Programming Integration

B. Application Programming Interface

C. Software between two application

D. Application Processing Interface

37. What API is the primary way to get data into and out of the Facebook?

A. Graph API

B. Marketing API

C. Facebook Ad Library API

D. Pages API

38. In WEKA Explorer. What are the test options available?

i. Use Training Set
ii. Cross-Validation
iii. Percentage split

A. II and III

B. I, II and III

C. I and III

D. III only

39. What is top language for data science?

A. C++

B. HTML

C. R Language

D. Java

40. What is use of Facebook Graph API access-token?

A. The Token needed for apps to make sure of the API request on behalf of the current user.

B. Token to access Facebook without password

C. Token to view Graph in Facebook

D. Token to view Facebook Business sales