Excel Vba For Actuaries Quiz
-
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
-
This Excel VBA for Actuaries Quiz assesses skills in programming with Excel VBA, focusing on practical tasks like generating random numbers, manipulating cells, and defining functions. It is ideal for actuaries and other professionals enhancing their Excel VBA proficiency.
Quiz Preview
- 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"
Correct Answer
A. Cells(1,1) = "Month"Explanation
The correct answer is Cells(1,1) = "Month". This code will write the value "Month" to cell A1.Rate this question:
-
- 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
Correct Answer
A. Outer is simcounter, inner is itemcounterExplanation
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.Rate this question:
-
- 4.
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
Correct Answer
A. WorksheetFunction.Randbetween(0,100)/100Explanation
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.Rate this question:
-
- 5.
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
Correct Answer
A. Function WarrantyPrice(item,brand) as DoubleExplanation
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.Rate this question:
-
Quiz Review Timeline (Updated): Mar 22, 2023 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 22, 2023Quiz Edited by
ProProfs Editorial Team -
Mar 01, 2013Quiz Created by
Actuwaiter
Back to top