logo

ACC539 - Accounting Information Systems

   

Added on  2019-10-30

27 Pages1903 Words135 Views
Running head: ACCOUNTING SYSTEMS AND PROCESSESAccounting systems and ProcessesName of the Student:Name of the University:Author Note:

2ACCOUNTING SYSTEMS AND PROCESSESTable 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

3ACCOUNTING SYSTEMS AND PROCESSES

4ACCOUNTING SYSTEMS AND PROCESSESQuestion 1Naming cells in spreadsheets In this question, it is required to discuss naming cells in spreadsheets. Here, cellreferences are often replaced by names so that it is easy for understanding purpose as well ascorrelating with the statement or in those case calculations (Zhang & Ni, 2016). Below is theexample of how to name cells in spreadsheets with proper justification:Calculation of Gross Profit:-ParticularsAmountSales Revenue$15000 Less: Cost of Goods Sold$2000 GROSS PROFIT$13000 Question 2Negative numbers In this question, it is required to explain about negative numbers and how it is presentedin a spreadsheet (Song & Joo, 2015). The negative numbers are presented in bracket andhighlighted by red as shown in the below example:

5ACCOUNTING SYSTEMS AND PROCESSESQuestion 3Separation of data and report areas It is important for an accountant to design spreadsheets with completely separate dataentry area and separate report area for minimize errors in the financial study. The design ofstructure of spreadsheet can be termed as one of the significant mechanisms to ensure its successboth in terms of short-term and long-term. Spreadsheets help in providing unparalleled flexibilityas well as power for analyzing, enhancing, optimizing level of performance and decision-makingprocess in and across business enterprise. Spreadsheets can pose tremendous risks if it generatesincorrect information and leads to poor decisions. These risks can be eliminated by followingsignificant design as well as developmental practices (Reimers, 2013). Spreadsheet is animportant tool that makes the work easier to enter entries in systematic way under separatecolumns and this is done at the time of recording of stocks.

6ACCOUNTING SYSTEMS AND PROCESSESQuestion 4IF functions In this particular question, it is required to understand IF Statement or IF function that isalso known as logical function. By using this function, the user can set a command foridentifying whether any conditions are properly met or not. In that case, if the condition matcheswith the command, then outcome would be as per the logical value. On the contrary, if thecondition fails to match with the command, then the outcomes would be different from thelogical value (Odar, Kavčič & Jerman, 2015). PERIODParticularsAmountRemarksJan'16Sales Revenue, less,Total Expenses22000=IF(C7>0,"NETPROFIT","NET LOSS")Feb'16Sales Revenue, less,Total Expenses-10000=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 and Processes : Assignment
|27
|1538
|44

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

Accounting Systems & Processes
|25
|1311
|33

Accounting Systems and Processes
|28
|1766
|161

Accounting Systems & Processes Assignment
|29
|2058
|36

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