logo

Accounting Systems & Processes Assignment

   

Added on  2020-04-07

29 Pages2058 Words36 Views
Running head: ACCOUNTING SYSTEMS AND PROCESSESAccounting systems and ProcessesName of the Student:Name of the University:Author Note:

ACCOUNTING SYSTEMS AND PROCESSES2Table of ContentsQuestion 1........................................................................................................................................3Question 2........................................................................................................................................3Question 3........................................................................................................................................4Question 4........................................................................................................................................5Question 5........................................................................................................................................6Question 6........................................................................................................................................7Formula View:...............................................................................................................................10Question 7......................................................................................................................................13Question 8......................................................................................................................................18Revised Data:.................................................................................................................................19Question 9:.....................................................................................................................................19Question 10....................................................................................................................................20Question 11....................................................................................................................................21Question 12....................................................................................................................................21Question 13....................................................................................................................................22Reference List................................................................................................................................26

ACCOUNTING SYSTEMS AND PROCESSES3

ACCOUNTING SYSTEMS AND PROCESSES4Question 1Replacing cell references with name will help in automatically changing them to definedterms. It becomes essential for users to give name to cells for easing the correlation of statementsand understanding. Structure can be easily drawn by referring cells with names. Formula used insuch cells would make sense when they are named properly (Arcega et al., 2015).Question 2Negative numbers in bracket can be displayed by using minus or negative sign or byhighlighting with color such as red. This is done for indicating and flagging up that figures usedhere is of negative value. Accountant displays negative numbers in brackets because they want torepresent outflow of cash from business or credit of cash into any particular account (Hui &Chang, 2016).

ACCOUNTING SYSTEMS AND PROCESSES5Question 3:Separation of spreadsheet into data entry area and report area is of great help toaccountants as well as users for minimizing the errors that is involved in financial study. One ofthe significant mechanism is designing the spreadsheet that ensures long and short-term successto organization and its business. Process of decision-making is enhanced in business as it haspower of enhancing, analyzing, providing, and parallel flexibility to operations of business.Separation would help in generating appropriate and correct information to users. Systematicentering of data is enhanced by creating separation and is regarded as an important tool (Watts etal., 2014).

ACCOUNTING SYSTEMS AND PROCESSES6Question 4:If function facilitates logical comparing between what is expected by users and between avalues and is one of the most popular excel function. Under this function, users set a commandand if the command sets were met with conditions, this would give logical justification. Thereare one value for each result that is true and false result (Liu, 2015). PERIODParticularsAmountRemarksSeptember'17Sales Revenue, less,Total Expenses43200=IF(C7>0,"NETPROFIT","NET LOSS")September'17Sales Revenue, less,Total Expenses-21908=IF(C8>0,"NETPROFIT","NET LOSS")

End of preview

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

Related Documents
Accounting Systems & Processes
|25
|1311
|33

Report on Accounting Systems and Processes
|29
|1869
|36

Accounting Systems and Processes
|29
|1711
|129

Accounting Systems & Processes | Assignment
|26
|1455
|46

ACC539 - Accounting Information Systems
|27
|1903
|135

Accounting Systems and Processes : Assignment
|27
|1538
|44