Frequently Asked Questions of MS-Excel and Finance (MBA Freshers)
#pv_diaries Dear all, if you have any comments or additions, or deletions or suggestions for this post, please do feel free to comment and add value. That may help me and many more. ========================================= The most frequently asked MS-Excel related questions to freshers MBAs in the job interviews (HR Round), in the companies like S&P Global: 0. Introduce yourself / tell me something about yourself. 1. Explain VLOOKUP (XLOOKUP is not still very popular) 2. What is a pivot table? 3. What is SQL? 4. What a Macro? In the companies, that are in the trading of chemicals (domestic as well as international): 1. What is e-way bill? Who needs to carry it? At What time? (Domain: GST) 2. Do you know tally? Basic functions related to tally 3. Basic MS-Excel functions, especially related to Finance like NPV, PMT, XIRR etc.? 4. What is Discounted Cash Flow? You may be asked to calculate PV, based on FV. And you may be asked to assume the discounting rate (At that time, you...