logo

Accounting System and Process - Assignment

   

Added on  2020-03-28

18 Pages1449 Words30 Views
Running head: ACCOUNTING SYSTEM AND PROCESSAccounting system and processName of the universitySubject code and nameStudent name and student ID numberAssignment task numberAuthor note
Accounting System and Process - Assignment_1
1ACCOUNTING SYSTEM AND PROCESSTable of ContentsAnswer no. 1.............................................................................................................................................2Answer no. 2.............................................................................................................................................2Answer no. 3.............................................................................................................................................3Answer no. 4.............................................................................................................................................3Answer no. 5.............................................................................................................................................4Answer no. 6.............................................................................................................................................5Answer no. 7.............................................................................................................................................9Answer no. 8...........................................................................................................................................10Answer no. 9...........................................................................................................................................12Answer no. 10.........................................................................................................................................12Answer no. 11.........................................................................................................................................13Answer no. 12.........................................................................................................................................13Answer no. 13.........................................................................................................................................14Reference................................................................................................................................................17
Accounting System and Process - Assignment_2
2ACCOUNTING SYSTEM AND PROCESSAnswer no. 1Replacing the cell references with the names assists the user to use the spreadsheet as per hisrequirement (Bebbington, Unerman & O'Dwyer, 2014). For instance, the user can format the sheet,use formula in the sheet only after naming the cell. Example of a spreadsheet that presents the owner’sequity + Liabilities = Asset is shown below –Answer no. 2To make the negative numbers more visible and clear to the users of the sheet, the negativenumbers may be shown within bracket instead representing it with the minus sign (Drury, 2013). Theexample that shows the negative numbers within bracket is shown below –
Accounting System and Process - Assignment_3
3ACCOUNTING SYSTEM AND PROCESSAnswer no. 3The spreadsheet includes the processed data as well as the unprocessed data. Therefore, todifferentiate the processed and unprocessed data the spreadsheet shall be segregated into data area andreport area. It will further, assist the user extract different data as per his requirement and process thedata for required purposes. Spreadsheet representing separate report area and data are is below –Answer no. 4If function is regarded as the logical function under the spreadsheet; It performs logical testthat is used to analyse whether the particular condition is satisfied or not. If the condition is satisfied,the IF function returns TRUE value and if not then it returns the FALSE value.
Accounting System and Process - Assignment_4

End of preview

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

Related Documents
Report Based on Management Accounting
|20
|1507
|35

Accounting System and Process : Assignment
|20
|1489
|267

Assignment on Accounting System & Process
|20
|1600
|30

University Name and ID Assignment Task Number
|21
|1375
|144

Accounting System and Process- Assignment
|20
|1554
|34

University Accounting System And Process Name Of The University Accounting System And Process Name Of The University
|19
|833
|358