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

BDM · End Term · 13 Apr 2025 (Forenoon)

24 questions · 30 marks · 90 min

Answer key Take as mock

Indian Institute of Technology Madras

BS Degree Programme · Examination & Study Paper

Business Data Management

End Term · 13 Apr 2025 (Forenoon)

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 ↓
What does the law of demand state?
1. AAs the price of a good increases, the quantity demanded decreases
2. BAs the price of a good decreases, the quantity demanded decreases
3. CAs the price of a good increases, the quantity supplied decreases
4. DAs the price of a good decreases, the quantity supplied increases
Q2MCQ1 Mark·Choose one option
Key ↓
Which function would you use to count the number of cells that meet a specific condition?
1. ACOUNT
2. BCOUNTA
3. CCOUNTIF
4. DCOUNTSUM
Q3MCQ1 Mark·Choose one option
Asked 2 times Key ↓
In a saturated smartphone market where 70% of current users express interest in upgrading their phones in the next two months, and the no. of new smartphone users remain unchanged, what should companies/manufacturers prioritize?
1. AExpand distribution channels to reach untapped geographic regions.
2. BFocus on females as their target customers.
3. CInvest in research and development to create innovative features for new customers.
4. DDevelop targeted upgrade incentives and promotions for current users looking to replace their old devices
Q4MCQ1 Mark·Choose one option
Asked 2 times Key ↓
What does the Days of Sales of Inventory indicate?
1. AThe average number of days required by a company to turn its inventory into sales.
2. BThe number of days when inventory is zero in a year
3. CTotal number of days when inventory sales is zero due to lack of inventory
4. DThe average number of inventory stockout days in a month
Q5MCQ1 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.
Q6MCQ1 Mark·Choose one option
Key ↓
Which metric is most important to monitor during an A/B test?
1. ATotal number of users tested in the experiment
2. BUptime of the system
3. CKey performance indicators (KPIs) specific to the experiment
4. DModel training time
Q7MCQ1 Mark·Choose one option
Key ↓
Arrange the following steps while working with unstructured data in a ranking modelling: I. Normalizing II. Preprocessing III. Ranking IV. Composite score
1. AI -> II -> III -> IV
2. BII -> I -> IV -> III
3. CI -> II -> I -> IV -> III
4. DI -> II -> I -> III -> IV
Q8MCQ1 Mark·Choose one option
Asked 2 times Key ↓
If a FinTech company wants to cut down losses, which of the following should they do?
1. ADecrease approval cutoff of credit score
2. BIncrease interest rate
3. CIncrease approval limit for loans
4. DIncrease approval cutoff of credit score
5. EGive more loans
Q9MCQ2 Marks·Choose one option
Asked 3 times Key ↓
PayBuddy conducted an A/B test to understand if their new Funding Instrument recommendation strategy works well. Following are the details of the control and treatment groups. From the given table, which of the following statements are true? i. Value of Credit transactions increased with the new recommendation strategy ii. Value of Debit transactions increased with the new recommendation strategy iii. Value of both Credit and Debit transactions increased with the new recommendation strategy iv. Value of Credit transactions decreased with the new recommendation strategy v. Value of Debit transactions decreased with the new recommendation strategy
1. ABoth (i) & (v)
2. BOnly (iii)
3. COnly (i)
4. DBoth (ii) & (iv)
5. EOnly (v)
Q10MCQ2 Marks·Choose one option
Asked 3 times Key ↓
PePhone is a FinTech firm that processes payments. Following are sources of revenue for the company – 3.5% of transaction amount as transaction fee from merchant for all types of transactions (credit and debit), 18% p.a. interest on credit transactions and incurs a loss of credit if not paid back. Calculate the overall profit for the company based on the below table – (Assume payback of credit in a year) Note: Declined transactions will not get credit but customers will complete the payment through PePhone using their bank details.
1. A– 211.0
2. B– 192.72
3. C–131.94
4. D– 162.18
Q11MSQ1 Mark·Choose all correct options
Key ↓
Which of the following conditions can use the concept of "weighted average" to analyse expenditure data?
1. ABy considering importance of expenditure categories
2. BBy considering the population size of different regions
3. CBy adjusting for inflation over time
4. DBy analyzing the impact of income levels on expenditure
Q12MSQ2 Marks·Choose all correct options
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.
Read the passage below, then answer Q13–Q14
Based on the sample data given answer the subquestions.
Q13MCQ1 Mark·Choose one option
Asked 2 times Key ↓
Determine the percentage change in total revenue when income increases from Rs 15000 to Rs 25000.
1. A41.2%
2. B42%
3. C42.5%
4. D41.8%
Q14MCQ1 Mark·Choose one option
Key ↓
What is the type of goods based on the given table?
1. ANormal Goods
2. BInferior Goods
3. CLuxury Goods
4. DNone of these
Read the passage below, then answer Q15–Q17
Based on following data, answer the given subquestions:
Q15MCQ2 Marks·Choose one option
Asked 4 times Key ↓
The total revenue of the firm is:
1. A67125
2. B66895
3. C65285
4. D67565
Q16MCQ2 Marks·Choose one option
Asked 2 times Key ↓
In terms of sales trend, which product has a continuously increasing trend?
1. AGadget X
2. BWidget A
3. CWidget C
4. DGadget Q
Q17MCQ1 Mark·Choose one option
Asked 3 times Key ↓
What percentage of total revenue do Widgets contribute?
1. A30.1%
2. B42.4%
3. C25.6%
4. D35.5%
Read the passage below, then answer Q18–Q21
Based on the data in the table, Calculate the missing values X1, X2, X3 & X4 and answer the given subquestions.
Q18NAT1 Mark·Write the number
Asked 2 times Key ↓
X1:
Your answer:
Q19NAT1 Mark·Write the number
Asked 2 times Key ↓
X2:
Your answer:
Q20NAT1.5 Marks·Write the number
Asked 3 times Key ↓
X3 (in%):
Your answer:
Q21NAT1.5 Marks·Write the number
Asked 4 times Key ↓
X4 (in%):
Your answer:
Read the passage below, then answer Q22–Q24
Match the following
Based on the above data, answer the given subquestions.
Q22MCQ1 Mark·Choose one option
Asked 3 times Key ↓
A form created by HR that outlines the budgetary details, skills and capabilities required etc.
1. AAppraisal
2. BIndent
3. CEmployee referral
4. DNone of these
Q23MCQ1 Mark·Choose one option
Key ↓
Organization source talent by asking their existing employees to recommend candidates from their existing networks.
1. AAppraisal
2. BIndent
3. CEmployee referral
4. DNone of these
Q24MCQ1 Mark·Choose one option
Key ↓
The process of evaluating an employee’s current and/or past performance
1. AAppraisal
2. BIndent
3. CEmployee referral
4. DNone of these

Official Key

Master Answer Key & Explanations

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

Reveal Key

Q1A

Q2C

Q3D

Q4A

Q5A

Q6C

Q7B

Q8D

Q9D

Q10B

Q11A, B

Q12A, B

Q13C

Q14A

Q15A

Q16C

Q17A

Q181

Q19180

Q2083 to 83.5

Q2165 to 65.75

Q22B

Q23C

Q24A

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