Question 47 Johan wants to create a PivotTable using Power Pivot. During the procedure, to add...

 

Transcribed Image Text:

Question 47 Johan wants to create a PivotTable using Power Pivot. During the procedure, to add a Table to PowerPivot, he selects a cell in a Table and clicks Power Pivot tab > Tables group> X. What is X in the procedure? Add to Data Model o Update All ⒸKPIs Measures Question 48 False A student creates data for trees in an orchard. He enters headings in cells A1, B1, C1, D1, and as Tree, Height, Age, Yield, and Height respectively. He mentions the criteria-Mango", 10, "Orange" and <15 in cells A2, B2, A3 and E2 respectively. Cells A4 to A10 with heading "Type of trees" in A4 cell contain data for the type of trees, cells B4 to B10 with heading "Height in B4 cell contain data for the height of trees, cells C4 to C10 with heading "Age" in C4 cell contain data for the age of trees and cells D4 to D10 with heading "Yield" in D4 cell contain data of their annual yield. He can use the formula: -DCOUNTA(ASD10, "Yield". A1 E2) to count the rows containing Mango in column A with a height 10 and <15. True Question 49. C Q Search or type URL r C 1 pts C 1 pts 1 pts C Question 47 Johan wants to create a PivotTable using Power Pivot. During the procedure, to add a Table to PowerPivot, he selects a cell in a Table and clicks Power Pivot tab > Tables group> X. What is X in the procedure? Add to Data Model o Update All ⒸKPIs Measures Question 48 False A student creates data for trees in an orchard. He enters headings in cells A1, B1, C1, D1, and as Tree, Height, Age, Yield, and Height respectively. He mentions the criteria-Mango", 10, "Orange" and <15 in cells A2, B2, A3 and E2 respectively. Cells A4 to A10 with heading "Type of trees" in A4 cell contain data for the type of trees, cells B4 to B10 with heading "Height in B4 cell contain data for the height of trees, cells C4 to C10 with heading "Age" in C4 cell contain data for the age of trees and cells D4 to D10 with heading "Yield" in D4 cell contain data of their annual yield. He can use the formula: -DCOUNTA(ASD10, "Yield". A1 E2) to count the rows containing Mango in column A with a height 10 and <15. True Question 49. C Q Search or type URL r C 1 pts C 1 pts 1 pts C

Answer rating: 100% (QA)

Answering the first Question ie 47 47 Solution Correct Option Add to ... View the full answer