Forum Replies Created
- Posts
.
I thought I was well prepared for key areas of the syllabus but was surprised by the type of questions in the exam..I started with section C straight away but wasted too much time on my response to that probability question.
The remaining exam A and B was under pressure due to timeAnyone else has an issue with ACCA clunky version of excel provided on the exams?
It is not a version that anyone would encounter in a work place (even if running Windows 98)Here’s a summary of the most relevant issues I found:
– cut and paste a block of data throws away the formula. I.e. a SUM formula continues to sum to old cell location
Result: moving a block of data require formulas to be reviewed and formulas amended
– unable to lock cell references using the $ symbol (e.g., $A$1) and drag the formula across other cells. When I try to copy or drag the formula, the locked reference does not behave as expected,
Result: formulas referring to a cell (i.e. price p/u on column X) will have to be manually typed it rather than dragged across to populate the periods automatically– when entering a formula, the opening and closing brackets (parentheses) do not automatically as they would on a normal version of excelInstead, you have to manually type them.
Result: error message appears suggesting error in syntax– cannot add/remove a row which is further aggravated by limitations of a cut/paste a block of data described above
Result: data needs to be copy pasted to new location and formulas reviewed/redoneUsing exam time to adapt to an excel version only found in acca exams is an additional and unnecessary challenge.
Not even mentioning the fact that it is displayed in fraction of a screen the size of an average phone..
I fed this back to ACCA a while back but I guess I will just have to cope with it for the remaining exams..
Thank you SO MUCH John Moffat.
Your lectures were essential to my success on the exam.
