Hi All,
I am just getting to go through my marked scripts for the mock exams I submitted recently.
One comment said:
I'd recommend you to avoid referring to specific rows, columns or cells by number in your audit trail. If rows or columns need to be added or deleted later, these would change. (I know that there are a lot of these in the specimen solutions!)
Any thoughts on the above? Anyone else surprised at GYL's very first comment re: don't reference cells, etc? Isn't this inconsistent with the solutions presented? But he has a point though. If columns/rows are inserted/deleted then these references may become invalid. So what do we do in the exam? I think I would still signpost and do some cell referencing, since marking schemes show that we get marks for this....
I also think it's an excellent tip re: including an Overview tab to appear more organised. I saw this once or twice in looking at past paper solutions though, so I don't think it's necessary.... but it just may leave a good impression on the examiner(s).... Hmmm.
What do you guys think???
~Paradise
Click to expand...
Hmm to be honest, I've always included specific cell references. But I try to avoid solely including them. So for example, you could say "I've included the following parameters.... and these are in the cell range C1:C5" or "the totals for the cashflows are in cells..."
On the other hand, if I'm doing a goal-seek, I would just say a goal-seek and check have been included on the tab. I normally highlight special cells in blue and note this in the audit trail. So the reader would know this is a special cell and doesn't need a cell reference.
Hope this helps!
Last edited by a moderator: Apr 15, 2019