Basic Excel For Actuaries Quiz

5 Questions

Settings
Please wait...
Microsoft Excel Quizzes & Trivia

See if you got the correct answers in the assignment


Questions and Answers
  • 1. 
    For the Warranty Sales tab --- Task 1, what is the total warranty sales for 2012?
    • A. 

      $25,000

    • B. 

      $29,844

    • C. 

      $30,115

    • D. 

      $28,944

  • 2. 
    For the Warranty Claims 1 YR tab  --- Task 2, what was the total warranty claims in $ for Phones? 
    • A. 

      $2280

    • B. 

      $2000

    • C. 

      $3850

    • D. 

      $3080

  • 3. 
    For the Warranty Claims 1 YR tab --- Task 2, if the warranty sale resulted in a claim, what was the average warranty claim amount in $?
    • A. 

      $999.19

    • B. 

      $2554.10

    • C. 

      $554.12

    • D. 

      $150.35

  • 4. 
    For the Warranty Sales 5 YR tab --- Task 3, what percentage of warranties sold in terms of counts were Plus for the entire 5 year period?
    • A. 

      50.41%

    • B. 

      49.59%

    • C. 

      45%

    • D. 

      55%

  • 5. 
    For the Forcasting tab --- Task 5, if in 2013, Sales were $35,000 and expenses were $1,050, what would claims need to be in 2013 to reach a total six year Loss Ratio of 95%?
    • A. 

      $28,260

    • B. 

      $31,278

    • C. 

      $33,250

    • D. 

      $35,000