Accounting Systems and Processes

Running head: ACCOUNTING SYSTEMS AND PROCESSES
Accounting systems and Processes
Name of the Student:
Name of the University:
Author Note:

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

ACCOUNTING SYSTEMS AND PROCESSES
3

ACCOUNTING SYSTEMS AND PROCESSES
4
Question 1:
Replacing of cell references with names helps user in defining and providing them with
accurate and appropriate information. Incorporated formula used in the cells becomes
meaningful only when they are named (Jia & Sun, 2015). This helps in creating a proper
correlation between various listed items.
Question 2:
Using minus sign and highlighting the figures with particular color such as red or green
will help in displaying negative numbers in bracket. Negative numbers are general displayed in
brackets by accountant because to show some unfavorable variances and making some credit
entries in any particular account (Averinà et al., 2014).

ACCOUNTING SYSTEMS AND PROCESSES
5
Question 3:
It is certainly possible that error can be incurred while performing financial study. Separation of
spreadsheets into report area and data entry areas would ease users and prevent them from
committing any errors. Separation of area would help in systematic entry of data and the
accuracy of information is depicted in the report area.

ACCOUNTING SYSTEMS AND PROCESSES
6
Question 4:
IF function is one the most popular function that is incorporated in Excel that make use of
logical test and facilitates logical comparison. There are two results obtained by performing IF
function that is the result and false result.
PERIOD Particulars Amount Remarks
September'17
Sales Revenue, less,
Total Expenses 54600
=IF(C7>0,"NET
PROFIT","NET LOSS")
September'17
Sales Revenue, less,
Total Expenses -43700
=IF(C8>0,"NET
PROFIT","NET LOSS")