Free Excel Practice Test Questions

What is the Excel Test

Microsoft Excel tests measure your ability to perform various operations, from basic functions such as wrap text to more advanced skills like being able to analyze data on an excel spreadsheet. Whether you need to exhibit basic Excel or advanced Excel skills depends on the position you're aiming for, but either way our prep pack has you covered. 

Check out the sample Excel test questions and answers below to see where you stand, and what kind of preparation you need. 

 

Sample Excel Test Questions and Answers

Below are sample excel test questions and answers to give you a sense of what you will face on your test. Once you have finished answering the questions, open the Excel Test Questions and Answers page to see the full answers. 

 

To get started, copy the table below and paste it into a new Excel spreadsheet. Make sure the table is aligned correctly and that the top left cell is pasted in cell A1 on the spreadsheet.

Maker Type Class Full Model Name Year Annual Sales (Mil $)
Missam SLX Business Missam SLX 2014 55
Dubaru Double Van   2015 60
Tia Jet Van   2013 76
ZMV Cruise Compact   2016 75
Fonda Life Compact   2015 60

Excel Practice Test Questions - Basic

  1. Align the text to the right
  2. Insert a new row between Missam and Dubaru. 
  3. Set the page orientation to landscape.

Excel Practice Test Questions - Intermediate

  1. Highlight all cells with yearly sales above 70 mil.$.
  2. In cell D3, write a function that combines the maker and the type (like in cell D2).
  3. Create a PivotTable for annual sales, per year.

Now that you are done working on the spreadsheet, try the following general Excel practice test questions:

General Excel Practice Test Questions - Basic

A. How would you select non-contiguous cells?

  1. Hold Ctrl → left-click on each cell
  2. Hold Shift → left-click on each cell
  3. Right-click on each cell
  4. Hold Alt → left-click on each cell

 

B. Which of the following commands doesn't affect the text font?

  1. Bold
  2. Underline
  3. Borders
  4. Italics

 

C. How should the following formula be written: Multiply Cell A1 by 6, and divide that by 4? 

  1. =A1X6/4
  2. =A1X6%4
  3. =A1*6/4
  4. =A1*6%4

 

General Excel Practice Test Questions - Advanced

 

A. Fill Handle will generate content based on the following:

  1. Mathematical Series
  2. Alignment Pattern
  3. Design Pattern
  4. All of the Above

 

B. The “Save As” command will NOT allow you to… 

  1. Save as a PDF
  2. Save as a template
  3. Save as a Word document
  4. Save at a specific location

 

C. The Conditional Formatting feature is used to: 

  1. Set the default cell format
  2. Format conditional statements
  3. Format cells conditional on the text size
  4. Change the style of cells meeting a condition

 

Done answering the questions? Open the Excel Test Questions and Answers page to see how you did, and access full answers and solving tips.


 

Get Ready for Your Microsoft Excel Test

The ability to analyze data accurately and efficiently is a basic requirement among many of the job market's top employers, and Microsoft Excel is the most common tool used for this. To make sure that you arrive at your Excel test as prepared as possible, look no further than our Microsoft Excel PrepPack™.

With learning and testing modes, Excel test questions designed for basic, intermediate, and advanced levels, as well as full answers and study guides, you will have all the resources you need to ace your Microsoft Excel test. 

 

 


Learn About the 5 Most Common Topics on the MS Excel Test

 


 

Excel Test Tips

Below you will find several tips for acing your Excel test.

  • Practice. The best way to get a high score is going over as many excel questions for practice you can. Practicing allows you to familiarize yourself with the material you will be tested on, thus eliminating the element of surprise. Using preparation materials will expose you to a variety of Excel test questions you will encounter on your upcoming test - a surefire way of passing your MS Excel assessment. 
  • Read the instructions carefully. Excel tests often come with quite a few instructions for each test section, which can be confusing. To make sure that you do everything correctly, it is best to read through each of the instructions prior to answering any of the Excel test questions. Understanding what you are doing during this sort of test is the key to your success.
  • Relax – you’ve got this. If you have practiced properly for your Excel assessment, trust yourself and try not to stress out too much. Use the night before the big test to relax and allow all that information to sink in, and let your newly learned Excel skills shine on test day. 

Our full MS Excel PrepPacks™ include all the practice you need to pass your assessment. With two practice modes (testing and learning), full-length tests with dozens of practice questions, detailed answer explanations and score reports, you’re bound to pass with flying colours.


About the Excel Test Questions 

Many job roles require at least a basic Excel knowledge level, including administrative assistants and other clerical positions. To make sure our preparation matches your Excel skills, there are three levels of Excel tests: basic, intermediate and advanced level. Our preparation packs are designed to cover each of these levels to give you an idea of what to expect during your actual assessment.

Our full Excel PrepPacks™ include two modes (testing and learning) full of sample Excel test questions and answers to stimulate your learning process and bring you to the skill level you desire.


How to Prepare for an Excel Test

It may be cliché, but practice really does make perfect. By practicing for your Excel test, you will be able to become familiar with each of the tasks that you will need to complete on the job. The best and way to prepare for such a test is to find accurate Excel questions for practice that are interactive and allow you to learn-as-you-go.

This is where we come in. Our full Excel PrepPacks™ include two modes – testing and learning. Both modes are highly interactive and give you the ability to explore each of the tasks and commands you are likely to encounter on the actual test. Coupled with sample Excel test questions and answers and study guides, our Excel preparation materials will make sure you pass your exams with confidence.

 

 

 

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