Re: $$Excel-Macros$$ Interview Questions with Answers (Excel+VBA+Access+SQL Server)
Thanks a lot Asa, to add valuable points from your side. If you have such types of Questions and Answers Kindly share. -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Fri, May 11, 2012 at 11:47 AM, Asa Rossoff wrote: > Thank you Noorain for sharing those. I just started reading through "50 > Excel VBA Oral Questions…" and the Q & As seem good, but not all the > answers are complete and thorough, and some could be misleading. > > ** ** > > For example: > > *"Ques 06. Difference between ActiveX and Form Controls.* > > *Solution: * > > *i) Forms controls can be used on worksheets and chart sheets. Forms > controls can also be placed within embedded charts in Classic Excel (though > not in Excel 2007). ActiveX controls can only be used on worksheets. > ActiveX controls do not work in MacExcel.* > > *ii) The Forms controls aren’t very complicated, and they have been part > of Excel for longer (they were used in Excel 5/95’s dialog sheets) than the > Controls Toolbox (Excel 97), so it stands to reason that they’d be more > seamlessly integrated. Being newer, the ActiveX controls have richer > formatting possibilities. Both can link to cells and ranges in the > worksheet."* > > ** ** > > Especially since the file has "VBA" in the title, I would say the answer > is incorrect or at least incomplete. Form controls can be used on > worksheet and chart sheets (and ancient XLM macro sheets and dialog > sheets). Correct enough. BUT ActiveX controls are used on both Worksheets > and VBA UserForms (with more complete, and more reliable, support on > UserForms). > > ** ** > > *"Ques 07. What is the difference b/w Functions and Subroutines?* > > *Solution: * > > *i) Subroutines never return a value but functions does return values.* > > *ii) A function could not change the values of actual arguments whereas a > subroutine could change them."* > > ** ** > > Re. ii: Well, a function can modify its arguments if they were passed > ByRef (which is default), exactly as a subroutine can. Not that I > recommend it. Use functions as functions and subs as subs :) > > ** ** > > *Ques 13. Which are the 2 macro languages and which do you use ?* > > *Solution: XLM (used in Excel 97 or before) and VBA(used for 2000 and > after). Obviously, VBA is in use these days.* > > ** ** > > Actually, Excel first included XLM macros in version 3 (1990). It was the > only macro language available until version 5 in 1993, when Excel first > included VBA! > > ** ** > > *"Ques 31. Give technical reasons which made Microsoft withdraw its > support for VBA in Mac?* > > *Solution: The reasons which made Microsoft drop its support to VBA are > as follows, Microsoft visual basic relies heavily on machine code which was > written for Power PC architecture. Also it would take another two years for > developing VBA support for its architecture. It also states that Microsoft > will incorporate VBA in the next script of office release for Mac."* > > ** ** > > Sounds true-- but outdated. Office for Mac 2011 includes VBA support > again. > > ** ** > > ** ** > > In any case, the Q & A isn't always exactly "right" -- in my opinion > sometimes omitting essential information -- but still demonstrates a good, > and broad, knowledge of Excel. Many answers are really excellent, but > don't take any one source like this by rote. Your potential employer might > not be impressed with every answer! > > ** ** > > Asa > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *NOORAIN ANSARI > *Sent:* Thursday, May 10, 2012 4:25 AM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Interview Questions with Answers > (Excel+VBA+Access+SQL Server) > > ** ** > > Dear Rajan,Ashish,Asa,SAM,Krishna,Maries and Don Sir, > > Group is waiting for your valuable contribution. > > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > > www.excelmacroworld.blogspot.com > > ** ** > > On Thu, May 10, 2012 at 4:49 PM, NOORAIN ANSARI > wrote: > > Dear Group, > > Please find attached Interview questions and answers for MS Excel+VBA+MS > Access+SQL Server. > > If any one have this type of question and answers, Kindly share with group. > > > > > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > > www.excelmacroworld.blogspot.com > > > > > > ** ** > > -- > FO
Re: $$Excel-Macros$$ Interview Questions with Answers (Excel+VBA+Access+SQL Server)
Thanks so much for sharing these documents Shekhar Sharma On Fri, May 11, 2012 at 11:53 AM, Nitin Updhyay wrote: > Thanks NOORAIN ANSARI & Asa rossoff > > > On Fri, May 11, 2012 at 11:47 AM, Asa Rossoff wrote: > >> Thank you Noorain for sharing those. I just started reading through >> "50 Excel VBA Oral Questions…" and the Q & As seem good, but not all the >> answers are complete and thorough, and some could be misleading. >> >> ** ** >> >> For example: >> >> *"Ques 06. Difference between ActiveX and Form Controls.* >> >> *Solution: * >> >> *i) Forms controls can be used on worksheets and chart sheets. Forms >> controls can also be placed within embedded charts in Classic Excel (though >> not in Excel 2007). ActiveX controls can only be used on worksheets. >> ActiveX controls do not work in MacExcel.* >> >> *ii) The Forms controls aren’t very complicated, and they have been part >> of Excel for longer (they were used in Excel 5/95’s dialog sheets) than the >> Controls Toolbox (Excel 97), so it stands to reason that they’d be more >> seamlessly integrated. Being newer, the ActiveX controls have richer >> formatting possibilities. Both can link to cells and ranges in the >> worksheet."* >> >> ** ** >> >> Especially since the file has "VBA" in the title, I would say the answer >> is incorrect or at least incomplete. Form controls can be used on >> worksheet and chart sheets (and ancient XLM macro sheets and dialog >> sheets). Correct enough. BUT ActiveX controls are used on both Worksheets >> and VBA UserForms (with more complete, and more reliable, support on >> UserForms). >> >> ** ** >> >> *"Ques 07. What is the difference b/w Functions and Subroutines?* >> >> *Solution: * >> >> *i) Subroutines never return a value but functions does return values.* >> >> *ii) A function could not change the values of actual arguments whereas >> a subroutine could change them."* >> >> ** ** >> >> Re. ii: Well, a function can modify its arguments if they were passed >> ByRef (which is default), exactly as a subroutine can. Not that I >> recommend it. Use functions as functions and subs as subs :) >> >> ** ** >> >> *Ques 13. Which are the 2 macro languages and which do you use ?* >> >> *Solution: XLM (used in Excel 97 or before) and VBA(used for 2000 and >> after). Obviously, VBA is in use these days.* >> >> ** ** >> >> Actually, Excel first included XLM macros in version 3 (1990). It was >> the only macro language available until version 5 in 1993, when Excel first >> included VBA! >> >> ** ** >> >> *"Ques 31. Give technical reasons which made Microsoft withdraw its >> support for VBA in Mac?* >> >> *Solution: The reasons which made Microsoft drop its support to VBA are >> as follows, Microsoft visual basic relies heavily on machine code which was >> written for Power PC architecture. Also it would take another two years for >> developing VBA support for its architecture. It also states that Microsoft >> will incorporate VBA in the next script of office release for Mac."* >> >> ** ** >> >> Sounds true-- but outdated. Office for Mac 2011 includes VBA support >> again. >> >> ** ** >> >> ** ** >> >> In any case, the Q & A isn't always exactly "right" -- in my opinion >> sometimes omitting essential information -- but still demonstrates a good, >> and broad, knowledge of Excel. Many answers are really excellent, but >> don't take any one source like this by rote. Your potential employer might >> not be impressed with every answer! >> >> ** ** >> >> Asa >> >> ** ** >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *NOORAIN ANSARI >> *Sent:* Thursday, May 10, 2012 4:25 AM >> *To:* excel-macros@googlegroups.com >> *Subject:* Re: $$Excel-Macros$$ Interview Questions with Answers >> (Excel+VBA+Access+SQL Server) >> >> ** ** >> >> Dear Rajan,Ashish,Asa,SAM,Krishna,Maries and Don Sir, >> >> Group is waiting for your valuable contribution. >> >> -- >> Thanks & regards, >> Noorain Ansari >> www.noorainansari.com >> >> www.excelmacroworld.blogspot.com >> >> ** ** >> >> On Thu, May 10, 2012 at 4:49 PM, NOORAIN ANSARI >> wrote:
Re: $$Excel-Macros$$ Interview Questions with Answers (Excel+VBA+Access+SQL Server)
Thanks NOORAIN ANSARI & Asa rossoff On Fri, May 11, 2012 at 11:47 AM, Asa Rossoff wrote: > Thank you Noorain for sharing those. I just started reading through "50 > Excel VBA Oral Questions…" and the Q & As seem good, but not all the > answers are complete and thorough, and some could be misleading. > > ** ** > > For example: > > *"Ques 06. Difference between ActiveX and Form Controls.* > > *Solution: * > > *i) Forms controls can be used on worksheets and chart sheets. Forms > controls can also be placed within embedded charts in Classic Excel (though > not in Excel 2007). ActiveX controls can only be used on worksheets. > ActiveX controls do not work in MacExcel.* > > *ii) The Forms controls aren’t very complicated, and they have been part > of Excel for longer (they were used in Excel 5/95’s dialog sheets) than the > Controls Toolbox (Excel 97), so it stands to reason that they’d be more > seamlessly integrated. Being newer, the ActiveX controls have richer > formatting possibilities. Both can link to cells and ranges in the > worksheet."* > > ** ** > > Especially since the file has "VBA" in the title, I would say the answer > is incorrect or at least incomplete. Form controls can be used on > worksheet and chart sheets (and ancient XLM macro sheets and dialog > sheets). Correct enough. BUT ActiveX controls are used on both Worksheets > and VBA UserForms (with more complete, and more reliable, support on > UserForms). > > ** ** > > *"Ques 07. What is the difference b/w Functions and Subroutines?* > > *Solution: * > > *i) Subroutines never return a value but functions does return values.* > > *ii) A function could not change the values of actual arguments whereas a > subroutine could change them."* > > ** ** > > Re. ii: Well, a function can modify its arguments if they were passed > ByRef (which is default), exactly as a subroutine can. Not that I > recommend it. Use functions as functions and subs as subs :) > > ** ** > > *Ques 13. Which are the 2 macro languages and which do you use ?* > > *Solution: XLM (used in Excel 97 or before) and VBA(used for 2000 and > after). Obviously, VBA is in use these days.* > > ** ** > > Actually, Excel first included XLM macros in version 3 (1990). It was the > only macro language available until version 5 in 1993, when Excel first > included VBA! > > ** ** > > *"Ques 31. Give technical reasons which made Microsoft withdraw its > support for VBA in Mac?* > > *Solution: The reasons which made Microsoft drop its support to VBA are > as follows, Microsoft visual basic relies heavily on machine code which was > written for Power PC architecture. Also it would take another two years for > developing VBA support for its architecture. It also states that Microsoft > will incorporate VBA in the next script of office release for Mac."* > > ** ** > > Sounds true-- but outdated. Office for Mac 2011 includes VBA support > again. > > ** ** > > ** ** > > In any case, the Q & A isn't always exactly "right" -- in my opinion > sometimes omitting essential information -- but still demonstrates a good, > and broad, knowledge of Excel. Many answers are really excellent, but > don't take any one source like this by rote. Your potential employer might > not be impressed with every answer! > > ** ** > > Asa > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *NOORAIN ANSARI > *Sent:* Thursday, May 10, 2012 4:25 AM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Interview Questions with Answers > (Excel+VBA+Access+SQL Server) > > ** ** > > Dear Rajan,Ashish,Asa,SAM,Krishna,Maries and Don Sir, > > Group is waiting for your valuable contribution. > > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > > www.excelmacroworld.blogspot.com > > ** ** > > On Thu, May 10, 2012 at 4:49 PM, NOORAIN ANSARI > wrote: > > Dear Group, > > Please find attached Interview questions and answers for MS Excel+VBA+MS > Access+SQL Server. > > If any one have this type of question and answers, Kindly share with group. > > > > > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > > www.excelmacroworld.blogspot.com > > > > > > ** ** > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula P
RE: $$Excel-Macros$$ Interview Questions with Answers (Excel+VBA+Access+SQL Server)
Thank you Noorain for sharing those. I just started reading through "50 Excel VBA Oral Questions." and the Q & As seem good, but not all the answers are complete and thorough, and some could be misleading. For example: "Ques 06. Difference between ActiveX and Form Controls. Solution: i) Forms controls can be used on worksheets and chart sheets. Forms controls can also be placed within embedded charts in Classic Excel (though not in Excel 2007). ActiveX controls can only be used on worksheets. ActiveX controls do not work in MacExcel. ii) The Forms controls aren't very complicated, and they have been part of Excel for longer (they were used in Excel 5/95's dialog sheets) than the Controls Toolbox (Excel 97), so it stands to reason that they'd be more seamlessly integrated. Being newer, the ActiveX controls have richer formatting possibilities. Both can link to cells and ranges in the worksheet." Especially since the file has "VBA" in the title, I would say the answer is incorrect or at least incomplete. Form controls can be used on worksheet and chart sheets (and ancient XLM macro sheets and dialog sheets). Correct enough. BUT ActiveX controls are used on both Worksheets and VBA UserForms (with more complete, and more reliable, support on UserForms). "Ques 07. What is the difference b/w Functions and Subroutines? Solution: i) Subroutines never return a value but functions does return values. ii) A function could not change the values of actual arguments whereas a subroutine could change them." Re. ii: Well, a function can modify its arguments if they were passed ByRef (which is default), exactly as a subroutine can. Not that I recommend it. Use functions as functions and subs as subs :) Ques 13. Which are the 2 macro languages and which do you use ? Solution: XLM (used in Excel 97 or before) and VBA(used for 2000 and after). Obviously, VBA is in use these days. Actually, Excel first included XLM macros in version 3 (1990). It was the only macro language available until version 5 in 1993, when Excel first included VBA! "Ques 31. Give technical reasons which made Microsoft withdraw its support for VBA in Mac? Solution: The reasons which made Microsoft drop its support to VBA are as follows, Microsoft visual basic relies heavily on machine code which was written for Power PC architecture. Also it would take another two years for developing VBA support for its architecture. It also states that Microsoft will incorporate VBA in the next script of office release for Mac." Sounds true-- but outdated. Office for Mac 2011 includes VBA support again. In any case, the Q & A isn't always exactly "right" -- in my opinion sometimes omitting essential information -- but still demonstrates a good, and broad, knowledge of Excel. Many answers are really excellent, but don't take any one source like this by rote. Your potential employer might not be impressed with every answer! Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: Thursday, May 10, 2012 4:25 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Interview Questions with Answers (Excel+VBA+Access+SQL Server) Dear Rajan,Ashish,Asa,SAM,Krishna,Maries and Don Sir, Group is waiting for your valuable contribution. -- Thanks & regards, Noorain Ansari www.noorainansari.com <http://www.excelmacroworld.blogspot.com> www.excelmacroworld.blogspot.com On Thu, May 10, 2012 at 4:49 PM, NOORAIN ANSARI wrote: Dear Group, Please find attached Interview questions and answers for MS Excel+VBA+MS Access+SQL Server. If any one have this type of question and answers, Kindly share with group. -- Thanks & regards, Noorain Ansari www.noorainansari.com <http://www.excelmacroworld.blogspot.com> www.excelmacroworld.blogspot.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks & regards, Noorain Ansari www.noorainansari.com <http://www.excelmacroworld.blogspot.com> www.
Re: $$Excel-Macros$$ Interview Questions with Answers (Excel+VBA+Access+SQL Server)
Dear Noorain, really very helpful for all of us. thanks a ton :) Rgds, cs On Thu, May 10, 2012 at 4:49 PM, NOORAIN ANSARI wrote: > Dear Group, > > Please find attached Interview questions and answers for MS Excel+VBA+MS > Access+SQL Server. > > If any one have this type of question and answers, Kindly share with group. > > > > > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > www.excelmacroworld.blogspot.com > > > > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Interview Questions with Answers (Excel+VBA+Access+SQL Server)
Dear Rajan,Ashish,Asa,SAM,Krishna,Maries and Don Sir, Group is waiting for your valuable contribution. -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Thu, May 10, 2012 at 4:49 PM, NOORAIN ANSARI wrote: > Dear Group, > > Please find attached Interview questions and answers for MS Excel+VBA+MS > Access+SQL Server. > > If any one have this type of question and answers, Kindly share with group. > > > > > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > www.excelmacroworld.blogspot.com > > > > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
