Question

How do you think that knowing excel will benefit you in your future profession? How is Excel used in your future profession? Have you ever been asked about Excel in a job interview? If so what type of questions have you been asked? What would you suggest job candidates be prepared for when it comes to using excel in the workplace?

Answer 1

How Excel benefit in future profession

• Advance excel skills create job opportunities.
• It assist in saving significant time.
• With the help of knowledge of advanced excel one can get better salary.

How excel used in future profession.

• Documents and financial statements are organised by accountants and auditors for submit tax returns
• Administrative assistant responsible for work smoothly .They prepare reports,schedule appointments and organize documents.
•   To take investment decision , all alternatives are compared in excel.

Yes Excel related questions are asked in Interview.

Questions asked

• What are most important functions used in Excel?
• Difference between relative and absolute cell reference?
• Syntax of VLOOKUP function?

Job candidate should have knowledge of these functions in excel

• Pivot table It is tool that is used to summarize large quantity of data.
• Vlookup It is function used to find out things in table.
• Finance functions Candidate should have knowledge of functions like PMT,PV ,FV,IRR
• Basic functions Knowledge of basic mathematics for eg. SUM,AVERAGE,SUMIF,COUNTIF