Excel Data Analyze (Power Query, Pivot Table & Power Pivot Quiz)
Time Left:
03:00
📧 Enter Your Email:
1. What is the main purpose of Power Query in Excel?
A) To automate data visualization
B) To transform and clean data before analysis
C) To create dynamic pivot tables
2. Which file formats can Power Query import data from?
A) CSV, Excel, Database, Web, JSON
B) Only Excel and CSV
C) Only SQL Databases
3. In Power Pivot, what is the main advantage of using the Data Model?
A) It allows relationships between tables without VLOOKUP
B) It is used only for data visualization
C) It replaces Pivot Tables completely
4. What function is commonly used in Power Query to merge two tables?
A) Merge Queries
B) Append Queries
C) CONCATENATE
5. Which formula language is used in Power Pivot to create calculated columns?
A) DAX (Data Analysis Expressions)
B) VBA
C) M Language
6. What is a key difference between Power Pivot and Pivot Tables?
A) Power Pivot supports relationships between tables
B) Pivot Tables are better for large datasets
C) Power Pivot is just an improved Pivot Table
7. What is the purpose of the "Group By" function in Power Query?
A) To filter data
B) To summarize data based on specific columns
C) To merge multiple tables
8. What happens when you disable "Enable Load" in Power Query?
A) The query stops loading into Excel
B) The query deletes the original data
C) The query runs twice
9. What is an advantage of using Power Pivot instead of regular Excel formulas?
A) It improves performance with large datasets
B) It makes Excel files smaller
C) It replaces all Excel formulas
10. What is the role of the "Measure" in Power Pivot?
A) To create aggregated calculations like SUM, AVERAGE
B) To filter tables
C) To change table relationships
Submit
Reset