Difference between revisions of "Excel Practice Problems"

Revision as of 19:11, 8 October 2022

If you find any typos or errors, please post to the PRACTICE EXAM category of the forum here: Forum
For the IFRS 17 Bonus Question, you will need to refer to the source text for the CIA.IFRS17-LRC.
For all calculation problems in the practice exam (except #14 and #18) you can change the input values and the answers will automatically update. In other words, you can create your own practice problems.

Excel Problems	Answer File
BA Practice Exam 1 (2022-Fall)	BA Practice Exam 1 (2022-Fall) (with answers)
Bonus Question on IFRS 17	Answer in same file as question

Practice exam 1: Total points = 70.0, difficulty = moderate, pass mark = 49.0 pts or 70.0% Practice exam 2: Total points = 75.0, difficulty = HIGH, pass mark = 52.5 pts or 70.0%

Excel Problems	Examiner's Report
BA Practice Exam 1	BA Practice Exam 1 (with answers)
BA Practice Exam 2	BA Practice Exam 2 (with answers)

@@ Line 12: / Line 12: @@
 |-
-| [https://www.battleactsmain.ca/Excel/BattleActs_Practice_Exam_6C_Version_A_(2022_Fall)_0010.xlsx <span style="color: white; font-size: 14px; background-color: brown; border: solid; border-width: 1px; border-radius: 10px; margin: 0px; padding: 2px 10px 2px 10px; margin: 10px;">'''BA Practice Exam 1 (2022-Fall)'''</span>]
+| [https://www.battleactsmain.ca/Excel/BattleActs_Practice_Exam_6C_Version_A_(2022_Fall)_0010_v2.xlsx <span style="color: white; font-size: 14px; background-color: brown; border: solid; border-width: 1px; border-radius: 10px; margin: 0px; padding: 2px 10px 2px 10px; margin: 10px;">'''BA Practice Exam 1 (2022-Fall)'''</span>]
-|| [https://www.battleactsmain.ca/Excel/BattleActs_Practice_Exam_6C_Version_A_(2022_Fall)_0010_answers.xlsx <span style="color: white; font-size: 14px; background-color: orange; border: solid; border-width: 1px; border-radius: 10px; margin: 0px; padding: 2px 10px 2px 10px; margin: 10px;">'''BA Practice Exam 1  (2022-Fall) (with answers)'''</span>]
+|| [https://www.battleactsmain.ca/Excel/BattleActs_Practice_Exam_6C_Version_A_(2022_Fall)_0010_answers_v2.xlsx <span style="color: white; font-size: 14px; background-color: orange; border: solid; border-width: 1px; border-radius: 10px; margin: 0px; padding: 2px 10px 2px 10px; margin: 10px;">'''BA Practice Exam 1  (2022-Fall) (with answers)'''</span>]
 |-