Excel
SQL
Statistics
Power BI
Tableau
100
Where you can highlight cells that meet certain criteria?
Conditional Formatting
100
What is the purpose of the WHERE clause in SQL?
The WHERE clause is used to filter rows based on a specific condition in a SQL query, allowing you to retrieve only the records that meet the specified criteria.
100
What is the difference between a mean and a median?
The mean is the average of a set of data.
The median is the middle value in a set of data that has been ranked from least to greatest.
100
What is a slicer?
A slicer is a visual control in Power BI that allows users to filter data by selecting values from a list.
100
____ are categorical or qualitative fields that provide descriptive information or context to the data.
Dimensions
200
What is the difference between a VLOOKUP and Index Match?
VLOOKUP value must be in the first column of the table While INDEX returns a value from a range and MATCH returns the position of a value in a range.
200
What is the difference between DATE_PART and DATE_TRUNC data in SQL?
DATE_TRUNC is continuous and DATE_PART is Discrete.
200
What is the range of correlation ?
+1 to -1
200
What is the built-in application in Power BI that used to clean data?
Power Query Editor
200
What is the difference between Tableau workbook "TWB" and Tableau packaged workbook "TWBX"?
TWB file contains references to the data source(s) used in the workbook, but it does not store the actual data.
While TWBX file is a compressed archive that contains the entire workbook structure and data.
300
Which function in Excel is used to count the number of cells that meet specific criteria?
COUNTIF
300
What is the difference between UNION and UNION ALL in SQL?
UNION combines the result sets of two or more SELECT statements, eliminating duplicate rows, while UNION ALL combines the result sets without removing duplicates.
300
What is 68-95-99.7 rule in standard deviation?
The standard deviation is a measure of how spread out a set of data and 68% of data are within one standard deviation, 95% within two standard deviations, and 99.7% within three standard deviations.
300
What is (BI) stand for?
BI is a business intelligence
300
How can you create a dynamic top N in Tableau?
To create a dynamic top N in Tableau, you should drag a dimension to Filters shelf and define a measure to set the order.
400
Mention three types of data cannot be cleaned in Excel?
-Audio
-Video
-Images
400
What are the 5 joins in SQL?
inner join, full outer join, left join, right join and cross join.
400
What is the difference between descriptive statistics and inferential statistics?
Descriptive statistics: summarizes and describes the main features of a dataset, such as mean, median, and standard deviation.
Inferential statistics: involves drawing conclusions or making predictions.
400
List FOUR visualizations can be generated using Power BI?
Cluster Column Chart, Line Chart, Area Chart, Scatter Chart, Matrix, Pie Chart
400
List FOUR Marks in Tableau?
Colors, Size, Text, Detail, Tooltip and Shapes.
500
In an Excel worksheet, you have a column "A" containing the names of employees, column "B" containing job titles, and column "C" containing years of experience. Write a statement that checks if an employee's job title is "Manager" and their years of experience is greater than or equal to 5.
If both conditions are met, return "Eligible for Bonus." Otherwise, return "Not Eligible for Bonus."
=IF(AND(B2="Manager", C2>=5), "Eligible for Bonus", "Not Eligible for Bonus")
500
Given a table "Products" with columns "ProductID" and "Price," write a query to find the top 5 most expensive products.
SELECT ProductID, Price
FROM Products
ORDER BY Price DESC
LIMIT 5;
500
What is Population Standard Deviation Formula?
500
What file extension is used for Power BI Desktop files?
Power BI Desktop files use the (.pbix) extension.
500
How many rows Tableau Desktop can handle?
Typically 15 million rows for 32-bit systems and up to 1 billion rows for 64-bit systems. However, these limits may vary based on available memory and system specifications.