BTechibtechi.in
Loading Loading
Free IIT Madras BS notes, PYQs and mock tests at btechi.in

BDM · Quiz 2 · 3 Aug 2025 (Afternoon)

15 questions · 20 marks · 60 min

Answer key Take as mock

Indian Institute of Technology Madras

BS Degree Programme · Examination & Study Paper

Business Data Management

Quiz 2 · 3 Aug 2025 (Afternoon)

Official Paper

Examination Instructions & Guidelines

Solve on notebook/paper first before checking solutions.
MCQ: Exactly 1 option is correct. Negative marking applies.
MSQ: One or more options correct. Select all to score.
NAT: Numerical response. No negative marking.
Scientific calculator allowed for all calculations.
Official answer key is sealed at the end of this sheet.

Q1MCQ1 Mark·Choose one option
Key ↓
1. AThe reference to cell B1 will adjust when the formula is copied to other cells.
2. BThe reference to cell B1 is absolute and will not change when the formula is copied to other cells.
3. CThe reference to cell A1 is absolute and will not change when the formula is copied to other cells.
4. DThe reference to cell A1 is absolute, but reference to B1 is relative.
Q2MCQ1 Mark·Choose one option
Key ↓
What are the roles that the Government plays in the economic circular flow model?
1. AProducer and Consumer
2. BModerator and Participant
3. CBoth Producer and Consumer & Moderator and Participant
4. DNone of these
Q3MCQ1 Mark·Choose one option
Asked 3 times Key ↓
Which of the following factors is most critical in determining the market potential for a new product ?
1. AThe size of the target market and percentage of potential customers interested in the product.
2. BHistorical sale data of unrelated products.
3. CCost of production and distribution.
4. DCurrent market share of existing products.
Q4MCQ1 Mark·Choose one option
Asked 3 times Key ↓
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?
1. ASUBTOTAL can only calculate the sum of a range and ignores hidden rows in the filtered data.
2. BSUBTOTAL can perform various calculations, including sum, average, count, and more, and it ignores rows hidden by filters.
3. CSUBTOTAL performs calculations only on rows that are manually hidden, not those hidden by filters.
4. DSUBTOTAL can calculate results based on data in any worksheet, regardless of whether the data is visible or hidden.
Q5MCQ1 Mark·Choose one option
Asked 3 times Key ↓
Which of the following is typically NOT performed when using a pivot table in data analysis ?
1. AFiltering data to display only specific records.
2. BCreating new records in the original dataset.
3. CGrouping data by categories or fields to analyze trends and patterns.
4. DSummarizing data by aggregating values, such as sum, count, or average.
Q6MCQ1 Mark·Choose one option
Asked 3 times Key ↓
Which chart can be used to represent the intensity or size of a data ?
1. AScatter Plot
2. BBubble Chart
3. CHistogram
4. DBox Plot
Q7MCQ1 Mark·Choose one option
Key ↓
What does SOR refer to in e-commerce?
1. ASales of Resource
2. BSale or Return
3. CSales of Return
4. DSales on Regular
Q8MSQ2 Marks·Choose all correct options
Asked 2 times Key ↓
Which of the following statements best describes the difference between a niche market and a mass market?
1. AA niche market targets a small, specific group of customers with specialized needs, while a mass market targets a large, broad group of customers with general needs.
2. BA niche market involves offering lower-priced products to a wide audience, whereas a mass market involves offering high-end products to a small, exclusive group.
3. CA niche market typically requires large-scale advertising campaigns to reach a broad audience, while a mass market relies on word-of-mouth and targeted marketing.
4. DA niche market focuses on standard products that appeal to everyone, while a mass market customizes products to fit individual customer preferences.
Q9NAT1 Mark·Write the number
Asked 2 times Key ↓
Determine the percentage change in total revenue when income increases from Rs 15000 to Rs 25000. (upto 3 decimals, hint : if your ans is 98% then enter 0.98 as your answer). Income level 1 1) Income = Rs 15,000 2) Qty demanded = 60 units 3) Price per qty = Rs 40 Income level 2 1) Income = Rs 25,000 2) Qty demanded = 90 units 3) Price per qty = Rs 38
Your answer:
Q10NAT2 Marks·Write the number
Asked 4 times Key ↓
Your answer:
Read the passage below, then answer Q11–Q12
Based on the above data, answer the given subquestions.
Q11MCQ1.5 Marks·Choose one option
Key ↓
Based on this information, at what inventory level should you trigger a re-order for gear assemblies?
1. AInitiate a re-order when the inventory level drops to 70 units
2. BInitiate a re-order when the inventory level drops to 50 units
3. CInitiate a re-order when the inventory level drops to 30 units
4. DInitiate a re-order when the inventory level drops to 15 units
Q12NAT1.5 Marks·Write the number
Key ↓
After how many days should you trigger a re-order
Your answer:
Read the passage below, then answer Q13–Q15
Q13MCQ2 Marks·Choose one option
Asked 2 times Key ↓
Which SKU has the highest Days of Inventory?
1. ALAP002
2. BLAP003
3. CLAP006
4. DLAP007
Q14MCQ2 Marks·Choose one option
Key ↓
If the profit margin for the sale of a laptop is 10%, what is the total profit earned from the sale of LAP005?
1. A42505
2. B40890
3. C41782
4. D40473
Q15MCQ1 Mark·Choose one option
Asked 3 times Key ↓
What percentage of total revenue do the SKUs LAP004 and LAP005 contribute together?
1. A10%
2. B20%
3. C15%
4. D25%

Official Key

Master Answer Key & Explanations

Official answer keys from IIT Madras BS past papers. Click any question to review.

Reveal Key

Q1B

Q2C

Q3A

Q4B

Q5B

Q6B

Q7B

Q8A

Q90.425

Q100.77 to 0.81

Q11A

Q126

Q13B

Q14D

Q15B

Questions and answer keys are reproduced from the official IIT Madras BS papers. BTechi is not affiliated with IIT Madras.