There are 2 Excel Assessment work files included in this free download. Please click on the link below to download the files.

• Consulting Interview Preparation - Advanced Excel VLOOKUP Test.xlsx - XLSX Source File Presented in the video
• Consulting Interview Preparation - Advanced Excel VLOOKUP Test.xlsx.zip - Zip Archive of XLSX Source File Presented in the video

 

[Download PDF EBook] Advanced Excel: Interview & Assessment Test Questions and Answers

Topics Covered in this EBook

• Advanced Excel Formulas and Function Questions
  • VLOOKUP Questions and Answers
  • LOOKUP
  • SUMIF, SUMIFS
  • HLOOKUP, LEFT, FIND, SEARCH, SUBSTITUTE
  • COUNT, COUNTA, COUNTIF, COUNTIFS
• Pivot Table Questions
  • Pivot Table setup and configuration
  • Dynamic ranges in Pivot Tables
  • Data Sorting and grouping in Pivot table
• Excel Keyboard Shortcuts Questions
  • Most frequently used Excel Shortcuts
• Strategies to Successfully Pass Excel Interview & Assessment Test
  • Preparation for the Exam. What do you need to know
  • Preparation for the day of test
  • Tips to manage your time during Assessment Test
  • Tricks for Answering Questions
    • Strategies to answer Multiple Choice Questions
    • Tips and Tricks to answer True/False Questions
    • How to succeed with Multiple Answer Questions
    • Simulator questions: everything you need to know

and much much more

 

Buy