Quizzes Easy / Medium / Advanced

Easy

1. Easy Quizzes from Internet4Classrooms.com

   1. The Standard Toolbar

   2. The Formatting Toolbar

   3. The Drawing Toolbar

   4. Using Menus Part 1

   5. Using Menus Part 2
       

2. Introductory Excel quiz from Jegsworks by Jan Smith. Easy!

3. Excellent easy quiz from Ralph Allen school, Bath, UK

4. An easy introductory quiz from Jegsworks

5. Easy quiz. 15 multiple choice questions from Achievers in Excellence.org.uk

6. Easy test from Sinclair Community College, Ohio

7. Twelve easy/medium questions

8. Short Toolbar button quiz from TechTrain, and another one

Medium

1. Shockwave quiz from Glencoe. Test your knowledge of Excel vocabulary! Two levels.

2. Medium Excel quiz from Prentice-Hall

3. A simple/medium test from Gent Technologies. 10 questions

4. Here's a Medium quiz from Microsoft

5. Enda Tuomey's Quia quiz.

6. Short quizzes from Iowa State University

   • Unit 1 The Application Window Short quiz (5 questions)

   • Unit 2 Formatting 

   • Unit 3 Formatting and Printing (6 Questions)

   • Unit 4 Sorting, Multiple Sheets (5 questions)

7. University of South Dakota Excel quiz

8. Custom Guide.com Excel 97 quizzes - very good

9. Excel Quiz: Formulas. Not automatically graded, but very good practice for Absolute and Relative reference. By Mike Splane.

10. Simple to Medium quizzes from EMC Paradigm-  NOT automatically graded - you have to download the answers.

11. Medium quiz from Maui Community College, Hawaii

12. Medium: good test from Sinclair Community College, Ohio

More Difficult

1. There are 20 excellent quizzes at this site from Glencoe.com. Some are very advanced.

2. A nice quiz from Salford University, UK. Type Excel as your name and Excel as the password.

3. Difficult quiz from Maui Community College, Hawaii

4. Advanced quiz from College of Eastern Utah

Activities

1. Try these Excel Crosswords! from EclipseCrossword.com

• Standard Toolbar Crossword

• Formatting Toolbar Crossword

• General Excel Crossword 

1. Become an Excel Millionaire! 12 questions in this Quia activity. 

2. Learn your Excel buttons! An easy Quia activity.

Tutorials: Online Lessons

Chalksoft Online Campus: Spreadsheets

Fantastic animated Excel lessons online. Be patient while it downloads. Use the toolbar (picture below) to stop or move around.

 

Getting Started With Excel

This is a well-written tutorial on how to get started with Excel by Dr. Sharon Garrison, a finance professor. Although it references an older version of Excel, the basic concepts highlighted in Getting Started provide a useful introduction. (University of Arizona)

Excel Tutorial

An introduction to Excel. Ends with a very basic, multiple choice, online quiz. (University of South Dakota)

Overview of Microsoft Excel

From Techtrain.com, a very clear tutorial with not too many words and with clear graphics. Some quizzes as well.

MS Excel Knowdule

Uses small pop-up windows for lessons so that you can practice on the screen for Excel. Uses silent QuickTime movies as a "show me" feature. (Louisiana State University)

Internet4Classrooms: Microsoft Excel

Nice and clear tutorial.

Learning Microsoft Excel

From Iowa State University. Very clear and some very good questions for students working in pairs.

Canterbury Christ Church University College 

Five *.pdf (Acrobat Reader) tutorial files on Excel (Module 4) (Right-click to download and select "Save Target as..")

• Part 1 Getting started, entering text and numbers, saving and printing
• Part 2 Opening files, entering and copying formulas 
• Part 3 Selecting cells, inserting rows and columns, formatting - alignment, fonts, sizes, numbers 
• Part 4 Moving and copying cells, colours and borders 
• Part 5 Intro to charts

Quik And Dirty Task Guide for Microsoft Excel

For advanced students. Very clear explanation of formulas.

 Florida Gulf Coast University Excel 2000 tutorial

Another Excel tutorial, from Baycon : simple but clear.  

This Excel tutorial is good for teachers, 

One of the better Excel tutorials. 

Yet another Excel tutorial

Reference

• Reference: Buttons and Toolbars in Excel

Links to Other Resources

• Get Going with Microsoft Excel 2000 from KnowWareGlobal.com (Free Manual: 80 pages: Acrobat Reader file: Right-click to download and select "Save Target as.." 550 kb)
    

• Get Going with Microsoft Excel 97 from KnowWareGlobal.com (Free Manual: 60 pages: Acrobat Reader file: Right-click to download and select "Save Target as.." 700 kb)
    

• Download an AutoTest Demo from ElectricPaper. It has the exact format of the ICDL test with about six questions in each module. You can download the entire test (8 Mb -  right-click and select "Save target as") or run the modules over the Internet.) Highly recommended

• Create a spreadsheet - numbers, text and formulae.
• Use the functions of a spreadsheet - totalling and/or averaging figures.
• Open a spreadsheet file, make changes to it, add rows, calculate new values.
• Print and save a spreadsheet.
• Produce charts/graphs from spreadsheet figures to analyse the data.