Start learning 50% faster. Sign in now
The CONCATENATE function in Excel is used to combine (or join) values from multiple columns or cells into one. This function is particularly useful when you want to merge names, addresses, or other data spread across multiple columns into a single cell. For example, you can combine a first name in one column with a last name in another column into a full name in one cell. Option A is incorrect because VLOOKUP is used to search for a value in a table and return a related value from another column, not to combine data. Option C is incorrect because SUMIF is used to sum values that meet a specific condition, not to concatenate data. Option D is incorrect as a pivot table is used for summarizing data, not for combining data from different columns. Option E is incorrect because LEFT is a text function used to extract a specified number of characters from the left side of a string, not to combine columns.
According to the Economic Survey 2023-24, what measures helped reduce core inflation in India to a four-year low in FY24?
If a country’s policy makers were to continuously use expansionary monetary policy in an attempt to hold unemployment below the natural rate the long-...
Expansionary fiscal policy in the classical model will cause aggregate demand to-----potential output?
GDP at market price is given by?
Lorenz Curve is given by:
L(x) = 1/3 (X^3) + 2/3 (x^5). Calculate Gini Coefficient.
What is the dual problem for given linear programming problem?
Z = Max (4x1 + 5x2 + 7x3)
s.t. 3x1 + x2 + 6x3 <= 3
x1 + 2x2 + x...
A country imposes a 10% tariff on imported vehicles but no tariff on imports of machinery or other inputs to the manufacture of vehicles. Suppose that u...
Which of the following is not correct regarding adjusted R2?
...For the following demand curve, Q=10P-2 , calculate the profit made by the monopolist when Marginal cost is Rs.2
Consider the following production function
Q = 20L – 0.2L2 – 20K + 0.2 K2 + 4KL
If 20 units of capital i...