Collegedunia Data 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

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