Free Excel Test

Instructions

In the box below, type your email address (Note: We do not sell email addresses to anyone). Make sure you will be able to work undisturbed during the length of the exam. We recommend you allow approximately 30 minutes to take the exam. Before clicking the Begin Test button, make sure the only two programs open on the computer are Excel and this Internet session. You are allowed and encouraged to toggle back and forth between this test and Excel to answer the test questions. All questions are in a multiple choice format. Note that once you click the Finish button, you cannot go back to review the questions or change your answers. After you finish the exam, you will see a summary of the grade you made for each section. You will be prompted to print that page for your records. Please use the buttons provided to navigate within the test, and not the Back button on your browser. Topics in each category include the following:

• Beginning Excel: Print Preview, Working with Dates, General and Custom Formatting, The Format Cells Dialog Box, Subtotals, Sorting, Find and Replace, AutoFilters, Shapes.
  
  
• Intermediate Excel (Using Functions and Writing Formulas): Arithmetic, Text and Comparison Operators, Concatenation, Named Ranges, Data Validation, Functions (Text, Financial, Logical, Math, Date, Statistical, Lookup).
  
  
• Advanced Excel: PivotTables, External Data Sources, Macros, Protection, Conditional Formatting, Graphs and Charts, Views.

Choose the BEST answer from the available choices. Once you finish the test, you will see a report containing feedback on your response to each question. You will also receive a grade in each section (Beginning, Intermediate, and Advanced), and an overall grade and how your grade compares with the thousands of others who have taken the test. Instructions on how to access the completed test will also be emailed to your email address, so please make sure the email address you input is correct. If you have any comments for me about the test, please email me at Jim.Cline@ClineSys.com.