Quiz Space

Business Data Management · Quiz 2 · 16 Mar 2025 · January 2025 term

Question 5: For the Data Given below, which function would you use to…

Question 5

+1 markOne correct option

For the Data Given below, which function would you use to count the number of salespeople who exceeded both their Q1 and Q2 quotas.

  1. A

    COUNT(A2:A5,"=Yes",C3:C5,"=Yes")

  2. B

    COUNTIFS(B2:B5,"=Yes",C2:C5,"=Yes")

  3. C

    COUNTIF(B2:B5,"=Yes",C2:C5,"=Yes")

  4. D

    COUNTA(C2:C5,"=Yes",D2:D5,"=Yes")

Show answer

Correct answer

  • B

    COUNTIFS(B2:B5,"=Yes",C2:C5,"=Yes")

See the whole paperTake it as a mock test

Question 5 of 15 in the IIT Madras BS Business Data Management (BDM) Quiz 2 paper sat on 16 Mar 2025, in the January 2025 term (IIT M DIPLOMA AN EXAM QDD2 16 Mar 2025). It carries 1 mark.

More questions from this paper

  1. Q1What best describes the Economic Census conducted by the government?
  2. Q2When would you most likely use a bar graph in Excel?
  3. Q3What are the roles that the Government plays in the economic circular flow model?
  4. Q4What kind of goods’ demand decreases as income increases?
  5. Q6In the formula =VLOOKUP(A1, B1:C10, 2, FALSE), what does the "2" represent?
  6. Q7Which chart is used to display the distribution of a dataset by dividing it into bins?
  7. Q8What does SOR refer to in e-commerce?
  8. Q9Which of the following statements best describes the difference between a niche market and a mass market?
  9. Q10Calculate the Overall Equipment Effectiveness (OEE) of the Assembly Line Equipment for the month of July. (Round the OE…
  10. Q11Based on this information, At what inventory level should you trigger a re-order for gear assemblies?
  11. Q12After how many days should you trigger a re-order
  12. Q13| SKU | Product Name | Unit Price | Monthly Sales 1 | Monthly Sales 2 | Monthly Sales 3 | Monthly Sales 4 | Monthly Sal…
  13. Q14| SKU | Product Name | Unit Price | Monthly Sales 1 | Monthly Sales 2 | Monthly Sales 3 | Monthly Sales 4 | Monthly Sal…
  14. Q15| SKU | Product Name | Unit Price | Monthly Sales 1 | Monthly Sales 2 | Monthly Sales 3 | Monthly Sales 4 | Monthly Sal…