Microsoft Excel Essential Skills Test

Whether you've landed a job interview for a role that requires fundamental Microsoft Excel skills or you're looking to solve a real-world problem, take the How-To Geek Beginner Excel Test to double-check that you know the nuts and bolts of the popular spreadsheet software.

This is the first of a three-part series. The second (intermediate) and third (advanced) will be available soon.

Download a free copy of the How-To Geek Beginner Excel Test workbook. After you click the link, you'll find the download button in the top-right corner of your screen. You can download the solutions and a sample file via the links at the bottom of this article.

Beginner Tasks

The following 15 tasks cover these areas: renaming worksheets, using Excel tables, using straightforward functions, inputting and formatting data, applying conditional formatting, finding and replacing values, and inserting and modifying charts.

Open the downloaded workbook, and complete the following tasks:

Download a free copy of the How-To Geek Beginner Excel Test Solutions PDF and a sample Excel file with all the tasks completed. After you open these links, click the download button in the top-right corner of the window. The solutions shown may not be the only way to solve the problems.