True/False
A student creates data for trees in an orchard.He enters headings in cells A1,B1,C1,D1,and E1 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(A5:D10,"Yield",A1:E2)to count the rows containing Mango in column A with a height >10 and <15.
Correct Answer:

Verified
Correct Answer:
Verified
Q9: Amin wants to extract data from a
Q10: Which of the following will you select
Q11: If Power View is enabled,one can create
Q12: Portia wants to create a calculated measure
Q13: Marcos wants to refresh the data in
Q15: In which of these boxes will you
Q16: Which of the following series of clicks
Q17: A manager creates data for cost of
Q18: Which of these steps will you choose
Q19: Johan wants to create a PivotTable using