Javatpoint Logo
Javatpoint Logo

Intermediate Excel Test

An Intermediate Excel test is a tool or software that tests the skill of a person in MS-Excel. Usually, this tool is used by the recruiters to check the proficiency of the candidates with Excel. Recruiters use this Intermediate Excel test tool during the recruitment process. The difficulty of the test depends on the position you have applied for.

At the Intermediate level of excel skills, users learn how Excel functions think and how they behave when applying them on cells or copy/paste/drag. In this chapter, we will discuss every detail you needed.

Following topics, we will discuss in this chapter:

Several websites in market/internet that offer mock preparation tests for preparing for this test before appearing in the interview. These tests are becoming very common nowadays as they are efficient and time-saving ways to test someone's skills.

Note: Some companies call the Intermediate Excel Test as "Standard Test" or some other calls it "Normal User".

Why choose Intermediate Excel test?

As we already told you, the Intermediate Excel test is a tool or software used by recruiters to test the candidate's proficiency in MS-Excel. This test tool is currently becoming common and very vastly used because it saves time and provides efficiency.

The difficulty of the test depends on the position you have applied for. The main objective of recruiters to test the candidate's ability to perform basic excel tasks, such as printing, formatting cells, inserting a table, etc. Besides this, they also look for an understanding of relative, mixed, and absolute references.

When it comes to in-depth knowledge of Excel, the recruiters expect advance working knowledge of excel and asks for such Excel functions: SUMIF, VLOOKUP, and COUNTIF, etc.

Levels of Excel test

Typically, the Excel assessment test is divided into three levels. Intermediate Excel test is one of them.

  1. Basic Excel test
  2. Intermediate Excel test
  3. Advance Excel test

Passing scores for these different tests are vary company by company. Each company can decide its passing score for each test.

Intermediate Excel Test

This chapter is completely based on the Intermediate Excel test, but we will brief you about the Basic and Advance Excel test.

Basic Excel Test

Basic Excel Test is a test conducts at a very low level, which does not require in-depth knowledge of Excel. This test conducts to hire candidates who are really good in performing the most common tasks of Excel.

Role: This is for administrative or clerical roles.

Basic Excel text is a test for the position at entry-level or administrative positions jobs.

Tasks at Basic Test level

Following are the basic tasks that may ask in Basic Excel Test:

  • Knowledge of most common mathematics functions like SUM, AVERAGE, COUNT, MIN, and MAX.
  • Creating basic charts in Excel.
  • Formatting of cells - alignment, shading, border formatting, currency formatting, number formatting, text wrapping, etc.
  • Apart from all the above tasks, saving an excel file in more than one format.

Intermediate Excel Test

Intermediate Excel Test is a test conducts at the intermediate level, which does not require medium knowledge of Excel. Basically, these test conducts for job purposes at a higher level. It tests the ability of the candidate with excel who wants to work at a higher level.

Role: Basically, this test is for those roles who requires calculations.

Although the people at the intermediate test level have good knowledge than basic, but they are not Excel experts who know full range of Excel features.

Tasks at Intermediate Test level

Following are the tasks that may be asked in the Intermediate Excel Test:

  • At this level, you have to create more sophisticated formulas (like IF and LOOKUP) than the Basic excel test.
  • Perform more crucial tasks of Excel, such as - customizing charts, data validation, and operations with text strings (like CONCATENATION)
  • Following type of cell formatting requires: conditional formatting, print layouts, text columns, page adjusting.

Advanced Excel Test

The advanced Excel Test is a test conducts at a higher level, which does not require medium knowledge of Excel. This requires deep (in-depth) knowledge of Excel. At this level, the candidate should be the expertise of Excel. Basically, these test conducts for job purposes at a higher level. It tests the ability of the candidate with excel who wants to work at a higher level.

Role: This is for the roles who require to do data analysis.

At this Excel test level, the candidate will be the expert of excel who knows almost every piece of information about Excel. They can be called the expert of Excel.

Tasks at advanced Test level

Following are the tasks that may be asked in the Advanced Excel Test:

  • At this Advanced level of Excel, at least you must have knowledge to create PivotTables and PivotCharts.
  • The candidates must know about setting up a database.
  • Formatting functions, such as locking cells.
  • Advanced Excel tests expect that the candidates may know to use complex versions of IF and CONCATENATE functions.

Formats of Excel test

Usually, the following Excel test format is used by companies:

  1. Multiple-choice questions
  2. Excel Interactive spreadsheet

First, they take the MCQ test of the candidates. The second module provides an in-built Excel interactive spreadsheet for practical implementation to check the practical knowledge of the candidate.

Multiple-choice questions

The first module of the Intermediate Excel test is multiple-choice questions. In this section, questions will be given along with four options. The candidate needs to choose the best answer (correct answer) from the given options.

For Example -

See the below screenshot of how multiple-choice questions are:

Intermediate Excel Test


It can be like as shown in the below screenshot.

Intermediate Excel Test

Excel Interactive Spreadsheet

The second module of the Intermediate Excel test is Excel Interactive Spreadsheet. In this section, an interactive spreadsheet will provide to the candidate to where he/she need to perform excel operations on it.

This section will contain question having some tasks which user need to perform on this interactive spreadsheet. The question might contain single or multiple tasks in a single question. Perform and save each task performed on the spreadsheet and submit it when done.

Where to prepare for Intermediate Excel Test

You have seen many test preparation websites that provide a platform to the users to prepare for such tests. In which, some sites are free to use and some might be paid.

They provide tutorials, video tutorials, tips, and mock tests. Mock tests are taken from the candidate to check how much the user learns. The mock test contains the questions related to Excel prepared from the tutorial. The syllabus for the tutorial is designed by taking concern under the Intermediate Excel Test.

Here are some following website references that prepare for such tests:

Here, we have some examples of how questions come in basic, intermediate, and advanced level questions:

Basic Excel test Level Questions

For Example -

  1. Sort the column "Name" alphabetically (A to Z).
  2. How to calculate the total expense amount for the column "Expense".
  3. Turn on the filter for the table.
  4. Clear all data from the table.
  5. Highlight the row with yellow color containing

Intermediate Excel test Question

For Example -

  1. Use Green color to fill income higher than 35000. (Using conditional formatting)
  2. Under the full name column (field), combine the first and last name. (CONCATENATE Operation)
  3. Which formula is used to remove a specific character?
  4. Which formula is used to replace any specific character or symbol?
  5. Freeze top of the rows

Advanced Excel test Questions

For Example -

  1. Create a Pivot table for the total price per category.
  2. How to prevent others from changing data in Excel?
  3. How to lock the cell?
  4. Put the data validation
  5. Sort the table using multiple fields.

Next TopicHTML MCQ

Youtube For Videos Join Our Youtube Channel: Join Now

Help Others, Please Share

facebook twitter pinterest

Learn Latest Tutorials


Trending Technologies

B.Tech / MCA