logo

Wesfarmers Financial Analysis Report

   

Added on  2020-03-16

20 Pages1671 Words383 Views
 | 
 | 
 | 
Running head: ACCOUNTING SYSTEM AND PROCESSAccounting system and processName of the UniversitySubject code and name ‘Student Name and IDAssignment Task NumberAuthor Note
Wesfarmers Financial Analysis Report_1

1ACCOUNTING SYSTEM AND PROCESSTable of ContentsAnswer 1:................................................................................................................................................3Answer 2:................................................................................................................................................3Answer 3:................................................................................................................................................4Answer 4:................................................................................................................................................4Answer 5:................................................................................................................................................5Answer 6:................................................................................................................................................5Answer 7:................................................................................................................................................7Answer 8:................................................................................................................................................9Answer 9:..............................................................................................................................................10Answer 10:............................................................................................................................................10Answer 11:............................................................................................................................................10Answer 12:............................................................................................................................................11Answer 13:............................................................................................................................................11References:............................................................................................................................................14
Wesfarmers Financial Analysis Report_2

2ACCOUNTING SYSTEM AND PROCESSAnswer 1: A name is the meaningful shorthand and it makes the sheet easier for understanding. Throughusing the names, the users can use the formulas easily and the sheets can be maintained easily(Baños-Caballero, García-Teruel & Martínez-Solano, 2014). Further, after naming the cells it can beused for formatting, editing, addition and deletion of data.Answer 2: The negative number in the spreadsheet can be displayed through the following steps –Choose the specific range or cell to be formatted with the negative numbersIf the user is using the Windows system then he needs to press CTRL+1 or if he is using Macthen he needs to press +1.Under the Category option the user needs to select Currency or Number optionFrom the Negative numbers, choose the option for the negative numbers (Brigham, 2014).The negative numbers can be shown through red colour, putting negative sigh in front of thenumber or within the bracket. However, the users prefer to show the data within bracket rather thanwith the minus sign to attract the concentration of the users and make it more visible.
Wesfarmers Financial Analysis Report_3

3ACCOUNTING SYSTEM AND PROCESSBelow shown example represent the negative numbers in bracket - Answer 3: It will be helpful for the user to differentiate the processed data and the unprocessed data if thereport is divided into data area and report area otherwise the data will be jumbled up (Bryce, 2017).Moreover, the user can edit, format or adjust the raw data to process it and represent it in report area. Below shown example represent the data area and the report area as follows –
Wesfarmers Financial Analysis Report_4

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents