Are you a candidate looking to sharpen your skills? Try our practice tests or view sample interview questions & Get hired by the best. Click Here×

Basic Excel Test for Interview

Topics Covered

  • Find and Select
  • Data Validation
  • Keyboard Shortcuts
  • Chart Formatting
  • If
  • Large
  • And
  • Date value
  • Sum
  •  Rept
  • Concatenate
  •  Aggregate

Useful for hiring

  • Office Administrator
  • Entry Level Graduates
  • Office Secretary
  • Administrative Assistant

Start hiring job-fit candidates using this assessment

GET A DEMO

"We are impressed by the caliber, depth, and breadth of the assessments provided by Interview Mocha. With Interview Mocha's online proctoring & powerful reports, we are able to hire quality candidates overcoming geographical barriers."

Megan Akhras, J'Excelle,Canada,
Co-founder & director
Question

Which of the following result will be displayed in Cell C3 if the function =RANK.EQ(B3,$B$3:$B$14) is used at C3?

Answer
    • 5
       

    • 6
       

    • 7
       

    • Error. Function name should be Rank not Rank.EQ
       

Question

Which of the listed functions will give you the largest sales figure, ignoring hidden rows and error values?

Answer
    • =AGGREGATE(13,1,B3:B14,1)

    • =AGGREGATE(14,7,B3:B14,1)

    • =AGGREGATE(B3:B14,1,14,7)

    • =AGGREGATE(1,B3:B14,14,7)

Good News! You can customize this test as per your requirement

  • Choose and add questions from Interview Mocha question libraries

  • Add your own set of questions

  • Customize test settings like duration, number of questions, passing score, web proctoring and much more

  • Mail us at support@interviewmocha.com to create a custom test

Looking for a tailor-made test, to suit your assessment needs?

Get in touch

Global companies using Mocha assessments

  • altran
  • credit suisse
  • sephora
  • nielsen
  • capgemini
  • akamai

How Mocha assessments are brewed

Speed up your IT recruitment with Interview Mocha

  • 500+ IT skill tests
  • 20+ coding languages
  • 50+ domain knowledge tests
  • 100+ digital 2.0 skill tests
  • Customer focus aptitude tests
  • Enterprise ready features & more...
GET A DEMO

Why hiring managers and recruiters across the globe love Interview Mocha

Take your first step to hire job fit candidates

GET A DEMO