Excel VBA Quiz

This is a Excel VBA Beginner Quiz

Excel VBA Quiz Test

Please enter your email:

1. How to get the Developer Tab in Excel?

Telugu Language Video Hint: Watch this video for the answer How to Add the Developer Tab in Excel

 
 
 
 

2. How to see the Object browser in Excel VBA window?

Telugu Language Video Hint: Watch this video for the answer Excel VBA interface and options

 
 
 
 

3. How many ways we can run the Macro?

Telugu Language Video Hint: Watch this video for the answer What Excel VBA code| How to Run it

 
 
 
 

4. What is correct VBA code for below requirement?

The requirement should be completed in the same order below:

  1. In the cell, J10 update text Commerce and Excel Hub
  2. In the cell, J10 Change the font to Bold

Telugu Language Video Hint: Watch this video for the answer How to record the macro and Analyze the code

 

 

 
 
 
 

5. How the VBA code line is structured? Please select the correct option.

Telugu Language Video Hint: Watch this video for the answer What is Object, Property and method?

 

 
 
 
 

6. In the below VBA Code line. What is Copy called?

ActiveCell.Copy

Telugu Language Video Hint: Watch this video for the answer What is Object, property, Method

 
 
 
 

7. What is VBA code to update the value “Excel” in different cells A1, B10, and also C11 to D15 with Single line Code?

Telugu Language Video Hint: Watch this video for the answer How to use Range Property in Excel VBA

 

 
 
 
 

8. Please select correct VBA code from below. Suppose you are in cell A15 you want to select the cell C7 using the Offset property.

Telugu Language Video Hint: Watch this Video for answer What is Offset & How to use it

 

 
 
 
 

9. Please select correct VBA code from below. Suppose you are in cell B15 you want to select the cells from B15 to F20 using the Resize property.

Telugu Language Video Hint: Watch this Video for answer What is Resize property & How to Use it

 
 
 
 

10. In the Data tab How many data Types options we have in Excel?

Telugu Language Video Hint: Watch this Video for answer 5 Excel Tricks in Telugu