Services

"Some people see things as they are, and say 'Why?' I dream of things that never were, and say 'Why not?'"

-- George Bernard Shaw

Test your Excel Knowledge - FREE!

You Might Win Some Free Consulting Time!

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!

If you're looking for more in-depth, professional training, visit our training resource.

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?
	The spreadsheet needs re-calculating.
	Automatic re-calculation has been turned off.
	The active cell needs to be re-calculated.
	A calculation on the current sheet is incorrect.