Excel Vba For Actuaries Quiz

1. Task 4, how do you correct this declaration? Dim items As String

Dim items As Integer

Dim item As String

Dim item As Integer

Delete entire line

The correct answer is "Dim item As String" because it replaces the incorrect declaration "Dim items As String" with the correct variable name "item" and the correct data type "String".

Explanation

The correct answer is "Dim item As String" because it replaces the incorrect declaration "Dim items As String" with the correct variable name "item" and the correct data type "String".

2. You want to write "Month" to cell A1. What code will do this?

Range("A2").Value = "Month"

Range("A1") = Month

Cells(1,1) = "Month"

Cell(1,1) = "Month"

The correct answer is Cells(1,1) = "Month". This code will write the value "Month" to cell A1.

Explanation

The correct answer is Cells(1,1) = "Month". This code will write the value "Month" to cell A1.

3. Task 2, what is the outer loop? What is the inner loop?

Outer is simcounter, inner is itemcounter

Outer is itemcounter, inner is simcounter

Only itemcounter loop

Only simcounter loop

The correct answer is "Outer is simcounter, inner is itemcounter". This means that there are two loops in the code, with the outer loop being controlled by the variable "simcounter" and the inner loop being controlled by the variable "itemcounter". The outer loop will execute its code block first, and then the inner loop will execute its code block for each iteration of the outer loop.

Explanation

The correct answer is "Outer is simcounter, inner is itemcounter". This means that there are two loops in the code, with the outer loop being controlled by the variable "simcounter" and the inner loop being controlled by the variable "itemcounter". The outer loop will execute its code block first, and then the inner loop will execute its code block for each iteration of the outer loop.

4. Task 3, How did you define your WarrantyPrice function?

Functions WarrantyPrice(item,brand) as string

Functions WarrantyPrice(item,brand) as integer

Function WarrantyPrice(item) as integer

Function WarrantyPrice(item,brand) as Double

The correct answer is "Function WarrantyPrice(item,brand) as Double". This is because the function definition includes two parameters, "item" and "brand", and it specifies that the function will return a value of type "Double". This means that the function is expected to take in an item and brand as input and calculate and return a warranty price as a decimal number.

Explanation

The correct answer is "Function WarrantyPrice(item,brand) as Double". This is because the function definition includes two parameters, "item" and "brand", and it specifies that the function will return a value of type "Double". This means that the function is expected to take in an item and brand as input and calculate and return a warranty price as a decimal number.

5. What is a way to code a random number between 0 and 1 in VBA?

WorksheetFunction.Rand()

WorksheetFunction.Randbetween(0,100)/10

WorksheetFunction.Randbetween(0,100)/

WorksheetFunction.Randbetween(0,100)/100

The correct answer is WorksheetFunction.Randbetween(0,100)/100. This code generates a random number between 0 and 100 using the Randbetween function, and then divides it by 100 to scale it down to a number between 0 and 1.

Explanation

The correct answer is WorksheetFunction.Randbetween(0,100)/100. This code generates a random number between 0 and 100 using the Randbetween function, and then divides it by 100 to scale it down to a number between 0 and 1.