University Name and ID Assignment Task Number

Running head: ACCOUNTING INFORMATIONSYSTEM
Accounting information system
Name of the University
Subject code and name
Student Name and ID
Assignment Task Number
Author Note

1ACCOUNTING INFORMATION SYSTEM
Table of Contents
Answer 1:................................................................................................................................................3
Answer 2:................................................................................................................................................3
Answer 3:................................................................................................................................................4
Answer 4:................................................................................................................................................4
Answer 5:................................................................................................................................................5
Answer 6:................................................................................................................................................5
Answer 7:................................................................................................................................................7
Answer 8:................................................................................................................................................9
Answer 9:..............................................................................................................................................10
Answer 10:............................................................................................................................................10
Answer 11:............................................................................................................................................10
Answer 12:............................................................................................................................................11
Answer 13:............................................................................................................................................11
References:............................................................................................................................................14

2ACCOUNTING INFORMATION SYSTEM
Answer to question 1:
Naming the cells under the spreadsheet enables the users to use it as per their preference or
requirement (Baños-Caballero, García-Teruel & Martínez-Solano, 2014). For instance, the data in the
cells can be updated, edited or formatted. Further, it can be used for auditing and calculation.
Answer 2:
Negative numbers are expressed with minus symbol, parentheses or with red colour within
brackets. It can be expressed as above by selecting the negative number from the number or currency
option after selecting the cell range. Instead of showing the negative number with minus symbol, it is
shown with red colour and within bracket to represent the data more clearly and make it more visible.
Example showing the negative numbers within bracket is shown below –

3ACCOUNTING INFORMATION SYSTEM
Answer 3:
As the worksheet hold raw data as well as the data after it is processed, the user will not be
able to differentiate the data after and before processing. Therefore, expressed it through different
area for the data and for the report is a better way of presentation.
An instance where the data are shown in under both areas is as follows –

4ACCOUNTING INFORMATION SYSTEM
Answer 4:
IF function provides the user with the data that tells about the fulfillment of criteria;
Generally, IF function provides the results in two forms that is ‘TRUE’ and ‘FALSE’. TRUE
represents the positive result whereas FALSE represents negative results.
Instance of IF function with result – Normal view

5ACCOUNTING INFORMATION SYSTEM
IF functions - formula view
Answer 5:
Periodic systems of the inventory:
Under this system, it is unlikely to maintain and document the updated records for each
transaction of buy and sold. Through one entry the record is updated at the closing of the period.
The instance is given below -
Answer 6:
Fancy Footwear- Adjusted spreadsheet as normal view: