Excel Test Introduction

In our modern age, most jobs are performed in a technological environment. Clerical, administrative, and any other types of jobs that require gathering and managing information often prescribe intensive use of Microsoft Excel (and Microsoft Word as well) at a relatively basic level. When candidates apply for these types of jobs, employers usually require them to complete an Excel test. This test is designed to assess how proficient candidates are at using Excel and whether the candidates’ skill level matches that required by the positions.


Important Facts on Basic Excel Tests

Many employers want to check that you have the skills needed in Excel before they employ you. A basic level Excel assessment test aims to evaluate your abilities to use this software for everyday office tasks - more common for entry level and administrative roles. It will probably include almost no advanced questions such as functions and macros.

Most of the questions deal with basic formatting, standard tables and basic commands such as saving and printing properties (page breaks and print area definition). You will also be required to know how to define a cell reference, filter and sort data and manage the page layout. However, basic is not necessarily easy. You still have to know the software's fundamentals.

In order to do well, practice and make sure you know how to perform the different commands. Additionally, make sure you are familiar with the terminology: "Formula bar", "name box", "tabs", "quick access toolbar" etc.


What Can You Expect to Be Tested on?

The basic level test should exclude any questions regarding highly advanced topics like Macro Creation or VBA for Excel. However, it may include questions (covered in our preparation package) on intermediate level topics like basic functions and using Excel’s Sort command.

Other basic level topics that may appear on your test include: creating and formatting tables, basic commands such as saving and opening a Workbook, formatting data, creating cell references, and more. You will also need to be familiar with Excel’s interface to some extent and know the names and locations of the different parts and command buttons that comprise it.


Excel Assessment Test Sample Questions

Here are some sample Excel test questions that can appear on an interactive test:

In order to properly practice the following questions, copy and paste the chart below to a clean Excel worksheet (left click, hold and drag to mark the table, right click – choose "copy", in the Excel worksheet choose the first cell on the left (A1), right click – choose paste) Make sure that the cell named A1 is indeed located in cell A1 at your worksheet.

First name (A1) Last name Department Full name Age Annual income
Elisabeth Aragon Finance Elisabeth Aragon 23 $ 55
Molly Freedman Finance   25 $ 60
Marlo Acogny R&D   21 $ 76
Kathleen Allen R&D   26 $ 75
Renee Hobbs Sales   25 $ 60

Basic user sample questions

  1. Change the font style of the first raw to cambria
  2. Right align the text
  3. Rename the worksheet to "TestPrep"

More sample questions at other levels and multiple-choice questions are now available


Prepare with JobTestPrep

The Microsoft Excel program has an almost infinite amount of features and commands. It is almost impossible to master all the various possibilities it offers. That's why studying for the Basic Excel test with random web presentations and tutorials could cause you to waste your time on many topics that are completely irrelevant for the actual test. Ensure that you're preparing with the correct materials and resources with JobTestPrep's preparation packages. Start practicing today and ensure your success. 


Microsoft and other trademarks are the property of their respective trademark holders. None of the trademark holders are affiliated with JobTestPrep or this website.