Hello everyone!! Welcome back to the TAX DESTINATION blog.Thanks for your continuous support & tremendous response to our blogs. Check out the Previous series if you haven’t read the same where we have given questions that can be asked in Accounts & Finance Profile
CA Job Profile according to CA Final subjects into different profiles:
FR: Controllership, IND AS, Finance and Accounts
SFM: Valuation, Private Equity, IB Analyst etc.
Audit: Statutory, Internal Audit
Law: Companies Act and Other Act Compliances
SCMPE: Cost Optimisation, Budgeting, Forecasting, FP&A
Elective: Correlate with your expertise
DT: Direct tax and IT, Consultancy
IDT: GST, Custom, litigation.
In this series, we would like to give questions that can be asked in Accounts & Finance Role
Questions that can be asked in Accounts Profile
Basic Questions:
Pivot Table is an interactive way to quickly summarize large amounts of data. It is used to summarize, sort, reorganise, and group. It allows us to extract the significance from a large, detailed data set.
VLOOKUP: It is a function that makes Excel search for a certain value in a column, to return a value from a different column in the same row.
HLOOKUP: Stands for Horizontal Lookup. It is a function that makes Excel search for a certain value in a row, in order to return a value from a different row in the same column.
