- This topic has 5 replies, 2 voices, and was last updated 3 years ago by
.
- Posts
I have been read the guide on acca student resources on how to use their spreadsheet and i can’t grasp what is being conveyed here:
Populate the following cells with the number of units to be produced each year:
• D2 – 600000
• E2 – 800000
• F2 – 1100000
• G2 – 700000
You have two options here; when you type in the production units you can type
them in using the 1000 separator (,) eg the cell D2 entry would be 600,000 or to use
the functionality in the spreadsheet, click on cell D2, hold the CTRL key on your
keyboard and click on cells E2, F2 and G2 (or drag your mouse over them). Once
these are highlighted, right click with your mouse and select the option to Format
Cells. This brings up a new window which has three tabs – Number, Alignment and
Border. Ensure you are on the Number tab, select Number from the category list
and click the check box for the 1000 separator. Click Apply, then OK.
An alternative option to format the cells would be to click on cell D2, hold the CTRL
key on your keyboard and click on cells E2, F2 and G2 (or drag your mouse over
them). Once these are highlighted select the ‘.00’ 2
option from the toolbar, select
Custom from the list and this will bring up the same window including the tabs
Number, Alignment and Border. The approach is then the same.It is saying that rather than format each sell separately (if you want to show the ‘,’ when the number is in thousands, or if you want to show ‘.00’ (i.e. cents) at the end of each number), then you can save time by highlighting all the relevant cells and then using the format instructions that are given in the note that you have typed out.
It doesn’t matter whether you type in each cell in full (with the ‘,’ or with the ‘.00) but by highlighting them and formatting them automatically all at once does save a bit of time.
Putting a ‘,’ is not important, but putting cents may be important depending on the question.
I depends whether the question asks for answer to the nearest cent or to the nearest $ etc..
It also depends on whether the question is asking about total costs (in which case to the nearest $) or whether the question is asking for unit costs (in which case to the nearest cent).
It should become clear when you practice questions in your Revision Kit (I am assuming that you have a Revision Kit from one of the ACCA Approved Publishers, because it is essential that you do.)
- You must be logged in to reply to this topic.