Role:
Excel/ Service Desk Analyst Location: Alpharetta, GA
Job Type : Fulltime
Kindly share answer of below questions:
What is Syntax of VLOOKUP?
2. What is the difference between H-lookup and V-lookup formula
3. What is the shortcut to put the filter on data in Microsoft Excel 2013?
4. Can you please explain the nested If Statements?
5. How do draw graphs and what are the different types of Graphs available in Excel?
6. How can you format a cell? What are the options?
7. What is a Macro in Excel and how would you create an Excel Macro
8. When you link to a pivot table cell, a GETPIVOTDATA formula is created. How would you avoid this?
9. How would you enable automatic refresh in Pivot Table upon opening the workbook without using macros?
10. What is the order of operations used when evaluating formulas in Excel?
11. What is the difference between absolute and relative cell references
12. Do PivotTables have any drawbacks?
13. Talk about some of the spreadsheets you've made that you're most proud of ?
14. How can you make space for text in a cell where the text is longer than the cell size?
15. Name few data formats available in Excel and where you would use them
16. How do you add comments to a cell?
Thanks & Regards,
Neeraj Kushwaha
indhrsolution@gmail.com
732-200-1988
