Crowdly
Додати до Chrome
Questions Bank (1532779 total)
In Power Pivot, which aspects of a calculated column can be changed without editing the formula? (Select all that apply)
Formula content
❌
Data type
✅
Display format
✅
Column name
✅
Переглянути це питання
What is the key difference between one-to-many and many-to-many relationships in Power Pivot?
One-to-many has a unique key on one side, many-to-many does not
✅
Many-to-many has a unique key on both sides
❌
One-to-many is only used in pivot tables
❌
They are exactly the same
❌
Переглянути це питання
How do you create relationships between tables in Power Pivot?
Use Merge Queries in Power Query
0%
Copy data manually
0%
Use the Manage Relationships dialog in Power Pivot
0%
Relationships are created automatically
0%
Переглянути це питання
What is the main purpose of Power Pivot?
To create a data model by integrating multiple sources
0%
To design charts and graphs
0%
To create pivot tables only
0%
To automate Excel macros
0%
Переглянути це питання
What is the primary method to create a query in Power Query?
Type data directly in the Query Editor
❌
Use a VBA macro
❌
Use conditional formatting
❌
Import data from a table or external source and open the Query Editor
✅
Переглянути це питання
How can you combine queries from multiple sources in Power Query?
Only Merge Queries
❌
Both Append Queries and Merge Queries
✅
Only Append Queries
❌
Manual copy-paste is required
❌
Переглянути це питання
What does unpivoting data in Power Query do?
Creates a duplicate table
❌
Groups data by a field
❌
Sorts data in descending order
❌
Transforms columns into rows
✅
Переглянути це питання
How do you remove unwanted columns in Power Query?
Use pivot tables
0%
Not possible to remove columns
0%
Manually delete data from the worksheet
0%
Use the Remove Columns option in the Home tab
0%
Переглянути це питання
What is the purpose of creating conditional columns in Power Query?
To split a column by delimiter
❌
To remove duplicate rows
❌
To add a new column based on conditions
✅
To refresh the data source
❌
Переглянути це питання
What is query folding in Power Query?
An error handling technique
0%
A method for merging queries
0%
It is the process of pushing transformations back to the source
0%
A way to format queries
0%
Переглянути це питання
Попередня
1
Більше сторінок
139269
139270
139271
139272
139273
Більше сторінок
153278
Наступна
Telegram
Instagram
TikTok
Question Bank
Умови використання
Зв'яжіться з нами
Додати до Chrome