Excel Basic

Level 1

Test library / All tests / Excel Basic

This Beginner Level Excel Test evaluates a candidates' ability to use simple features and formulas.

This assessment is designed to evaluate your knowledge and skills in using Microsoft Excel, a critical tool for data analysis, reporting, and problem-solving in various professional settings. The test covers a range of topics, including formulas, functions, data manipulation, charting, and advanced features. It aims to identify the candidates proficiency level, ensuring they have necessary capabilities to effectively utilise Excel in a work environment. 

Designed to access

  • Organising data

  • Creating reports

  • Basic formulas

  • Formatting

Use this test to hire for

  • All candidates that require a basic level of Excel functionality.
  • Duration 10 minutes
  • Languages English
  • Level Beginner / Level 1

Question

You are working on a large Excel file that contains 20 worksheets. Considering the sensitivity, you want to hide the maximum possible sheets while working so that no one else can guess the type of information in other worksheets. What constraints are you likely to encounter while hiding the worksheets?

Select ONE answer

Question

You are working on complex data in an Excel worksheet and therefore, you want to insert comments on various cells to help you understand the work while reviewing and explaining to your supervisor. Which of the following tabs you can use to access the option?

Select ALL that apply

Question

You have a list of product names in column A of a worksheet, and you noticed that some names have unnecessary spaces at the beginning or at the end. You want to clean up these extra spaces to ensure consistency. Which of the following Excel functions should you use for this task?

Select ONE answer

Use skills-based tests to make data-driven hiring decisions

  • Unbiased, skills-based assessments to ensure objective and equitable hiring decisions

  • Comprehensive analytics and insights for making informed, data-backed candidate selections

  • Scales to accommodate your hiring needs, from small teams to large-scale recruitment drives

Try for free Book a demo