Uvi Health Researcher Interview Questions and Answers

Q1. How to remove duplicates in excel
Ans. 
To remove duplicates in Excel, you can use the Remove Duplicates feature under the Data tab.
• Select the range of cells that you want to check for duplicates

• Go to the Data tab and click on Remove Duplicates

• Choose the columns that you want to check for duplicates and click OK
Answered by AI
Add your answer
Q2. How to use vlookup across sheets
Ans. 
VLOOKUP can be used across sheets in Excel by referencing the sheet name in the table_array argument.
• Ensure both sheets are in the same workbook

• Reference the sheet name followed by an exclamation mark before the range in the table_array argument

• For example, =VLOOKUP(A2, Sheet2!A1:B10, 2, FALSE) will search for the value in cell A2 in Sheet2
Answered by AI
Add your answer

Q1. Introduce Yourself
Add your answer

Basic Excel Formulas and Internet awareness

A research case study assignment on K-12 sector of education industry was sent via mail with detailed instructions to complete it within 4 days and send it back. the assignment consisted of 30 company domains (website link), we needed to go through the websites, understand their business model, and identify whether they belong to K-12 segment or not. For those which we identified to be part of K-12 sector, we needed to describe in short, why they are considered as so, their offerings, investor details (if any), revenue and financials etc.

Q1. Was related to the submitted assignment in round 1 and some other related discussion regarding the role.
Add your answer

Q1. It was a psychological round taken by the VP of the company and team I joined in as he tried to understand me as a person, my views about the company, my career ambitions, education background, interests a...read more
Add your answer
Q2. Tell me something about yourself.
Ans. 
I am a dedicated and curious researcher with a passion for uncovering new knowledge.
• I have a strong background in conducting research and analyzing data.

• I am skilled in using various research methodologies and tools.

• I have published several research papers in reputable journals.

• I am experienced in collaborating with interdisciplinary teams.

• I am constantly seeking opportunities to expand my knowledge and skills.
Answered by AI
Add your answer
Q3. What Tracxn is and does as a company?
Ans. 
Tracxn is a research platform that provides insights and data on startups and private companies.
• Tracxn offers a comprehensive database of startups and private companies across various industries.

• It provides detailed profiles, funding information, and news updates on these companies.

• Tracxn's research platform helps investors, entrepreneurs, and professionals make informed decisions.

• The company also offers sector-specifi...read more
Answered by AI
Add your answer
Q4. The companies I have identified to be under K-12 sector, what was common between all of them? (question from the assignment submitted)
Add your answer

Q1. Self introduction
Add your answer
Q2. Asked questions related to excel
Add your answer

Q1. Asked questions related to my Resume
Add your answer
Q2. Asked Excel functions.
Add your answer

Advanced Excel and Data Research

Q1. About Basic interview questions.
Add your answer