Question: True or false on 9-17 and the rest multiple choice pyipt dfeble 9. Range(A1). Value Refers to the contents of cell Al in Excel sheet
pyipt dfeble 9. Range("A1"). Value Refers to the contents of cell Al in Excel sheet 1 10. Cells(1, 1). Value Refers to the contents of cell B1 in Excel sheet 1 11. Const PI = 3.14159 In the above declaration, PI is declared as a constant 12. LCase0 and UCase are example of string functions in VBA 13. Perimeter 2/Radius In the above expression, Perimeter and Radius are of type double. If Radius-4, then the value of Perimeter is 1.5 14. The function MsgBox0 is used to output user data 15. The function InputBox) is used to collect user input data 8:15 PM 32% 16. The value 3.1456 is an example of Type Integer in VBA 17. Left0 is a string function in VBA. Option Explicit Dim answer As Integer, subb As Integer Dim Numl As Integer, Num2 As Integer Private Sub AddValue() Num 1-22 Num2-11 Range("B2").Value Num1 + Num2 answer = 100 answer-answer + 1 MsgBox (Range("B2").Value) MsgBox ("value of cell b2 using range syntax is" & Range("b2").Value) Cells(5, 4).Value- "hello" MsgBox (answer) End Sub 18. Option Explicit means that a. All variables are to be declared c. The number of variables cannot exceed 100 b. All variables are case sensitive d. Constants cannot be used at is the content of cell B2 after the program 19. Wh finishes execution
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
