Question 2
Which Excel function can be used to search for a certain value from another table and retrieve a reference value based on the original table data?
SUM
IF
LINEST
VLOOKUP
Question 2: Which Excel function can be used to search for a certain …
Show answer
Correct answer
VLOOKUP
Question 2 of 25 in the IIT Madras BS Business Data Management (BDM) End Term paper sat on 22 Dec 2024, in the September 2024 term (IIT M FOUNDATION DIPLOMA AN EXAM QDF3 22 Dec 2024). It carries 1 mark.
More questions from this paper
- In the context of economic flow, what do firms provide to households in exchange for labour?
- Which of the following is NOT a government source of economic data mentioned in the segment?
- What implication does a bimodal distribution in household transportation expenditure data point to?
- Which of the following factors is most critical in determining the market potential for a new product?
- What does the Days of Sales of Inventory indicate?
- Which of the following scenarios can be best expressed through a Bar chart?
- Which of the following is typically NOT performed when using a pivot table in data analysis ?
- Swyft, a new taxi aggregator platform has developed a new recommendation engine called “TinSage?” and they want to test…
- What is the primary goal of an A/B test?
- How do online payment companies make money?
- A form created by HR that outlines the budgetary details, skills and capabilities required etc. is called
- Consider the following dataset: Composite Score= Sum of all criteria on the same scale\ Rank the above candidates and c…
- PePhone is a FinTech firm that processes payments. Following are sources of revenue for the company – 3.5% of transacti…
- | Products | Sale amount | |---|---| | Product A | 22,000 | | Product B | 18,000 | | Product C | 29,000 | | Product D |…
- | Products | Sale amount | |---|---| | Product A | 22,000 | | Product B | 18,000 | | Product C | 29,000 | | Product D |…
- Company HiringSoft wants to recruit Software Engineers for its new project. The hiring manager was tasked with choosing…
- Company HiringSoft wants to recruit Software Engineers for its new project. The hiring manager was tasked with choosing…
- | Product Name | Prod. ID | Month 1 Sales | Month 2 Sales | Month 3 Sales | Unit Price (\$) | |---|---|---|---|---|---|…
- | Product Name | Prod. ID | Month 1 Sales | Month 2 Sales | Month 3 Sales | Unit Price (\$) | |---|---|---|---|---|---|…
- | Product Name | Prod. ID | Month 1 Sales | Month 2 Sales | Month 3 Sales | Unit Price (\$) | |---|---|---|---|---|---|…
- Based on the data in the table, Calculate the missing values X1, X2, X3 \& X4 Enter the value X1 _
- Based on the data in the table, Calculate the missing values X1, X2, X3 \& X4 Enter the value X2
- Based on the data in the table, Calculate the missing values X1, X2, X3 \& X4 Enter the value X3
- Based on the data in the table, Calculate the missing values X1, X2, X3 \& X4 Enter the value X4