Excel Macro Mastery
  • ubermenu logo50y
  • Member Area
      • Start here
          • How to use the Membership Area
          • The Blueprint for Learning Excel VBA
      • Downloads
          • 75+ Workbook Downloads(BETA)
          • Cheat Sheets(BETA)
      • Webinars
          • All Webinars

          • Most Popular
            • How to Design a VBA Application Like a Pro (Video)
            • 5 VBA Hacks Everyone Should know (Video)
            • How to use Class Modules in Excel VBA (Video)

          • Data Structures VBA
            • The Ultimate Guide to VBA Arrays (Video)
            • Excel VBA Collections – A Complete Guide (Video)
            • How to use the VBA Dictionary Like a Pro(Video)
          • Businesswoman pressing business type of modern buttons with virtHow to Copy Data Between ANY Two Sheets(Video)
  • VBA Articles
  • Courses
  • Webinars
  • My Account
      • Lost your Password?


    • Account Information

Application 1 Quiz

by Paul Kelly | Mar 16, 2022

Time limit: 0

Quiz Summary

0 of 10 Questions completed

Questions:

Information

You have already completed the quiz before. Hence you can not start it again.

Quiz is loading…

You must sign in or sign up to start the quiz.

You must first complete the following:

Results

Quiz complete. Results are being recorded.

Results

0 of 10 Questions answered correctly

Your time:

Time has elapsed

You have reached 0 of 0 point(s), (0)

Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)

Categories

  1. Not categorized 0%
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  1. Current
  2. Review
  3. Answered
  4. Correct
  5. Incorrect
  1. Question 1 of 10
    1. Question

    How do you link an existing Button to a sub(when the button is clicked, the code in the sub runs)?

    Correct
    Incorrect
  2. Question 2 of 10
    2. Question

    What does Debug.Print do?

    Correct
    Incorrect
  3. Question 3 of 10
    3. Question

    What happens when we run the code below:

     Public Sub CreateReport()
     
     ' 1. Turn off functionality such as auto calculations
      
     ' 2. Clear existing data
      
     ' 3. Find and copy matches
      
     ' 4. Turn functionality back on 
    
     End Sub

    Correct
    Incorrect
  4. Question 4 of 10
    4. Question

    How do you run a Sub from the Visual Basic Editor?

    Correct
    Incorrect
  5. Question 5 of 10
    5. Question

    Which of the following statements is true?

    Correct
    Incorrect
  6. Question 6 of 10
    6. Question

    What’s the difference between a Public and Private Sub?

    Correct
    Incorrect
  7. Question 7 of 10
    7. Question

    Which of these is true about the code name of the Worksheet?

    Correct
    Incorrect
  8. Question 8 of 10
    8. Question

    When is it correct to indent our code?

    Correct
    Incorrect
  9. Question 9 of 10
    9. Question

    Which of these lines is used to open a file?

    Correct
    Incorrect
  10. Question 10 of 10
    10. Question

    Given the following worksheet, what range will the code below return?


    Dim rg As Range
    Set rg = shData.Range("A2").CurrentRegion

    Correct
    Incorrect

You are not logged in

You are not currently logged in.








» Register
» Lost your Password?
  • Facebook
  • Twitter
  • Instagram
  • RSS

Designed by Elegant Themes | Powered by WordPress