Microsoft Excel Test

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled. If loading fails, click here to try again

There are 16 questions to complete in this free Excel test. The test does not have a time limit but it should take no more than 6 minutes to complete.

Summary of Microsoft Excel Test
This quiz includes questions related to formulas, cells, charts, printing, shortcut keys, and functions. Start Congratulations - you have completed Microsoft Excel Test. You scored %%SCORE%% out of %%TOTAL%%. Your performance has been rated as %%RATING%%
Your answers are highlighted below.

Question 1

When you create a formula in Microsoft Excel how should you start the formula?

	%
	+
	=
	–

Question 2

If you were to numerically add two cells together which two formulas could you use?

	=A1 + A2
	=Add (A1+A2)
	=together (A1:A2)
	A1 plus A2
	=SUM(A1:A2)

Question 3

On an excel sheet the active cell is indicated by

	A dark wide boarder
	A dotted border
	A blinking border
	None of above

Question 4

When you are working on a Excel chart sheet and you use F11 as a short cut key, which kind of chart will it generate?

	A default chart
	A 2-dimensional column chart
	A 2-dimensional bar chart
	A 3-dimensional line chart

Question 5

You can print

	A range of cells by range name
	An entire worksheet
	A single worksheet
	All of the above

Question 6

In Microsoft Excel the cell reference from a range of cells that starts in cell B1 and goes over to column G and down to row 10 is?

	B1 - G10
	B1 . G10
	B1 ; G10
	B1 : G10

Question 7

Suppose you have a row and a column on an excel sheet. The intersection of this row and column will be known as:

	data
	a field
	a cell
	an equation

Question 8

In excel which shortcut key would you use so that the cell accepts your typing as its contents?

	Enter
	Ctrl+Enter
	Tab
	Insert

Question 9

In Excel when you want to open the Format Cells dialog box, which shortcut keys can you use?

	Alt + 1
	Ctrl + 1
	Ctrl + Shift + 1
	F1

Question 10

If you want to add a hyperlink to your worksheet which shortcut keys will you use?

	Alt + K
	Ctrl + H
	Ctrl + K
	Ctrl + Shift + K

Question 11

What does the SUMIF function do?

	Adds up cell values based on a condition
	Adds all the numbers in a range of cells
	Returns a subtotal in a list or database
	All of above

Question 12

In an Excel sheet if you have to copy cell formats from one cell to another, which shortcut key will you use?

	Backspace key
	Default font
	Format painter
	Formatting toolbar

Question 13

A value used in a calculation formula that does not change is known as a

	Cell address
	Constant
	Function
	Range

Question 14

When you are dealing with cells in Excel for what purpose would you use the LEN function?

	Compares the content in two cells
	Counts the numbers of characters in a cell
	Deletes extra space in text
	All of above

Question 15

If you want to insert the current date in a cell which shortcut key would you use?

	Ctrl + Shift + :
	Ctrl + ;
	Ctrl + F10
	All of above

Question 16

Suppose you have two cells C1 and C3 in Excel and you want to make the number in cell C1 10% smaller than the number in C3. Which of the following formulas would you use?

	=C3*1.10
	+C3*110
	=C3%10
	=C3*.90

Once you are finished, click the button below. Any items you have not completed will be marked incorrect. Get Results

There are 16 questions to complete.

List

Return Shaded items are complete.

1	2	3	4	5
6	7	8	9	10
11	12	13	14	15
16	End

Return

Microsoft Excel Interview Preparation Tests (Recommended)
Are you going for an interview that requires knowledge of Microsoft Excel?
Want to compare your skills to other Microsoft Excel users?
Why not take one of the following 40 minute timed Microsoft Excel tests for $9.99. They were developed by qualified and highly experienced experts in their field and are used by employers and recruiters to evaluate the job readiness of candidates. At the end of the test you can print out your results and show them to a prospective employer. >>
Microsoft Excel 2000 Test
Microsoft Excel 2003 Test
Microsoft Excel 2007 Test
Microsoft Excel 2010 Test

{ 1 comment }

ALEX NJOROGE October 24, 2011 at 9:54 am: it is a good test

Comments on this entry are closed.

Microsoft Excel Test