Where would you access the Manage Relationships dialog box to create a data model in Excel?
A) Relationships on the Data tab
B) Data Models on the Analyze tab
C) Layout on the Design tab
D) Joins on the Data tab
Correct Answer:
Verified
Q21: Using the % of Grand Total Calculation
Q22: A(n)_ is the association between tables where
Q23: What is the best option for a
Q24: What does applying a banded row format
Q25: Which is not true about Slicers?
A)Aggregate values
Q27: A PivotTable time line can filter dates
Q28: What field is in the ROWS area
Q29: Which is not true of filters in
Q30: A PivotChart _.
A)is not altered by filters
Q31: How would you add a date filter
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents