Page 1 of 1
QUESTION 12 Consider the following code. It is intended to go through each worksheet in the active workbook and write "I
Posted: Thu May 05, 2022 9:46 am
by answerhappygod
- Question 12 Consider The Following Code It Is Intended To Go Through Each Worksheet In The Active Workbook And Write I 1 (38.63 KiB) Viewed 36 times
QUESTION 12 Consider the following code. It is intended to go through each worksheet in the active workbook and write "IDS 331" in cell A1, "VBA" in cell A2, and the number of the current worksheet in cell A3. Each blank is numbered, e.g. 1 is the blank numbered 1, match the numbered blanks to their answers. _2________ is the blank numbered 2, etc. The goal is to Dim wsitem As__1______ _______________ counter As Integer counter = 1 For Each _3______ In 4 .Range("A1").Value = "IDS 331" _6____ .Range("A2").Value = "VBA" .Range("A3").Value = counter counter = _____8____+1 Next wsitem Answer the following 8 questions individually (each is worth 12.5% of the worth of this question). Note that different questions may have the same answer option. - What should be in the blank numbered 1? A. Range B. Dim ✓ What should be in the blank numbered 2? C. Workbooks D. Worksheet E. Worksheets ✓ What should be in the blank numbered 3? ✓ What should be in the blank numbered 4? ✓ What should be in the blank numbered 5? ✓ What should be in the blank numbered 6? ✓ What should be in the blank numbered 7? ✓ What should be in the blank numbered 8? F. counter G. ActiveSheet H.wsltem 8 points Save Answer