www.TestsTestsTests.com

Free Online Microsoft Excel Tests
Excel 2010 Tests Index Page
10 Question Multiple Choice Tests & Quizzes
with Answers and Answer Explanations

1. Excel Keyboard Shortcuts Tests ( 7 Excel 2010 Tests)
2. Getting Started in Excel Tests ( 5 Excel 2010 Tests)
3. Entering Data in Excel Tests ( 4 Excel 2010 Tests)
4. Excel Formulas and Functions Tests ( 4 Excel 2010 Tests)


1. Excel Keyboard Shortcuts Tests (Excel 2010)
* 7 Free Online Tests with Answer Explanations

Easy Excel Shortcuts Test
Easy  Excel Shortcuts Everyone Should Know! Shortcuts make performing tasks that you frequently perform in Excel, quick and easy.  A number of keyboard combinations provide quick access to specific tasks.


Intermediate Excel Shortcuts Test
Shortcuts streamline tasks that you frequently perform in Excel by allowing you to quickly access specific functions. Memorizing a couple of essential shortcut key combinations could save you time and frustration and could even assist you in using different versions of Excel as most shortcut keys have not changed in the last decade! 


Excel Keyboard Shortcuts for Worksheets Test

* Shortcuts for Moving Around Cells
* Shortcuts for Moving to the Beginning and End of Data
* Shortcuts for Selecting Rows and Columns
* Shortcuts for The Go To Dialogue Box
* Shortcuts to Undo and Redo

Part of working smarter and not harder in Excel means becoming a pro at using keyboard shortcuts to move and make selections in the worksheet. Test your Excel skills with the free 10 Question Multiple Choice Excel Quiz with Answers and Answer Explanations.


Excel Keyboard Shortcuts for Cell Contents Test
* Shortcuts to Undo and Redo
* Shortcuts to Cut, Copy, Paste and Edit Cell Contents
* Shortcuts to Insert Comments and Hyperlinks
* Shortcuts to Insert Dates and Times
* Shortcuts to Display Cell Value or Formula

Part of working smarter and not harder in Excel means becoming a pro at using keyboard shortcuts to cut, copy, paste, and format the contents of the cells. Test your Excel skills with the free 10 Question Multiple Choice Excel Quiz with Answers and Answer Explanations.


Shortcuts for Inserting & Deleting Rows, Columns & Cells Excel Test

* Selecting Rows and Columns
* Deleting Rows and Columns
* Inserting Rows and Columns
* Resizing Rows and Columns
Part of working smarter and not harder in Excel means becoming a pro at using keyboard shortcuts to insert and delete rows, columns and cells as well as adjust column width and row height. Test your Excel skills with the free Excel Quiz. Test your Excel skills with the free 10 Question Multiple Choice Excel Quiz with Answers and Answer Explanations.


Excel Keyboard Shortcuts for Formatting Numbers Test
* Shortcuts for Applying Formats
* Shortcuts for General Number & Scientific Number Formats
* Shortcuts for Time and Date Format
* Shortcuts for Percentage Format
* Shortcuts for Currency Format

Part of working smarter and not harder in Excel means becoming a pro at using keyboard shortcuts to format numbers. Test your Excel skills with the free 10 Question Multiple Choice Excel Quiz with Answers and Answer Explanations.

Excel Keyboard Shortcuts for Formulas Test
* Shortcuts for Autosum
* Shortcuts for Copy Formulas Down
* Shortcuts for Insert Functions, Formulas and Arguments
* Shortcuts for Array Formulas
* Shortcuts for Calculate the Worksheet

Part of working smarter and not harder in Excel means becoming a pro at using keyboard shortcuts to to enter formulas. Test your Excel skills with the free 10 Question Multiple Choice Excel Quiz with Answers and Answer Explanations.


BACK TO TOP
of page
 


2. Getting Started in Excel Tests (Excel 2010)
* 4 Free Online Tests with Answer Explanations

Excel Basics Test
* Parts of the Screen
* Columns, Rows, Cells
* Parts of the Worksheet
Starting out in Excel it’s important to identify and understand all what you see on the screen. The Ribbon, Tabs, the Quick Access Toolbar, the Name Box, the Formula Bar, Column and Row Labels, Cells and Cell Addresses and the Worksheet Tabs. Test your Excel skills with the free 10 Question Multiple Choice Excel Quiz with Answers and Answer Explanations.

Using the File Tab Excel Test
* Saving and Opening a Workbook
* Creating a New Workbook
* Recent Places
* Print Preview
An overview of the common tasks that can be completed using the File Tab aka The Backstage View including the list of recent documents, using pushpins to keep documents at the top of the list, print and print preview, and save and save as. Test your Excel skills with the free 10 Question Multiple Choice Excel Quiz with Answers and Answer Explanations.

The Views in Excel Test
* Normal View
* Page Layout View
* Page Break Preview
* Zoom Options

There are different ways to view your worksheet depending on what you want to do. Understanding and using the different views in Excel can make your work much easier. This includes Normal, Page Layout, Page Break views and the Zoom feature.Test your Excel skills with the free 10 Question Multiple Choice Excel Quiz with Answers and Answer Explanations.

