I agree. Maybe CA2 Student was just lucky in that you only needed to use SUM.
The LARGER matter is not the actual formulae that you finally use, but putting it all together in a spreadsheet that
- works;
- being able to expand it (in EXACTLY the way required for the additional knowledge)
- can be followed relatively easily (both by a marker and yourself to check errors)
For an unfamiliar topic, this can be quite difficult (and I don't think I'm alone in this thought). Creating good spreadsheets at work is a lot different than a random unfamiliar exercise.
Work may not be appropriate to get experience because day-to-day work is fairly standard in most offices and you have the benefit of set in-house procedures, add-ins etc.
The profession's site has only 2 exam type examples to attempt. Acted has another one, but that doesnt leave many ways to get experience (If anyone has more examples to try, please post them)
Without a decent spreadsheet, I think your chances are pretty slim, even though the spreadsheet itself isn't worth many marks.
That being said, I think it is a good skill that actuaries need. We just need to work on teaching those who don't yet have it.
And there aren't many simple ways to improve it. The topics need to be unfamiliar because it has to be accessible for everyone (which means general work that you probably never did before or will do again)
More time, more tuition, and more help on the day are the best obvious improvements to be made.