Question
In MS Excel, the 'VLOOKUP' function is primarily used
to:Solution
The VLOOKUP (Vertical Lookup) function is used to search for a value in the first column of a table range and return a value in the same row from a specified column. Its syntax is =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]). It is extensively used in finance for tasks like matching data from different lists.
Calculate the cost of work uncertified if total cost incurred to date is Rs. 5,00,000 and cost of work certified is Rs. 3,00,000.
Calculate sales to earn a profit of Rs. 150,000, if fixed cost = Rs. 3,00,000 and P/V ratio is 20%:
A project can be accepted if:
A software company provides license + 2 years of updates and support. How should revenue be recognised?
______ is levied on the import of goods and/or services.
Which of the following is classified as financing cash flow?
What is project financing?
X Ltd. is absorbed by Y Ltd. Purchase consideration = ₹10,00,000. Assets taken over = ₹12,00,000, Liabilities = ₹3,00,000. What is the goodwill or...
According to RBI’s prudential norms, what is the general provisioning requirement for substandard assets (ignoring ECGC guarantee cover and securities...
Under the Expected Credit Loss (ECL) model, how are trade receivables without a significant financing component measured for impairment?
