Start Now!


Excel Questions

Google Sheet Solutions

Exam Preparation Tools to Assist in Achieve a Passing Score

CAS Exam 6U: October 23, 2024 - October 30, 2024

Comprehensive Study Materials in Spreadsheet Format

Working questions in Excel is by far the best way to prepare for CAS Exam 6U now administered in Pearson VUE’s computer based testing environment.

Download approximately 420 past CAS questions in Excel.

  • Work these questions and then work a duplicated set of the same questions.

  • Track your progress by entering the dates you first worked the question and when you did so for a second time.

  • Manage questions by flagging them as incomplete, finished, and needs review

  • Self score your work to gauge what you know and to identify knowledge gaps for additional review

Access over 1200 solutions to past questions, over 350 Examiner Reports, and Learn How to Develop Full Credit Solutions.

  • Learn by studying instructional answers to fully comprehend the solution process

  • Review Examiner Reports to identify gaps in your knowledge and to sidestep common mistakes

  • Learn how to develop sufficient and efficient solutions by comparing your solutions to CAS model answer to gain full credit, leaving ample time to review your answers on the exam.

Solutions are view only. To view the Solutions in Google Sheets you must have a Gmail account. If you do not have one, the sign up process is simple.

Click here to create a gmail account.

Click the Free Preview button to download sample questions and solutions.

Question Dashboard

Section 1

Each excel spreadsheet for a given chapter/article contains a dashboard identifying various aspects of past CAS questions.

When choosing questions to work on, look to the number of points as a good indicator of the relative difficulty of the question.
Begin with questions having a lower point value and then work on higher point level questions.

Question Dashboard

Section 2

Manage your attempts at solving and self scoring each attempt, since each question is duplicated.

  • Doing so is critical to assessing your progress by evaluating the quality of your solutions over time.

  • Flag questions as Finished, Incomplete, or Needs Review to manage what you mastered, what you need to do, and what you need to review again.

Question Layout

Each question provides areas to answer and self-score twice.

Your confidence and competence grow when you:

  • note areas for improvement in the spreadsheet after solving the question on a first attempt, and then

  • work the same question again, at a future point in time.

Assess your progress by "toggling" between tabs (e.g. tab (1) and tab 1(2)) to compare your answers in terms of computational efficiency and or the quality of your short answer responses.

Solutions Layout

Shown to the right is an example of how we present solutions to past CAS questions.

Solve the approximately 400 questions, study over 1200 solutions, and review the 350+ Examiner's Report comments and you'll be more than competent to answer future questions.

