Question 2
Which Excel function would you use to find a value in the first column of a table and return a value from a specified column?
INDEX
MATCH
VLOOKUP
HLOOKUP
Question 2: Which Excel function would you use to find a value in the…
Show answer
Correct answer
VLOOKUP
Question 2 of 22 in the IIT Madras BS Business Data Management (BDM) End Term paper sat on 31 Aug 2025, in the May 2025 term (IIT M FOUNDATION AN EXAM QDF3 31 Aug 2025). It carries 1 mark.
This question was also asked in
More questions from this paper
- What happens to the demand curve when consumer income increases for a normal good?
- Which of the following is primarily used as a surrogate indicator?
- A niche market strategy focuses on:
- For a company facing declining market share, which strategy would be most appropriate?
- ABC Analysis primarily categorizes inventory based on:
- Which is NOT a benefit of implementing an ERP system?
- For analyzing seasonal sales patterns, which approach is most effective?
- In an A/B test for a mobile app redesign, the control group should receive:
- A document outlining job requirements, budget, and skills needed is called:
- When should A/B testing ideally be conducted?
- E-commerce platforms use scarcity nudges by:
- If a company identifies a strong seasonal pattern in sales data, the optimal inventory approach is to:
- Smartphone Sales Analysis (Units in thousands): Based on the above data, answer the given subquestions. Which brand has…
- Smartphone Sales Analysis (Units in thousands): Based on the above data, answer the given subquestions. What is Orange'…
- Calculate the overall Quality percentage for March (in %)
- Which week had the best Performance percentage?
- What is the average Availability assuming 8-hour shifts with 0.5 hours lost time per day? (in %)
- For the given data, which formula correctly calculates total sales for 'Electronics' category sold by 'John'?\ Data Ran…
- E-commerce A/B Test Results:\ Version A (Control): 1000 visitors, 50 purchases, Avg order value Rs.1,200\ Version B (Tr…
- Rank the following candidates based on composite score (higher is better for all factors): | Candidate | Experience (yr…
- DigitalPay earns revenue as follows:\ 2.5% transaction fee on all payments\ 15% annual interest on credit transactions\…