Excel Interview Questions & Answers ☑️

Excel Interview Questions & Answers

Prepare for your Excel Interview with this in-depth Excel
tutorial covering Most asked questions in Excel Interviews about Excel
Formulas, Excel Charts and Excel Tricks.

Excel Interview can be very tricky and you need to prepare
for your interview in details and this video will clearly explain the most
asked questions in Excel Interview with Answers!

To help you How to prepare for an Excel assessment test for
job application, I have covered

20 Most Asked Excel interview Questions

10 Most asked Excel Interview Tricks

10 Most Asked Excel interview Charts Graphs

*** Download Practice File Link ***

http://www.myelesson.org/downloads

Calculate Age in Excel ☑️

Calculate Age in Excel ☑️

https://youtu.be/L7jA3E9wmJU



Calculate Age in Excel using the Datedif Formula. You can find age of a person in excel i 2 ways

1 - Age of person as of today

2 - Age of person on a specific date



To find the age in excel the best way is to write the date of birth in a cell and the current date in another cell then use the Datedif Formula to calculate the DOB in Excel



Datedif Formula calculates the difference between 2 date in 6 variations.

“”d”” Days between the two dates.

“”m”” Months between the two dates.

“”y”” Years between the two dates.

“”yd”” Days between the dates, as if the dates were in the same year.

“”ym”” Months between the dates, as if the dates were in the same year.

“”md”” Days between the two dates, as if the dates were in the same month and year.

Datedif Formula calculates the differnce between 2 date in 6 variations.

“”d”” Days between the two dates.

“”m”” Months between the two dates.

“”y”” Years between the two dates.

“”yd”” Days between the dates, as if the dates were in the same year.

“”ym”” Months between the dates, as if the dates were in the same year.

“”md”” Days between the two dates, as if the dates were in the same month and year.

How To Play Video in Excel ☑️

Now you can play Videos and YouTube videos in Excel without
any coding! Now you can embed YouTube videos in Excel and you can play videos
from your computer in Excel. Excel can play videos using the Windows player and
Excel can play online video using the YouTube player in Excel.

You can watch videos in Excel 2 ways

A – Watch videos from your computer in Excel

B – Watch videos from YouTube in Excel

A - The process to watch videos in Excel is

1 – Go to developer Tab

2 – Go to Insert – click on More

3 – Choose Windows Media Player

4 – Right Click to open its Properties

5 – Click on the Custom section and choose the file you want
to play from your computer

B - The process to watch YouTube videos in Excel is

1 – Go to developer Tab

2 – Go to Insert – click on More

3 – Choose Shockwave Flash player

4 – Right Click to open its Properties

5 – Paste the YouTube video link in the Movie section

*** remember to change the YouTube video link like I have
shown in the video****

Original YouTube URL https://www.youtube.com/watch?v=0-DqY2rNFZM

Changed URL should be  https://www.youtube.com/v/0-DqY2rNFZM

Calculate Overtime in Excel Hindi

Learn How to calculate overtime in Excel in 3 minutes ! Many
times need to find out extra time that a worker has spent at work and its
actually very easy to find out the Employee Overtime in Excel. To calculate the
Overtime in ecel I have used 3 things

1- Sum Formula

2-  Minus Function

3 - Time Format

  It’s a very easy way to find the overtime of
any worker in your office.

==== Addition Video =====

Make Attendance and Salary Sheet in Excel

https://www.youtube.com/watch?v=5I5Uyql4kLQ

Make Marksheet in Excel ☑️

Make Attendance and Salary Sheet in Excel

Make Attendance and Salary Sheet in Excel

https://youtu.be/5I5Uyql4kLQ

Add Subtract Divide Multiply in Excel

Create Macro In Excel ☑️

Lookup Picture in Excel ☑️

Convert Numbers to Text In Excel Hindi

Check Telangana SSC 10th Class Results - July 6th

Make Salary Slip in Excel

Make Stock Inventory Report in Excel ☑️

Maintain Your Stock In Excel

 Stock report in Excel can help you track your incoming items and your outgoing items. You can download this Stock Inventory Report from http://www.myelesson.org/downloads 

This Stock Register in Excel will maintain your Stock purchase and Stock Sales and will calculate your remaining stock also.

This Excel sheet is similar to a sale purchase register that is maintained in shops or offices.

Make GST Bill in Excel Hindi

0 GSt Tax Item List ☑️

GST Tax Rate of Everything