Accounting Systems and Processes : Assignment

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

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

3
ACCOUNTING SYSTEMS AND PROCESSES

4
ACCOUNTING SYSTEMS AND PROCESSES
Question 1
Naming cells in spreadsheets
According to the question, naming cells in spreadsheets refers to cell references that are
frequently substituted by names so that it becomes easier to understand the purpose and correlate
with the given statement or calculations. The example given below shows how cells are named in
spreadsheets with proper explanation:
Calculation of Gross Profit:-
Particulars Amount
Sales Revenue 20000
Less: Cost of Goods Sold 5000
GROSS PROFIT 15000
Question 2
Negative numbers
The requirement of this question is to elucidate about the negative numbers and its
presentation in the spreadsheet. The figure below reflects that the negative figures are given in
brackets and is highlighted in red :

5
ACCOUNTING SYSTEMS AND PROCESSES
Question 3
Data separation and report areas
It is vital for an accountant to draw spreadsheets with entirely separate data entry as well
as report area in order to minimize errors in the study. The outline of spreadsheet structure can be
defined as one of the important mechanism for ensuring its success in short –term as well as in
long-term (Weil et al., 2013). Spreadsheets facilitates in offering unparalleled flexibility and
power to analyze, increase and optimize performance level and process of decision-making in the

6
ACCOUNTING SYSTEMS AND PROCESSESbusiness organization. Moreover, it poses huge risk if incorrect information is generated and thus
leading to bad decision. This risk could be eradicated by noteworthy design and developmental
practices. Hence, it is considered as a vital tool that helps in making work simpler in entering
systematic entries under separate colomns.
Question 4
IF functions
The requirement of this question is to comprehend IF statement or function, which is also
termed as logical function. The user sets the command by applying this function in order to
identify whether particular conditions are appropriately met. However, if the said condition
relates with given command , then the result will be according to logical value. On the other
hand, if the condition as well as command does not match with each other, then the results varies
from logical value.