now help me solve all objective questions answer step by step on Power query
- User
now help me solve all objective questions answer step by step on Power query
- Assistant
I'll help you solve each objective question step by step using Power Query. Let me walk you through how to verify each answer practically.
Setting Up Power Query
First, let's load your data:
- Open Excel
- Go to Data tab → Get Data → From File → From Workbook
- Select your
indian_power_query_dirty_data.xlsxfile - Click Transform Data to open Power Query Editor
Now let's verify each answer:
Question 1: Power Query তে "error" মান রিমুভ করার অপশন কী?
Step-by-Step Verification:
-
Create a sample error (if not already in your data):
- Select any numeric column
- Go to Transform tab → Standard → Divide
- Divide by 0 to create an error
-
Check available options:
- Go to Home tab
- Click on Remove Rows dropdown
- You'll see these options:
- Remove Top Rows
- Remove Bottom Rows
- Remove Alternate Rows
- Remove Duplicates
- Remove Blank Rows
- Remove Errors ✓
-
Test each option:
- Remove Nulls: This option doesn't exist in the Remove Rows menu
- Replace Values: Found in Transform tab, but it replaces values, doesn't remove rows
- Remove Errors: Click this and it removes all rows containing errors
- Clean Function: Found in Transform tab → Format → Clean, but it removes non-printable characters
Answer: c) Remove Errors
Question 2: "None" মান কোন ধরণের ডেটা সমস্যা?
Step-by-Step Verification:
-
Create or find a "None" value:
- Look for empty cells in your data
- In Power Query, these appear as
null
-
Analyze the nature of "None":
- Right-click on a cell with
null - Notice it represents absence of data
- It's not a syntax error (code problem)
- It's not a formatting error (display issue)
- It's not a column mismatch (structural problem)
- Right-click on a cell with
-
Test by replacing:
- Select column with nulls
- Go to Transform → Replace Values
- Replace
nullwith "Missing Data" - This confirms it's a missing value issue
Answer: b) Missing Value
Question 3: নিচের কোন কমান্ড ব্যবহার করে শুধুমাত্র "Delhi" শহরের ডেটা রাখা যায়?
Step-by-Step Verification:
-
Test Sort:
- Click on City column dropdown
- Select Sort A to Z
- Result: Data is arranged alphabetically but all cities remain
-
Test Filter:
- Click on City column dropdown
- Uncheck (Select All)
- Check only Delhi
- Click OK
- Result: Only Delhi records remain ✓
-
Test Replace:
- Go to Transform → Replace Values
- This changes values but doesn't remove rows
-
Test Merge:
- Go to Home → Combine → Merge Queries
- This is for joining tables, not filtering
Answer: b) Filter
Question 4: কোন অপশন দিয়ে নতুন কলাম যুক্ত করা হয় Power Query-তে?
Step-by-Step Verification:
-
Test Add Column → Custom Column:
- Go to Add Column tab
- Click Custom Column
- Enter column name: "Test"
- Enter formula:
"New Value" - Click OK
- Result: New column added ✓
-
Test Home → Append Queries:
- Go to Home tab → Combine → Append Queries
- This adds rows from another table, not columns
-
Test View → Advanced Editor:
- Go to View tab → Advanced Editor
- This shows M code, doesn't directly add columns
-
Test Transform → Detect Data Type:
- Go to Transform tab → Detect Data Type
- This changes data types, doesn't add columns
Answer: a) Add Column → Custom Column
Question 5: Power Query তে "error" শব্দটি কোন টাইপের ইনপুট হতে পারে?
Step-by-Step Verification:
-
Create different types of errors:
Test Data Type Mismatch:
- Create a custom column:
= [Salary] / "ABC" - Result: Error (can't divide number by text) ✓
Test Valid Entry:
- Any correct data doesn't produce errors
Test Text Only:
- Text columns work fine with text data
Test Column Header:
- Column headers are just names, not error sources
- Create a custom column:
-
Common error scenarios:
- Dividing by zero:
= [Amount] / 0 - Invalid date conversion:
= Date.From("Not a date") - Type mismatch in calculations:
= [Text Column] * 2
- Dividing by zero:
Answer: c) Data Type Mismatch
Summary Table of Answers:
Question Answer Key Power Query Location 1 c) Remove Errors Home → Remove Rows → Remove Errors 2 b) Missing Value Null values represent missing data 3 b) Filter Column dropdown → Filter options 4 a) Add Column → Custom Column Add Column tab → Custom Column 5 c) Data Type Mismatch Errors occur when data types don't match operations Pro Tips for the Exam:
- Remember the ribbon structure: Home, Transform, Add Column tabs
- Errors in Power Query show as "Error" in cells
- Nulls appear as "null" in italic text
- Always check the dropdown menus for available options
- Practice these operations before your exam to build muscle memory
Other models, same or similar prompt
Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.