Excel Vba For Actuaries Quiz

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Actuwaiter
A
Actuwaiter
Community Contributor
Quizzes Created: 2 | Total Attempts: 1,762
| Attempts: 1,222
SettingsSettings
Please wait...
  • 1/5 Questions

    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
Please wait...
About This Quiz

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.

Excel Vba For Actuaries Quiz - Quiz

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 itemcounter
    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.

    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)/100
    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.

    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 Double
    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.

    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, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Mar 01, 2013
    Quiz Created by
    Actuwaiter
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.