Test your Excel Knowledge

Q1: Why does the SUM function in B7 show zero?

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



How well do you know Excel and Financial Modelling?

Take one of our free online exams and find out! There are 10 challenging questions in each test. 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!





CoachExcel .


Thanks for trying out my test. In fact, this test has some issues with seeing the questions. Therefore, I have posted the same test with corrections titled "Test your Excel Knowledge UPDATED!" which will be available soon. Also you will have one more test on Excel 2007 basics as well.

Once a test is posted in WIZIQ, I have no authoritySee more

1794 days 20 hours 52 minutes ago

CoachExcel .

Dear All,
I am really sorry,

I found out only later that in most of the questions, the picture is over lapping the question so that, you all could not have got the question right.

I will post this test again with those corrections.

Thanks a lot

1795 days 1 hours 49 minutes ago



1795 days 5 hours 18 minutes ago

CoachExcel .
Microsoft Excel Solutions and Training

Your Facebook Friends on WizIQ

More Tests By Author

Test your Excel Knowledge UPDATED !
10 Questions | 12392 Attempts

Test on Excel 2007 Basics
10 Questions | 48792 Attempts