Unique to out solution format are:
  • Instructional Solutions
  • Sufficient Solutions
  • Examiner’s Report Comments
  • Instructional Solutions

    To write sufficient and efficient solutions, you'll need to be adept at problem solving.

    Our instructional solutions contain the level of detail needed for you to solidify your understanding of the material.

    • To the right is an example of what you can expect to see in our spreadsheets for each past CAS computational type question.

    • Significant time was spent preparing thorough solutions, so that your need for video solutions, or asking an instructor to explain a solution is virtually eliminated.

    Sufficient Solutions

    Your ability to pass the exam will in large part be a function of how well you can succinctly and accurately answer questions.

    You know the material well when you can consistently develop solutions like the one shown to the far right on the exam.

    The keys to you developing answers like this begin by:

    • working questions multiple times

    • understanding the level of detail to incorporate in your solutions to multiple step problems, and

    • being mindful of previous examiner’s report commentary when developing your responses.

    Examiner's Reports

    Examiner's report commentary can be lengthy and is extremely beneficial in helping you to answer past and future questions.

    Examiner’s reports assist you in achieving a passing score in several ways:

    • Identifying gaps in your knowledge, so that you can sidestep common mistakes when answering questions a second time.

    • Providing you with insight into what concepts examiner’s were testing, so that you can quickly spot these concepts in future questions.

    • Assisting you with self-scoring. You will accurately measure your progress if you score your first attempt answers fairly, avoid mistakes you previously made in your first attempt, and then re-score your second attempt responses.

    Course curriculum

    1. 1
      • Preparing for CAS Exam 6U

    2. 2
      • Recommended Reading and Time Management Schedule

    3. 3
    4. 4
      • Chapter 2 - Development of Insurance Regulation

      • Chapter 3 - Federal and Other Influences on Insurance Regulation

      • Chapter 4 – Roles of State Regulators and the NAIC in Insurance

      • Chapter 5 – State Department of Insurance Operations

      • Chapter 6 – Insurer Formation, Licensing, and Marketing Regulation

      • Chapter 8–Rate Regulation

      • Chapter 12 – Insolvency Regulation

    5. 5
      • Past CAS Questions - In Excel

    6. 6
      • Past CAS Questions (in Excel)

    7. 7
      • Past CAS Questions (in Excel)

    8. 8
      • Past CAS Questions (in Excel)

    9. 9
      • Past CAS Questions (in Excel)

    10. 10
      • Past CAS Questions (in Excel)

    11. 11
      • Past CAS Questions (in Excel)

    12. 12
      • Past CAS Questions (in Excel)

    13. 13
      • Comments

    14. 14
      • Comments

    15. 15
      • Past CAS Questions (in Excel)

    16. 16
      • Past CAS Questions (in Excel)

    17. 17
      • Past CAS Questions (in Excel)

    18. 18
      • Past CAS Questions (in Excel)

    19. 19
      • Comments

    20. 20
      • Past CAS Questions (in Excel)

    21. 21
      • Past CAS Questions (in Excel)

    22. 22
      • Past CAS Questions (in Excel)

    23. 23
      • Past CAS Questions (in Excel)

    24. 24
      • Past CAS Questions (in Excel)

    25. 25
      • Past CAS Questions (in Excel)

    26. 26
      • Past CAS Questions (in Excel)

    27. 27
      • Past CAS Questions (in Excel)

    28. 28
      • Past CAS Questions (in Excel)

    29. 29
      • Past CAS Questions (in Excel)

    30. 30
      • Past CAS Questions (in Excel)

    31. 31
      • Past CAS Questions (in Excel)

    32. 32
      • Past CAS Questions (in Excel)

    33. 33
      • Past CAS Questions (in Excel)

    34. 34
      • Past CAS Questions (in Excel)

    35. 35
      • Past CAS Questions (in Excel)

    36. 36
      • Past CAS Questions (in Excel)

    37. 37
      • Past CAS Questions (in Excel) - Part 1

      • Past CAS Questions (in Excel) - Part 2

    38. 38
      • Past CAS Questions (in Excel)

    39. 39
      • Past CAS Questions (in Excel)

    40. 40
      • Past CAS Questions (in Excel)

    41. 41
      • Past CAS Questions (in Excel)


    • How many questions and solutions do I have access to?

      You have access to 38 downloadable spreadsheets in Excel containing over 430 past CAS questions in total. You also have access to 38 view only solution spreadsheets containing over 1,000 solutions in Google Sheets.

    • Do I need a gmail account to access the solutions?

      Yes. Once you provide us with your gmail account, a folder with the solutions will be shared to your Google Drive.

    • Will I be able to see what formulas were used in all of the solution sheets?

      Yes. Once in google sheets, hit the F2 button on your keyboard to view what calculations were used in solving the problem. See screen shot below

    • How long will I have access to the question and solution files?

      Since you can download the spreadsheets You have access to them 24/7. You have access to the solution files through exam day.

    • If I fail the exam, can you reinstate my access to the solution files?

      Yes. Send us your CAS grade report showing you did not receive a passing score and we will reinstate access to the solutions.

    • Our company uses a study coordinator to purchase study materials on behalf of its students. Can this coordinator purchase on my behalf?

      Yes. Have the coordinator make the purchase using their name and email address, and email support@actuarialtesting with your name and email address to access the questions and solutions.