Excel Vba For Actuaries Quiz

5 Questions | Total Attempts: 963

Settings
Please wait...
Microsoft Excel Quizzes & Trivia

Questions and Answers
  • 1. 
    What is a way to code a random number between 0 and 1 in VBA?
    • A. 

      WorksheetFunction.Rand()

    • B. 

      WorksheetFunction.Randbetween(0,100)/10

    • C. 

      WorksheetFunction.Randbetween(0,100)/

    • D. 

      WorksheetFunction.Randbetween(0,100)/100

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

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

    • B. 

      Range("A1") = Month

    • C. 

      Cells(1,1) = "Month"

    • D. 

      Cell(1,1) = "Month"

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

      Outer is simcounter, inner is itemcounter

    • B. 

      Outer is itemcounter, inner is simcounter

    • C. 

      Only itemcounter loop

    • D. 

      Only simcounter loop

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

      Functions WarrantyPrice(item,brand) as string

    • B. 

      Functions WarrantyPrice(item,brand) as integer

    • C. 

      Function WarrantyPrice(item) as integer

    • D. 

      Function WarrantyPrice(item,brand) as Double

  • 5. 
    Task 4, how do you correct this declaration? Dim items As String
    • A. 

      Dim items As Integer

    • B. 

      Dim item As String

    • C. 

      Dim item As Integer

    • D. 

      Delete entire line