Nations Valuation Services Research Analyst Interview Questions and Answers

Q1. Basic questions over excel function
Add your answer
Q2. Dashboard preparation with formulas
Add your answer
Q3. Vlookup and hlookup
Add your answer
Q4. Sum sumif tex formula
Ans. 
SUMIF is a function in Excel used to sum values based on a specific condition.
• SUMIF formula syntax: =SUMIF(range, criteria, [sum_range])

• Example: =SUMIF(A1:A10, ">10", B1:B10) will sum values in B1:B10 where corresponding value in A1:A10 is greater than 10

• Criteria can be a number, expression, or text

• Sum_range is optional and if omitted, the range is used for both sum and criteria
Answered by AI
Add your answer
Q5. Countif countifs pivot advance excel formulas
Add your answer

Easy mcq based test, maths, english, quants

Q1. About yourself, interest, hobbies
Add your answer
Q2. Finance related questions, stock market, fii, dii, guesstimates
Add your answer

Q1. Not that technical, but more of trying to know my goals, and if i fit in
Add your answer

Need to give aptitude test

Q1. Tell me about your self
Add your answer
Q2. Questions about process
Add your answer

3 questions based on summary,English grammar test and identifying what is the financial risk

Q1. Job role questions on research analyst
Add your answer
Q2. What is money laundering
Ans. 
Money laundering is the illegal process of making large amounts of money generated by a criminal activity, such as drug trafficking or terrorist funding, appear to have come from a legitimate source.
• Money laundering involves disguising the origins of illegally obtained money by passing it through a complex sequence of banking transfers or commercial transactions.

• The purpose of money laundering is to make the money appe...read more
Answered by AI
Add your answer
Q3. Who gives the annual report of the companies
Ans. 
The annual report of companies is typically prepared by the management team and approved by the board of directors.
• The management team of a company is responsible for preparing the annual report.

• The annual report is then approved by the board of directors before being released to shareholders and the public.

• The annual report includes financial statements, management discussion and analysis, and other relevant informati...read more
Answered by AI
Add your answer
Q4. Tell me about yourself,academics and family
Add your answer

Q1. The company's you track, write reports, update models, new companies under coverage, etc
Add your answer

Verbal, reasoning and others

Q1. What is balance sheet? Examples
Add your answer
Q2. Difference between mutual fund and ETF?
Add your answer

Q1. Are you okay with day or night shift?
Add your answer
Q2. What’s your salary expectations?
Add your answer

Q1. Core finance questions
Add your answer
Q2. How many customers in a Starbuck outlet per day
Ans. 
The number of customers in a Starbucks outlet per day varies depending on various factors.
• The number of customers can vary based on the location of the outlet.

• Peak hours like mornings and evenings tend to have more customers.

• Weekdays may have more customers compared to weekends.

• Special promotions or events can attract more customers.

• The size of the outlet and seating capacity can also impact the number of customers.
Answered by AI
Add your answer

Q1. Are you willing to work for long hpurs
Add your answer
Q2. Tell about the job profile
Add your answer