[XLSX Download] Consulting Interview Preparation: Advanced Excel VLOOKUP Test Questions and Answers

Download Files Used in the Video

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

 

Next Steps

[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