Booklet

author

John Michaloudis

Office Productivity

TOP 5 EXCEL INTERVIEW QUESTIONS

TOP 5 EXCEL INTERVIEW QUESTIONS

To land your dream job!

#1

VLOOKUP Function

• What are the arguments of a VLOOKUP function?

• What are the limitations of this function?

• What are the alternate functions that can be used to overcome the limitations?

#2

All About Freeze Panes

• How to freeze top row in Excel?

• How to freeze multiple rows in Excel?

#3

Remove Duplicates

• How to get a unique list of customers from sales data?

• How to remove duplicate values from a column?

#4

Excel Tables

• How to convert a range of data into Excel Tables?

• What are the benefits of using an Excel Table?

#5

Excel Pivot Tables

• How do you insert a Pivot Table?

• How can you Group data in a Pivot Table?

• What are Slicers?

More booklets by John Michaloudis

More Office Productivity booklets

Your recently viewed booklets

  • booklet-slide-images
  • booklet-slide-images
  • booklet-slide-images
  • booklet-slide-images
  • booklet-slide-images
  • booklet-slide-images
  • booklet-slide-images
  • booklet-slide-images
  • booklet-slide-images
  • booklet-slide-images
See all booklets