Toggle navigation
GoSkills
Courses
Courses
Train your organization
Supercharge your organization with expert-led business and productivity courses.
Learn more
Learn on your own
Earn certifications for the most in-demand skills with unlimited access to all GoSkills courses.
Learn more
Explore our courses
Browse our award-winning library of 110+ business and productivity courses delivered in bite-sized lessons.
Explore courses
LMS
Course builder
Resources
Pricing
Organization pricing
Individual pricing
Pricing
Search
Sign up
Log in
Log in
Signup
Quiz
1
Intermediate
What’s the easiest way to create a relationship between two tables in the diagram view of Power Pivot?
Click on the field in one table and to drag the field in the other
Click on the field in one table, hold down CTRL and click on the field in other
Right click on the field in one table ⇒ Create Relationship ⇒ select table and field
Don’t know
2
Intermediate
Why is it important to hide the field on the Many side of the join?
Because it prevents users from adding it to a Dimension table
Because it will slow the refresh speed of the Pivot Table
Because you cannot have fields with same name
Don’t know
3
Intermediate
What would prevent you from linking the Account fields in the two tables depicted here?
The tables are already joined by Dept fields
Repeating values in the Account columns in both tables
Because the tables are both Fact tables with unique values
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement