logo

Accounting Information System

34 Pages2547 Words259 Views
   

Added on  2019-10-31

Accounting Information System

   Added on 2019-10-31

ShareRelated Documents
Running head: ACCOUNTING INFORMATION SYSTEMAccounting Information SystemName of the Student:Name of the University:Course Code:
Accounting Information System_1
1 ACCOUNTING INFORMATION SYSTEMAnswer to Question 1Cell Name
Accounting Information System_2
2 ACCOUNTING INFORMATION SYSTEMAnswer to Question 2Negative Value
Accounting Information System_3
3 ACCOUNTING INFORMATION SYSTEMAnswer to Question 3The spreadsheet is divided into two halves- first half denotes the data area and the second halfcontains report along with the formulae. The excel sheet contains data list listed in a sequence where thedata has been written, on the other hand all the calculations done on the basis of data which is collectedby a person applies different formulae (Hall, 2012). Use of IF function is done in the report area.Therefore, by changing the data in the first half, all the calculations are done in the report area of thesheet.This can be explained by an example such as, expense data and sales data are given in the dataarea with its respective values. However, if a person wants to calculate the net income based on theprovided data, then he has to add one column by using formula which can be done very easily. Thefollowing method is depicted in the screenshots given below:
Accounting Information System_4
4 ACCOUNTING INFORMATION SYSTEMStep 1
Accounting Information System_5
5 ACCOUNTING INFORMATION SYSTEMStep 2
Accounting Information System_6
6 ACCOUNTING INFORMATION SYSTEMAnswer to Question 4IF Function
Accounting Information System_7
7 ACCOUNTING INFORMATION SYSTEMThere are number of YouTube video which shows the actual functionality of the IF function andwhere it can be used. According to the video, IF function portrays a particular scenario made in the tableof data which shows the results if it is true or not. The above mentioned YouTube channel is clearlyshowing the complete functionality of IF with the help of a cursor.Answer to question 5Periodic systemsSystem which updates the inventory after the end of a particular time period is called PeriodicInventory System. This system of inventory monitoring keeps track of the details of goods in an inventoryof a fixed period (Drury, 2013). There is no need to keep the records of every data which is updated forthe inventory and also the prices of goods which are sold. By the help of this system accounting is done asit helps in the journal entries of a specified period of time.
Accounting Information System_8

End of preview

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

Related Documents
Assignment Accounting Systems and Processes
|32
|2765
|33

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

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

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

Accounting System and Process - Assignment
|18
|1449
|30

(Solved) Accounting System and Process- Assignment
|18
|2992
|39