Ned wants to calculate the total sale of a product during quarters 3 and 4 of a financial year.He creates a table of quarterly sales of different products o the company in different regions.In the table,cells B1 to B20 with heading "Quarter" list the quarters of the years I to IV,cells C1 to C20 with heading "Product" lists the different products and cells D1 to D20 with heading "Sales" list the sales amount for each quarter and product in dollars.The criteria specified-Quarter and Product are in cells H5 and I5 and their values >3 and Balloons respectively are mentioned in cells H6 and I6.To calculate the total sale of a particular product,he can use the formula =DSUM(B1:D20,"Sales",H5:I6).
Correct Answer:
Verified
Q12: Which of the following series of clicks
Q13: After drilling down,Esteban wants to drill up
Q14: Which of the following will you select
Q15: In which of these boxes will you
Q16: Amin wants to extract data from a
Q17: Which of these series of clicks will
Q18: To illustrate different data levels using small
Q20: Johan wants to create a PivotTable using
Q21: If Power View is enabled,one can create
Q22: To add a title to a Power
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