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?

=IF(A1<500,"Fair",IF(AND(A1>500,A1<1500),"Good","Excellent"))







Description:

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!

http://coachexcel.webs.com/

Tags:

MS-Excel

Discussion

CoachExcel .

Hi,

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

1209 days 7 hours 28 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
CoachExcel

1209 days 12 hours 25 minutes ago

bd

jj

1209 days 15 hours 54 minutes ago

CoachExcel .
Microsoft Excel Solutions and Training
User
14 Followers

Your Facebook Friends on WizIQ

More Tests By Author

Test your Excel Knowledge UPDATED !
10 Questions | 5795 Attempts

Test on Excel 2007 Basics
10 Questions | 30773 Attempts