Free Excel Exam Questions and Answers

What is the Excel Test 

Microsoft Excel tests are used to assess your Excel skills, beginning form basic Excel functions such as a keyboard shortcut or wrap text to more complex data analysis functions such as filtering data and financial calculations. The level of test you will need to solve depends on the company and position that you're applying for, however in these challenging tests even seemingly straightforward questions can prove to be tricky because of the pressure of a timed exam. 

To make sure you get a high final score and the Excel test isn't what keeps you from landing the job, meticulous practice is the only way to go. Studying with our accurate prep pack, you will have everything you need to reach the level of Excel skills your next job requires.  


Excel Exam Sample Questions

Below are sample excel test questions and answers to give you a sense of what you will face on your actual 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 Exam Practice 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 Exam Practice 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 questions:

Excel Exam Multiple Choice 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

 

Excel Exam Multiple Choice 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.


Prepare for your MS Excel Assessment 

MS Excel is the most widely used data analysis software in today's workplaces, and many employers attribute great importance to it and consider it a threshold requirement. The software allows you to analyze data, carry out calculations, pivot tables, online formulas, Boolean logic, functions, and more.

Our test kits include a selection of MS Excel practice tests and other accurate preparation resources. Each Excel practice test and question takes your Excel skills higher and increases your chances of passing the test and landing the job.  

 

 

 

 

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