- This topic has 127 replies, 38 voices, and was last updated 6 years ago by
.
- Posts
I’ve went through this whole thread and found it really useful !! I have one query which was discussed here but I’m still not clear.
Im doing T20 and for showing the use of excel I’ve calculated the % change in revenue and PBT of the company. The graph showing the changes in PBT was edited in Word although I calculated the change in an excel sheet. So, should I create the chart in excel and then paste it as an image in Word or just referencing to the Appendix is enough ?
Secondly, what should I name the tab and the excel file ? I’ve named the tab as % change in PBT over 5 years and the file as Appendix 1.If you are discussing PBT then you need to include the chart in the report itself. Remember regardless of how you paste it in, the words should be counted as part of your word count
If you only have one worksheet then the actual title of the tab is not important (delete unused sheets) otherwise as long as the title gives some idea of the content that should be sufficient.
Everyone needs to ensure they load an Excel spreadsheet – this is a requirement to pass Assessment Criterion 7 and without an actual spreadsheet that shows formulae you will be tailed.
Thanks for the reply!!
The word count displayed in Word doesn’t include the words in the charts. I’ll count them myself and include it in the word count on the cover page ?
I’ve included charts for both the changes in PBT and revenue in my report. The calculations for these are in separate excel files. Should I include the other one in appendix 1 itself but with another tab ? And how will I reference it then if its the same doc but with different tab?
- You must be logged in to reply to this topic.