Signicent Information Solutions 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

Q1. Give your introduction
Ans. 
I am a highly motivated and detail-oriented Research Analyst with a strong background in data analysis and market research.
• Experienced in conducting quantitative and qualitative research

• Proficient in data collection, analysis, and interpretation

• Skilled in using statistical software such as SPSS and Excel

• Strong communication and presentation skills

• Ability to work independently and as part of a team
Answered by AI
Add your answer
Q2. Why u want to join
Ans. 
I am passionate about conducting in-depth research and analysis to uncover valuable insights and contribute to informed decision-making.
• I have a strong background in data analysis and research methodologies.

• I enjoy the challenge of solving complex problems and uncovering trends through data.

• I am excited about the opportunity to work with a team of experts in the field and contribute to impactful projects.
Answered by AI
Add your answer

Q1. What are corporate actions?
Ans. 
Corporate actions are events initiated by a public company that can affect its stock price or ownership structure.
• Corporate actions include dividends, stock splits, mergers, acquisitions, spin-offs, and rights issues.

• These actions can impact shareholders by changing the value of their investments or the number of shares they own.

• Investors need to stay informed about corporate actions to make informed decisions about th
Answered by AI
Add your answer
Q2. What is capital repayment?
Ans. 
Capital repayment refers to the process of paying back the original amount borrowed in a loan or investment.
• Capital repayment is the return of the initial amount borrowed or invested.

• It does not include any interest or additional fees.

• Common examples include paying off a mortgage or returning the principal amount of a bond.

• Capital repayment reduces the outstanding balance of a loan or investment.
Answered by AI
Add your answer

Need to give aptitude test

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

Basic aptitude questions including work time, relationship and cost problems.

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

Topic answer on different topics

Q1. About yourself in details
Add your answer

Maths logic and verbal tes

Q1. What is debt and equity
Ans. 
Debt and equity are two main sources of financing for companies. Debt involves borrowing money that must be repaid with interest, while equity involves selling ownership stakes in the company.
• Debt is a form of financing where a company borrows money from lenders and agrees to repay the principal amount plus interest over a specified period of time.

• Equity is a form of financing where a company sells ownership stakes (sh...read more
Answered by AI
Add your answer