# Test your Excel Knowledge UPDATED !

Why does the SUM function in B7 show zero?

Why could the formulas in C3 and C4 cause #VALUE! errors?

Why doesn&apos;t the SUM formula in E10 show an answer of \$30,000?

Cell B10 is being edited. B8 contains the formula =SUBTOTAL(9,B4:B7). What number will appear in B10 once the user presses Enter?

What does the word &quot;Calculate&quot; indicate when displayed in the status bar?

What&apos;s wrong with the function in B7 below?

I have a spreadsheet with many rows and columns of data as shown below. Yet when I print the entire sheet, only the highlighted range is printed. Why?

The range name &quot;EmployeeLookupTbl&quot; has been correctly defined to refer to the shaded area. What needs to be fixed in B5 and B6 so the functions show Pierre Francois&apos; information rather than Graeme Smith&apos;s.

The following formula should show &quot;Fair&quot;, &quot;Good&quot; or &quot;Excellent&quot; depending on the value of A1 but there is an error in the logic. What value produces an incorrect result?

=IF(A1&lt;500,&quot;Fair&quot;,IF(AND(A1&gt;500,A1&lt;1500),&quot;Good&quot;,&quot;Excellent&quot;))

Each green cell contains exactly the same formula (ie =CellAbove ). How come each one displays a different result?

Description:

How well do you know Excel ?

These questions appeared in a previous test "Test your Excel Knowledge". As some questions were not visible, I have recreated this test.

There are 10 challenging questions . For your own benefit, try to complete the exam 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 anyway, and you might learn something!

NOTE: This was developed using Excel 2003. Except for certain menu commands explained in the answer, you should be able to do the test in Excel 2007.

Tags:

Want to learn?

or fill this simple form
Name:
Country:
Contact no.:

Area code Number
Subjects you are interested in:
Word verification: (Enter the text as shown in image)

CoachExcel .
Microsoft Excel Solutions and Training
12 Followers

### More Tests By Author

Test on Excel 2007 Basics
10 Questions | 18149 Attempts