Moving Around the Worksheet Excel Test
* Navigating Around a Worksheet
* Selection Methods
* The Go To Function

Excel worksheets can be quite big and contain multiple columns and rows of data. Knowing how to use the mouse, keyboard and Go To features as well as how to select columns, rows and multiple cells makes using Excel much easier and can save you a lot of time. Test your Excel skills with the free 10 Question Multiple Choice Excel Quiz with Answers and Answer Explanations.

The Excel Screen Test
Getting to know the Excel screen like the proverbial ‘back of your hand’ will make every other part of Excel easier.  Knowing the correct names for different areas on the screen will assist you in understanding tutorials and Microsoft Office help answers and is well worth investing time in.

BACK TO TOP of page




3. Entering Data in Excel Tests (Excel 2010)
* 4 Free Online Tests with Answer Explanations

Basic Data Entry and Navigation Excel Test
* Navigating a Sheet
* Entering Text and Numbers
* Editing Text and Numbers
* Deleting Text and Numbers

Nothing is more fundamental to using Excel than knowing how to enter, edit and delete text and numbers in cells. Test your Excel skills with the free 10 Question Multiple Choice Excel Quiz with Answers and Answer Explanations.

Copying and Pasting Excel Test
* Copying and Pasting
* Using the Fill Handle To Copy
* Drag And Drop
* Undo And Redo

In Excel you will frequently copy and paste text and numbers using keyboard shortcuts, the right mouse button, the fill handle and the drag and drop functions. Using the copying and pasting functions in Excel will not only save you time from having to re-enter data repeatedly, it may also ensure more accurate data entry and less frustration. Test your Excel skills with the free 10 Question Multiple Choice Excel Quiz with Answers and Answer Explanations.

Using Autofill Excel Test
* What Is Autofill?
* Autofill Day And Month Series
* Autofill Number Sequences
* Autofill Custom Lists

You type in Monday and Excel will type in the rest of the days. You can do the same with dates and numbers using the fill handle and Auto Fill feature. You can even create your own list. This is a great time saver. Test your Excel skills with the free 10 Question Multiple Choice Excel Quiz with Answers and Answer Explanations.

Formatting Text Excel Test

* Experimenting with Font Options
* Fitting Text to a Cell
* Setting Text Alignment
* Copy Formatting

Formatting is the key. This includes changing the appearance of the data including the font, font color, text alignment, merging cells, wrapping text and using the fit to cell feature. You can copy formatting by using the Format Painter. Test your Excel skills with the free 10 Question Multiple Choice Excel Quiz with Answers and Answer Explanations.


BACK TO TOP
of page
 

4. Excel Formulas and Functions Tests (Excel 2010)
* 5 Free Online Tests with Answer Explanations

Excel Formula Basics Test
* Understanding Cell References
* Adding and Subtracting Values
* Multiply and Divide Values

Powerful and dynamic arithmetic formulas and functions differentiate Excel from simply, for example, using a table in a Word document or a sheet of paper to list number values. A good place to start is with getting to know how cell references work. Experiment with getting Excel to work for you by learning how to use the Add, Subtract, Multiply, Divide, SUM and AutoSum formulas and functions. Test your Excel skills with the free 10 Question Multiple Choice Excel Quiz with Answers and Answer Explanations.


Excel Copying Formulas and using Relative and Absolute Cell References Test
* The Fill Handle
* Copying and Pasting Formulas and Values
* Drag and Drop
* Absolute and Relative References

To get the math correct every time you have to understand Absolute and Relative cell references when creating, copying and moving formulas. Copying formulas using the fill handle saves a lot of time. So does knowing how to change the formula to its actual value. Test your Excel skills with the free 10 Question Multiple Choice Excel Quiz with Answers and Answer Explanations.

Excel Formatting Numbers Basics Test
* General Formatting
* Decimal Places
* Currency and Negative Numbers
* Formatting Dates
* Formatting Fractions

You want numbers to appear correctly. This is done by formatting numbers for currency, percentage, dates, and fractions including decimal places and negative numbers. Test your Excel skills with the free 10 Question Multiple Choice Excel Quiz with Answers and Answer Explanations.

Excel Understanding Functions Test
* How to Find a Function
* How to Insert a Function
* How to Edit a Function
* Commonly Used Functions: Sum and Count

Functions are predefined formulas that are the powerhouse behind Excel. Understanding functions, how Excel organizes functions, and creating functions using the Function dialog box takes Excel beyond basic math. Test your Excel skills with the free 10 Question Multiple Choice Excel Quiz with Answers and Answer Explanations.

BACK TO TOP of page


Excel Training
Excel Training & Excel MOS Exams Explained

How to use Excel - What is Microsoft Excel? What can Microsoft Excel be used for? What are the benefits of using Microsoft Excel to perform the above functions?

Find out what kind of Excel user you are, take our online Quiz.- Being aware of what kind of Excel user you are, what you wish to use the program for, how often you use it and at what level you currently are (for example Novice, Intermediate or Expert), could act as a guide for the type of training you need to pursue.

What Version of Excel are you using? Find out how to find out!