Vsolution Agency Interview Questions and Answers

Q1. What kind of work do you do in your recent company and how many years of experience do you have in this field
Ans. Daily data Extraction from (Tecan Database SAP & Hubspot CRM Portal) and provide various Data or Report when required by Various Departments on daily, weekly and monthly basis. I have 3 years experience in this field.
Answered by Moin Siddiqui
Add your answer
Q2. How many formulas and functions do you know
Ans. 
I know a variety of formulas and functions in Excel, including VLOOKUP, SUMIF, and COUNTIF.
• I am proficient in using basic formulas such as SUM, AVERAGE, MAX, and MIN.

• I am familiar with more advanced formulas such as VLOOKUP, HLOOKUP, INDEX, and MATCH.

• I am also skilled in using functions such as IF, COUNTIF, SUMIF, and CONCATENATE.

• I am constantly learning and expanding my knowledge of Excel formulas and functions.

• Exampl...read more
Answered by AI
Add your answer
Q3. Which type of formulas you use in your company for preparing reports.
Ans. 
We use various formulas like SUM, AVERAGE, COUNT, MAX, MIN, etc. for preparing reports.
• We use SUM formula to add up values in a column or row.

• AVERAGE formula is used to calculate the average of a range of cells.

• COUNT formula is used to count the number of cells that contain data.

• MAX formula is used to find the highest value in a range of cells.

• MIN formula is used to find the lowest value in a range of cells.
Answered by AI
Add your answer

There is some files with huge database
Where i had to solve all the questions they gave me.