EXCEL Interview Questions and Answers in Hindi 2023 | For Beginner Level | Part-1

EXCEL Interview Questions and Answers in Hindi - 2023

Hello Friends,

This "Excel Interview" video series has been made for people who want to learn basic Excel and be able to solve the questions asked during the Excel Beginner level interviews.

There will be total 10 Parts where in we will cover minimum 100 questions and answers followed by some Tips and Tricks.

0:00 Use a 'V-LOOKUP' formula to find the 'Sales Amount' for each 'Unique ID' given in the below list
06:30 Use the 'COUNT IF' formula to find the 'number of records' for each state as given in the below table.
12:40 Use the 'SUM IF' formula and calculate the total 'Sales' amount for each 'Sub-Category' as given in the below table.
19:05 Use the 'AVERAGE IF' formula and calculate the average working hours EXCLUDING 'Sunday's.
24:22 Use the 'IF' condition/formula and update the 'Remark' in 2nd column as per the criteria given below.
32:15 Use the 'CONCAT or CONCATENATE' formula and join both the texts(City - State) in below table as given in example
37:30 Use any Date Function or any other formula and calculate the 'Age in Years' as per current date for below employees.
41:45 Use any Text Function or Formula and get the last 10 digits from the given phone number from 'column B'(Phone Number).
45:30 Use any Text Function or Formula and get the 'First Name of the Employee' from 'column A'(Employee Full Name).
51:53 Use any Text Function or Formula and remove the unwanted/extra SPACEs from 'column A'(Employee Full Name)

_______________________


Please save this to your playlist and keep practicing. We wish you all the best on your learning journey.

If you like the video then Subscribe to this channel and support us.

Regards,
#EXCELwaleBhaiyyaa

___________________

Related Searches:
data entry in excel, excel, advance excel, excel interview question, excel interview questions and answers, excel interview trick, questions for excel interview, excel new formula, excel new function, xlookup, dget, unique, filter, sequence, filter in excel, xlookup in excel, dget in excel, unique function in excel, sequence in excel

________________________________________

Interview Questions & Answer for Excel |
Excel interview questions [Hindi] |
Excel Interview Questions and Answers |
Excel Questions Asked in Job Interviews |
How to ACE Excel Interview Questions |
Excel Test For Job Interview |
Top Excel Questions Asked In Interviews |


#ExcelInterviewQuestions #ExcelTutorial