Which of the following about subroutines and functions are true?

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

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.

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.

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?

Suppose you have declared a variable named “x” of type integer. You want to take an input from the active worksheet. If you select the cells shown below before running a sub, which of the options below indicate the correct ways to input the value of x as 7?