Quiz Space

Business Data Management · End Term · 13 Apr 2025 · January 2025 term

Question 12: In Excel, the SUBTOTAL function is used to perform calcu…

Question 12

+2 marksOne or more correct options

In Excel, the SUBTOTAL function is used to perform calculations on a filtered range of data. Which of the following statements about the SUBTOTAL function is correct?

Select all that apply.

  1. A

    SUBTOTAL can only calculate the sum of a range and ignores hidden rows in the filtered data.

  2. B

    SUBTOTAL can perform various calculations, including sum, average, count, and more, and it ignores rows hidden by filters.

  3. C

    SUBTOTAL performs calculations only on rows that are manually hidden, not those hidden by filters.

  4. D

    SUBTOTAL can calculate results based on data in any worksheet, regardless of whether the data is visible or hidden.

Show answer

Correct answers

  • A

    SUBTOTAL can only calculate the sum of a range and ignores hidden rows in the filtered data.

  • B

    SUBTOTAL can perform various calculations, including sum, average, count, and more, and it ignores rows hidden by filters.

See the whole paperTake it as a mock test

Question 12 of 24 in the IIT Madras BS Business Data Management (BDM) End Term paper sat on 13 Apr 2025, in the January 2025 term (IIT M DIPLOMA FN EXAM QDD1 13 Apr 2025). It carries 2 marks.

More questions from this paper

  1. Q1What does the law of demand state?
  2. Q2Which function would you use to count the number of cells that meet a specific condition?
  3. Q3In a saturated smartphone market where 70% of current users express interest in upgrading their phones in the next two …
  4. Q4What does the Days of Sales of Inventory indicate?
  5. Q5Which of the following factors is most critical in determining the market potential for a new product ?
  6. Q6Which metric is most important to monitor during an A/B test?
  7. Q7Arrange the following steps while working with unstructured data in a ranking modelling: I. Normalizing\ II. Preprocess…
  8. Q8If a FinTech company wants to cut down losses, which of the following should they do?
  9. Q9PayBuddy conducted an A/B test to understand if their new Funding Instrument recommendation strategy works well. Follow…
  10. Q10PePhone is a FinTech firm that processes payments. Following are sources of revenue for the company – 3.5% of transacti…
  11. Q11Which of the following conditions can use the concept of "weighted average" to analyse expenditure data?
  12. Q13Based on the sample data given answer the subquestions. Determine the percentage change in total revenue when income in…
  13. Q14Based on the sample data given answer the subquestions. What is the type of goods based on the given table?
  14. Q15| Product | Prod. ID | Month 1 Sales | Month 2 Sales | Month 3 Sales | Unit Price (\$) | |---|---|---|---|---|---| | Wi…
  15. Q16| Product | Prod. ID | Month 1 Sales | Month 2 Sales | Month 3 Sales | Unit Price (\$) | |---|---|---|---|---|---| | Wi…
  16. Q17| Product | Prod. ID | Month 1 Sales | Month 2 Sales | Month 3 Sales | Unit Price (\$) | |---|---|---|---|---|---| | Wi…
  17. Q18Based on the data in the table, Calculate the missing values X1, X2, X3 \& X4 and answer the given subquestions. X1:
  18. Q19Based on the data in the table, Calculate the missing values X1, X2, X3 \& X4 and answer the given subquestions. X2:
  19. Q20Based on the data in the table, Calculate the missing values X1, X2, X3 \& X4 and answer the given subquestions. X3 (in…
  20. Q21Based on the data in the table, Calculate the missing values X1, X2, X3 \& X4 and answer the given subquestions. X4 (in…
  21. Q22Match the following | 1. A form created by HR that outlines the budgetary details, skills and capabilities required etc…
  22. Q23Match the following | 1. A form created by HR that outlines the budgetary details, skills and capabilities required etc…
  23. Q24Match the following | 1. A form created by HR that outlines the budgetary details, skills and capabilities required etc…