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×

Business Analyst Excel Test

Topics Covered

  • Business Cases
  • Stakeholder Processes
  • Worksheet and Charts
  • Operators
  • MS Excel Functions
  • MS Excel Formulas

Useful for hiring

  • Business Analyst

Start hiring job-fit candidates using this assessment

GET A DEMO

"Our recruitment team loves Interview Mocha especially for their skill assessments, simulators, and friendly support. Since using Interview Mocha, we interview only relevant candidates, and this has reduced our time to hire. Recruitment is no longer an hassle for us."

Christoph, e-Zest GmbH
Question

You are a Business Analyst at BD Bank. You are involved in a software project that is replacing an out-dated, inefficient legacy system (System X) with an efficient, process-driven web-based solution. However, the project team is facing a few challenges.

The project has requested a detailed stakeholder matrix. You have documented the stakeholder matrix in the RACI format. The stakeholder matrix identifies several key stakeholders. 

RACI legend:
Responsible - Those who do the work to achieve the task
Accountable - Signs off various project outputs and ensures thorough completion of each task
Consulted - Required to provide feedback on documents / in workshops
Informed - Kept up to date on progress



Which of the following statements is not correct pertaining to the Business Analyst’s responsibilities as documented in the RACI matrix?

Answer
    • The business analyst will provide input into the development process and support the senior developer
       

    • The business analyst will document the Functional Requirement specification in accordance with the project governance principles
       

    • The business analyst will analyze the documented process and provide feedback to the stakeholders
       

    • The business analyst will send project progress communications to project stakeholders
       

Question

Take a look at the chart given here, the data is very uneven. How do to convert the jagged line into a smoothed line?

Answer
    • Right click on the chart and click on "Smoothen Line"

    • Click on the line, select Format Line, Choose the Fill option, tick the Smoothed Line option.

    • Click on the line, select Format Data Series, Choose the Line and Fill option, tick the Smoothed Line option.

    • Click on the line, Go to the format tab and tick the Smoothed Line Option

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