Quiz Space

Business Data Management · Quiz 2 · 23 Nov 2025 · September 2025 term

Question 11: An analyst builds a Pivot Table to summarize quarterly s…

Question 11

+1 markOne correct option

An analyst builds a Pivot Table to summarize quarterly sales by region.
After adding new March data to the source sheet, totals in the Pivot remain unchanged. Why?

  1. A

    Pivot Tables auto-refresh when new data is added.

  2. B

    Source data range must be updated or refreshed manually.

  3. C

    The new data used a different number format.

  4. D

    The Pivot Table cannot be altered once created.

Show answer

Correct answer

  • B

    Source data range must be updated or refreshed manually.

See the whole paperTake it as a mock test

Question 11 of 15 in the IIT Madras BS Business Data Management (BDM) Quiz 2 paper sat on 23 Nov 2025, in the September 2025 term (IIT M DIPLOMA AN EXAM QDD2 23 Nov 2025 NEW). It carries 1 mark.

More questions from this paper

  1. Q1Which of the following statements is not true about the benefits of implementing an ERP system?
  2. Q2The number of heavy vehicle driving licenses issued can be used as a _ of the potential market size for trucks.\ (Fill …
  3. Q3If a company identifies a seasonal pattern in their sales data, how should this influence their inventory management st…
  4. Q4Which of the following statements best describes the difference between platform companies and niche companies?
  5. Q5Which of the following best explains the risk of maintaining excessively low Days of Inventory?
  6. Q6Which of the following corrective actions should Trio Engineering consider restoring balance between efficiency and rel…
  7. Q7Which category does ProMech Components Ltd. fall into?
  8. Q8If the time lost was reduced by 50%, which category does ProMech Components Ltd. fall into?
  9. Q9If they could make 20 more components per hour, what would have been the OEE?\ (ignore the case of other sub-question)
  10. Q10Which chart type best shows the relationship between advertising spend and sales across 10 branches?
  11. Q12Conside the following and select the correct option.\ Assertion (A): Line charts are used to visualize trends over time…
  12. Q13In the circular flow model, when households increase savings with financial institutions, which immediate effect is mos…
  13. Q14A data analyst uses CMIE’s Consumer Pyramids Household Survey to track shifts in average household electricity spending…
  14. Q15What can be inferred about the relationship between income and the demand for goods with fixed prices? [Select all that…