Crowdly

Based on the representation of a VBA Project shown below, which of the statements are true?

Variable “y” can be called in subroutine “MySub3”.

Variable “a” can be used in function “fun”.

Variable “z” can be called in subroutine “MySub3”.

The value of variable “hello” is reset each time subroutine “MySub” is run.

Variable “x” keeps and updates its value each time subroutine “MySub2” is run.

Image – 1 shows the raw data. I go to Developer Tab > Code Group and select “Use Relative References” and then start recording a macro, do certain operations and stop recording the macro. The data after I stop recording is shown in Image – 2. I then selected cell C1 and run the macro. Which picture demonstrates the final version of the data?

Image-1

Image-2

Inputting result=5+2*3^2 would make the value of result 41.

Suppose you have declared a variable named “result” of type variant. Select the options that are true based on the order of operations in VBA.

Note: When evaluating the options, consider only whether the expression produces the stated value. Minor differences in representation (e.g., 1 vs. 1.0) should be treated as equivalent.

Inputting result = 5\2 would make the value of result 2.

Inputting result=(8+2)/2*3 would make the value of result 15.

Inputting result = “hello ” & “world” would make the value of result “hello world”

Inputting result=8<2 would make the value of result False.

Which of the following procedures will

result in a compiler error if executed?

Below you can see a screenshot of a Visual Basic Editor (VBE). Based on what you see in VBE, select the statements that are true.

The Code Window is not visible, but one can view it from View > Code or by double clicking a Module or Sheet.

The locals windows is useful to track the value of the variables as I run the program step by step.

Modules are correct places to write procedures (subs and functions).

There is only one workbook open:“DM25_PracticeWorkbook2_Sols.xlsm”.

One can insert a module into any workbook by clicking

on the corresponding VBAProject and then on Insert tab and selecting Module.

Suppose

we have the user-defined function shown in the screenshot below. If we input

=discountedProfit(1000;800;0.1) in one of the cells in one of the worksheets in

the same workbook that the function is defined, what will be the value in the

cell when we hit enter?

200

150

100