Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What is vlookup?How it is prepared?

Answer Posted / anamika nigam

When you want to search a data vertical we use vlookup. We
prepare it in Excel sheet where the data is presented for
comparision or for any detail

Is This Answer Correct ?    8 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

who introduces the single entry format?

1964


1.explain the accounting concepts ? 2.what are the objectives of preparing a trail balance ?

2056


From the following find out a. Profit Volume ratio b. Break even point c. Sales for 40% P/V Ratio d. Margin of safety from the sales Rs 3,00,000 e. Net profit from the sales of Rs 3,00,000 f. Required sales for the new profit of Rs 70,000 g. Required sales for the net profit of Rs 70,,000 after tax, the corporate income tax being 40% h. Additional sales required to convert an increase of Rs 3000 p.a. in the sales manager salary Sale 2,00,000 Variable Overheads 1,50,000 Profit 50000 Fixed overheads 15000 Net profit 35000 Sl No Heads of Account Debit Rs Credit Rs 1 Drawing and Capital 750 15,000 2 Stock as on 01.01.2009 69720 3 Bills Receivable and bills payable 1000 1180 4 Returns 300 320 5 Purchases and Sales 4500 8300 6 Wages 70 7 Discount 30 8 Salaries 200 9 Canara Bank Shares 3000 10 Insurance 120 11 Building 3000 12 Furniture 700 13 Debtors and Creditors 600 1300 14 Cash in Hand 470 15 Overdraft at bank 900

2113


what is Journal Entries?

2140


what is mean by account concept,and how to perpare a full accounting concept journal,ledger,trail balance,and balance sheet how it will prepare in upto fainalaztion.

2105


which Electrical items is Exciseible

2258


Expand-------NBTA

2105


to attend interview for real estate company accounts

2070


What is the Technology used to carry out trades?

4548


Breif notes about accounting standards

3071


2. You are required to prepare a Profit & Loss Account for the year ending 31st December, 2007 and the Balance Sheet on that date. The Trial Balance of XYZ Ltd. for the year ended 31st December 2007 is as follows:- Trial Balance of XYZ Ltd. as on 31st Dec. 2007 Debit Balances Rs. Credit Balances Rs. Materials used 3,50,000 Sales(including 2% Sales tax) 9,18,000 Cost of Labour 1,50,000 Sale of Scrap 100 Stock, finished and work in process on 31st December, 2006 50,000 Rent received 2,000 Wages : Factory Staff 15,000 Discounts 2,750 Directors Remuneration 50,000 Recovered against fire claim re : Stock 5,000 Salaries : Clerical Staff 75,000 Capital : Equity 25,000 Insurances : Workmen’s Compensation 1,500 Preference- 9% 8,000 General, fire etc. 2,000 Creditors 1,56,000 Directors’ Life Insurance 1,500 Provision for Taxation 1,05,000 Maintenance : Buildings 1,000 Profit & Loss Account 13,750 Plant and Machinery 12,500 Rent and Rates of premises and hire of plant 20,000 Heat, Light and Power 15,000 Experimental and Laboratory Expenses 10,000 Canteen Expenses 5,000 Staff Welfare expenses 2,500 Motor Expenses 12,500 Professional Charges 2,800 Postage and Telephone 3,500 Books, Printing and Stationery 11,000 Sundry expenses 10,000 Carriage and Packing on Sales 3,300 Discounts 5,000 Debtors 1,78,000 Freehold Property 50,000 Plant and Machinery 12,500 Fixtures and Fittings – Offices 3,500 Office machinery and Equipment 3,000 Motor Car and Van 6,500 Stock of materials on 31st Dec. 2007 1,20,000 Bank 38,000 Sales Tax Paid 15,000 12,35,600 12,35,600 Depreciation is to be provided at the following rates: Plant and Machinery 10% Fixture and Fittings 05% Office Machinery, etc. 10% Motor Vans and Cars 25% The stock of finished goods and work in progress as on 31st December, 2007 was Rs. 35,000. Provide for preference dividend and ordinary dividend at 10%. The total taxation liability is estimated at Rs.1,50,000 of which Rs. 75,000 relates to the current year. Debtors include Rs. 10,000 deposited as security against government contracts. The Works Manager is paid partly by salary and partly by a commission; he is entitled to a commission of 5% on the amount by which the surplus in the factory cost exceeds 20% of the sales for the period. Charge the commission if any in the Profit and Loss Account.

2232


What Question ask in MARKIT Company?

6977


What is miscellaneous expense and when it is used

2104


Short Answer on ______________House Rent allowance

1850


what is the use of accounting standards

1954