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
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
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 –
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.
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents
Report Based on Management Accountinglg...
|20
|1507
|35
Accounting System and Process : Assignmentlg...
|20
|1489
|267
Assignment on Accounting System & Processlg...
|20
|1600
|30
University Name and ID Assignment Task Numberlg...
|21
|1375
|144
Accounting System and Process- Assignmentlg...
|20
|1554
|34
University Accounting System And Process Name Of The University Accounting System And Process Name Of The Universitylg...
|19
|833
|358