I like the questions. Very good introductory questions on a variety of VBA topics.
For question #8, I suspect the question intended could be better phrased "Which of these is a datatype most specifically for storing decimal integers in a variable?" (several of the datatypes listed store decimal numbers, more than one can store decimal integers precisely, but only one of those is limited to storing integers.) Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of jainayus...@gmail.com Sent: Saturday, November 10, 2012 4:14 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ VBA macro quiz #1 If you have trouble viewing or submitting this form, you can fill it out online: https://docs.google.com/spreadsheet/viewform?fromEmail=true <https://docs.google.com/spreadsheet/viewform?fromEmail=true&formkey=dHRESnJ EemJNVmQ3Ym9SbnNvWnZDUEE6MQ> &formkey=dHRESnJEemJNVmQ3Ym9SbnNvWnZDUEE6MQ VBA macro quiz #1 This quiz is sponsored by discussexcel.com. Ayush Jain Group Manager Your name * Email Address * 1. Which of these is used at module level to force declaration of all variables mandatory ? * . ( ) Option Compare . ( ) Option Variable . ( ) Option Explicit . ( ) Option Base 2. Which of these keyword is used to declare variables ? * . ( ) Declare . ( ) Dim . ( ) Create . ( ) Make 3. Which of these datatype is used in the variable declaration to store text data ? * . ( ) String . ( ) Text . ( ) Char . ( ) Long 4. Which of these is correct declaration of macro ? * . ( ) Sub Welcome[] . ( ) Sub Welcome{} . ( ) Sub Welcome() . ( ) Sub Welcome 5. Which of these command is to display message in a dialog box ? * . ( ) ShowMsg . ( ) DialogBox . ( ) Message . ( ) Msgbox 6. Which of these is not a loop in VBA ? * . ( ) Do while . ( ) IF End if . ( ) For Next . ( ) While wend 7. Which of these command is used to take input from the user ? * . ( ) Inputbox . ( ) Textbox . ( ) InputText . ( ) InputValue 8. Which of these is a datatype used to store the decimal numbers in variable ? * . ( ) Double . ( ) Decimal . ( ) Long . ( ) Float 9. Which of these command is used to stop screen flickering ? * . ( ) Application.HideScreen = True . ( ) Application.EnableEvents = False . ( ) Application.DisplayAlerts = False . ( ) Application.Screenupdating = False 10. Which is the file extension that cannot be used for macro excel file ? * . ( ) .XLSM . ( ) .XLSX . ( ) .XLSB . ( ) .XLS [Submit] Powered by Google Docs <http://docs.google.com> Report Abuse <https://docs.google.com/spreadsheet/reportabuse?fromEmail=true&formkey=dHRE SnJEemJNVmQ3Ym9SbnNvWnZDUEE6MQ&source=https://docs.google.com/spreadsheet/vi ewform?fromEmail%3Dtrue%26formkey%3DdHRESnJEemJNVmQ3Ym9SbnNvWnZDUEE6MQ> - Terms of Service <http://www.google.com/accounts/TOS> - Additional Terms <http://www.google.com/google-d-s/terms.html> -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
