logo

Assignment Accounting Systems and Processes

   

Added on  2020-04-01

32 Pages2765 Words33 Views
Running head: ACCOUNTING SYSTEMS & PROCESSESAccounting Systems & Processes Name of the StudentCourse Code
Assignment Accounting Systems and Processes_1
1ACCOUNTING SYSTEMS & PROCESSESAnswer to question 1Renaming Cell AddressHere, D34 cell is denoted as Net profit cell after renaming option.Net profit = Operating profit - Taxes
Assignment Accounting Systems and Processes_2
2ACCOUNTING SYSTEMS & PROCESSESAnswer to question 2Negative ValueHere, Operating profit has been denoted as negative value which is identified by numbersin brackets and highlighted in red color.
Assignment Accounting Systems and Processes_3
3ACCOUNTING SYSTEMS & PROCESSESHere operating profit is in negative value. So the highlighted figure is highlighted in red and inbrackets.Answer to question 3The two halves of a spreadsheet are the data area and the report part, along with theformulae. Data is written in a sequence in the excel sheet, other than this, data collected by a
Assignment Accounting Systems and Processes_4
4ACCOUNTING SYSTEMS & PROCESSESperson is calculated after applying different formulae (Deegan, 2012). In the report area, IFfunction is used. Hence, the data is changed in the first half and the whole calculation is done inreport area.For example, expense data and sales data are given in the data area with its respectivevalues. However, to calculate the net income based on the provided data, one column is added byeasily using formula. The following method is depicted in the screenshots given below:Step 1Step 2
Assignment Accounting Systems and Processes_5
5ACCOUNTING SYSTEMS & PROCESSESAnswer to question 4IF Function
Assignment Accounting Systems and Processes_6
6ACCOUNTING SYSTEMS & PROCESSESMany YouTube videos show the real functionality of the IF function and its usage aswell. As per the video shown in the above image , IF function displays a particular case created
Assignment Accounting Systems and Processes_7
7ACCOUNTING SYSTEMS & PROCESSESin the data table that also shows a result whether it is true or not. With the help of a cursor, thecomplete functionality of IF has been shown in the above YouTube channel.Answer to question 5 Periodic systems Periodic Inventory System is a system which updates the inventory after the end of aparticular period of time. Monitoring through this system of inventory keeps a track of the detailsof goods in an inventory of a fixed period (Deegan, 2012). It is not required to keep the record ofeach data updated for the inventory nor the prices of the sold goods. Accounting done throughthis system generally helps in the journal entries of a specific time period.
Assignment Accounting Systems and Processes_8

End of preview

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

Related Documents
Assignment on Masters in Professional Accounting
|35
|2802
|85

Accounting Information System
|34
|2547
|259

Assignment on Accounting Systems & Processes
|38
|2799
|39

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

Accounting System and Process - Doc
|13
|2582
|68

Accounting system and process - Assignment
|11
|1169
|233