Excel Interview Questions and Answers

QUant, aptitude, english all in one hour

It was about the road curves and what kind of material we can use for the long durability of road

Knowledge of excel and advance excel

Q1. General questions
Add your answer
Q2. What is your current salary
Add your answer
Q3. What is your expected ctc
Ans. 
My expected CTC is based on my experience, skills, and the market rate for data analysts.
• My expected CTC is in line with industry standards for data analysts.

• I have taken into consideration my years of experience and expertise in data analysis.

• I am open to negotiation based on the overall compensation package offered by the company.
Answered by AI
Add your answer

Q1. First was Hr round, where he asked about myself, my experience, salary expectations, current salary.
Add your answer

Q1. Then the second round was with Arun Sir, who has asked advanced excel formulas, advanced google sheets formulas, SQL basics. And later told that will let you know, but haven't updated yet.
Add your answer
Q2. Dcount function ABS function Excel remove minus sign from integer using a formula.
Ans. 
Dcount function counts the number of unique values in a dataset. ABS function returns the absolute value of a number. To remove minus sign from an integer in Excel, use a formula like =ABS(A1).
• Dcount function counts unique values in a dataset

• ABS function returns absolute value of a number

• To remove minus sign from an integer in Excel, use formula like =ABS(A1)
Answered by AI
Add your answer
Q3. Filters Transfer data from 1 sheet to other Join , inner, outer, self, left right Along with the syntax Colene function in SQL Show top value show values between a date range Sumifs countifs
Ans. 
Answering questions related to data filtering, transferring, joining, and SQL functions for a Data Analyst role.
• To transfer data from one sheet to another, you can use functions like VLOOKUP or INDEX/MATCH in Excel.

• Different types of joins in SQL include INNER JOIN, OUTER JOIN, LEFT JOIN, RIGHT JOIN, and SELF JOIN.

• Syntax for INNER JOIN: SELECT columns FROM table1 INNER JOIN table2 ON table1.column = table2.column;

• Synta...read more
Answered by AI
Add your answer

Dsa round was conducted

Q1. Anything related to past exp
Add your answer