Prove Your Real-World Microsoft Excel Skills With the How-To Geek Test (Advanced)

Whether you've recently taken a Microsoft Excel course or you want to check that you're up-to-date with the program's latest capabilities, take the How-To Geek Advanced Excel Test and see how you fare!

This is the third of a three-part series. The first is the beginner skills test , and the second is the intermediate skills test .

Download a free copy of the How-To Geek Advanced 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.

Advanced Tasks

The following 16 tasks cover these areas: importing data from an online source, using PowerQuery Editor to manipulate data, creating advanced conditional formatting rules, using advanced functions, inserting and using checkboxes, naming ranges, and implementing and using data validation rules. The instructions combine beginner-level, intermediate-level, and advanced-level tasks.

You must have an internet connection to complete these tasks.

Open the downloaded workbook, and with cell A1 in the worksheet named Start_Here selected, complete the following tasks:

Download a free copy of the How-To Geek Advanced 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.