Re: $$Excel-Macros$$ ExcelTest

2012-02-02 Thread Vijayendra Rao
Thanks... 2012/2/3 David Grugeon > Sorry. My mistake. I must have changed the cell accidentally it should > be =ROUNDUP(C34/2,0) similar to the ones below > > On 3 February 2012 13:57, Vijayendra Rao wrote: > >> >> >> Thanks David for correct answers. I understand everything except 4th >> que

Re: $$Excel-Macros$$ ExcelTest

2012-02-02 Thread David Grugeon
Sorry. My mistake. I must have changed the cell accidentally it should be =ROUNDUP(C34/2,0) similar to the ones below On 3 February 2012 13:57, Vijayendra Rao wrote: > > > Thanks David for correct answers. I understand everything except 4th > questions 1 row (row number 34), you have linked D5

Re: $$Excel-Macros$$ ExcelTest

2012-02-02 Thread Vijayendra Rao
Thanks David for correct answers. I understand everything except 4th questions 1 row (row number 34), you have linked D50. Regards, Vijayendra 2012/2/3 David Grugeon > Hi Vijayendra > > Regarding your answers > > 1. Right answer to the wrong question. The minimum negative value is > -300 that

Re: $$Excel-Macros$$ ExcelTest

2012-02-02 Thread David Grugeon
Hi Vijayendra Regarding your answers 1. Right answer to the wrong question. The minimum negative value is -300 that is less than -1. I think the question should have been the maximum negative value which you answered correctly. 2. Your answer is fine. I had a different approach 3. You are

Re: $$Excel-Macros$$ ExcelTest

2012-02-01 Thread Vijayendra Rao
Hi Noorain, I have able to solve only 1st, 2nd and 5th questions. Regards, Vijayendra 2012/2/2 David Grugeon > Hi Noorain and Congratulations on your award. > > For Q1 it would be more interesting to ask for the maximum negative value. > Otherwise it looks like a catch question. > > Regards >

Re: $$Excel-Macros$$ ExcelTest

2012-02-01 Thread David Grugeon
Hi Noorain and Congratulations on your award. For Q1 it would be more interesting to ask for the maximum negative value. Otherwise it looks like a catch question. Regards David Grugeon On 31 January 2012 12:28, NOORAIN ANSARI wrote: > Dear Group, > > Please find attached Excel Test to analyze

Re: $$Excel-Macros$$ ExcelTest

2012-01-31 Thread ITP Abdulgani Shaikh
Dear Noorain, Please provide ansers also. Regards On Tue, Jan 31, 2012 at 7:58 AM, NOORAIN ANSARI wrote: > Dear Group, > > Please find attached Excel Test to analyze you excel Skills. > > -- > Thanks & regards, > Noorain Ansari > *http://excelmacroworld.blogspot.com/*