Services

"Get most things right and constantly try to improve."

-- Jack Collis

Test your Excel Knowledge - FREE!

You Might Win Some Free Consulting Time!

... or Just Brag to your Friends on Facebook!

How well do you know Excel? 

Take our free online test and find out!  There are 10 challenging questions in our test (5 per page).  For your own benefit, try to complete the test with Excel (and its online help) closed.

Even if you don't know the answers, have a guess anyway ... we'll tell you all the answers at the end, and you might learn something!

NEW! Post your score on Facebook so all your friends know what an Excel whiz you are!  Challenge them to see if they can beat you!

Looking for more in-depth training?  Visit our other training resources.

Now ... bring on the questions!  (but watch out ... they're not as easy as they look)!

Questions

Q1: Why does the SUM function in B7 show zero?
	Manual calculation is turned on and the cell has not been re-calculated.
	Someone has keyed the number 0 into B7.
	The function contains a circular reference.
	The function is still being edited so hasn't calculated a result yet.

Q2: Why could the formulas in C3 and C4 cause #VALUE! errors?
Note: the formula in C3 has been copied to C4:C6
	B3 is an empty cell.
	B3 contains one or more space characters.
	The formulas have used brackets incorrectly.
	None of the above

Q3: Why doesn't the SUM formula in E10 show an answer of $30,000?
	The database has been filtered so there must be hidden rows containing other income figures.
	The correct formula for this situation is SUMPRODUCT rather than SUM.
	Conditional formatting has been applied to rows 3, 4, and 6 so that these rows are excluded from the SUM calculations.
	Incorrect data validation has been used.

Q4: Cell B10 is being edited. B8 contains the formula =SUBTOTAL(9,B4:B7). What number will appear in B10 once the user presses Enter?
	0 because this will result in a circular reference.
	2000
	8000
	6000

Q5: What does the word "Calculate" indicate when displayed in the status bar?
	Calculation is set to manual and something in the spreadsheet has changed.
	The calculation option has been set to Automatic Except Tables.
	The active cell needs to be re-calculated.
	A calculation on the current sheet is incorrect.