# Past Semester Ais 280

Topics: Depreciation, Expense, Cash flow Pages: 20 (2166 words) Published: January 25, 2012
CONFIDENTIAL AC/SEP 2011/AIS280/CAC230
UNIVERSITI TEKNOLOGI MARA
FINAL EXAMINATION
COURSE
COURSE CODE
EXAMINATION
TIME
COMPUTERIZED ACCOUNTING/ COMPUTERISED
ACCOUNTING
AIS280/CAC230
SEPTEMBER 2011
3 HOURS
INSTRUCTIONS TO CANDIDATES
1. This question paper consists of four (4) parts : PART A (20 Questions) PART B (3 Questions)
PART C (3 Questions)
PART D (2 Questions)
2. Answer ALL questions from all four (4) parts :
ii) Answer PART B, C and D in the Answer Booklet. Start each answer on a new page. 3. Do not bring any material into the examination room unless permission is given by the invigilator.
4. Please check to make sure that this examination pack consists of: i) the Question Paper
ii) an Answer Booklet - provided by the Faculty
iii) an Objective Answer Sheet - provided by the Faculty
DO NOT TURN THIS PAGE UNTIL YOU ARE TOLD TO DO SO
This examination paper consists of 14 printed pages
© Hak Cipta Universiti Teknologi MARA CONFIDENTIAL
CONFIDENTIAL 2 AC/SEP 2011/AIS280/CAC230
PART A
This part consists of 20 multiple-choice questions. Choose the most suitable answer and shade the corresponding alphabet representing the answer in the Objective Answer sheet provided.
1. Which of the following statements about relative cell referencing is INCORRECT? a. It changes automatically when copying cell formula from one cell location to another location.
b. It is usually denoted by this sign "=" or"+".
c. It is useful since it saves our time from typing the same data or formula into different location.
d. It can also occur when a cell is entered in a formula using the \$ symbol. 2. Cell B1 and B2 shows a value of 20 and 30 respectively. What is the best formula to total the values in cell B3?
a. =B20+B30.
b. =B1+B2.
c. =\$B\$1+\$B\$2.
d. =B\$20+B\$30.
3. The formula =IF(OR(condition 1, condition 2, condition 3), 'YES', "NO") will give the result .
YES if condition 1 and 2 are met.
i. NO if condition 2 and 3 are met.
ii. YES if all the conditions are met.
v. NO if all the conditions are not met.
a.
b.
c.
, ii and iii
i, iii and iv
, iii and iv
d. All of the above
4. In Excel the '*' symbol is considered as a
a. Label
b. Text
c. Number
d. Formula
© Hak Cipta Universiti Teknologi MARA CONFIDENTIAL
CONFIDENTIAL 3 AC/SEP 2011/AIS280/CAC230
5. The following description relates to which type of logical function? • It has only one condition to test;
• If the condition is not met, the outcome is true; and
• If the condition is met, the outcome is false
a. AND function.
b. OR function.
c. NOT function.
d. ROUND function.
Questions 6 and 7 are based on Figure 1 below:
A B c D L F G
ADJUSTED TRIAL BALANCE AS AT 31 AUGUST 2011
Freehold Land
Motor Vehicles
Accumulated Depreciation - Motor Vehicle
Sales
Rent
Telephone
lEIectricity
Purchases
Stationery
Bank overdraft
Capital
Debtors
Creditors
Inventory
Accrued Rent
Depreciation - Motor Vehicles
Closing Inventory
Opening Inventory
Doubtful debts
Provision for Doubtful debts
TRIAL BALANCE
Debit
(RM)
400,000
600,000
253,600
240,000'
96,000
59,600
18,600
340,000
22,400
15,200
30,000
2,075,400
Credit
(RM)
240,000
832,000
142,000
760,000
101,400
2,075,400
Debit Credit
(RM) (RM)
72,000 (b)
1,200 (a)
28,300 (d) 30,000 (e)
1,200 (a)
72,000 (b)
28,300 (d)
30,000 (e)
760 (f)
760 (f)
132,260 132,260
H I
Debit
(RM)
400,000
600,000
254,800
240,000
96,000
59,600
18,600
340,000
22,400
15,200
28,300
72,000
30,000
760
2,177,660
Credit
(RM)
312,000
832,000
142,000
760,000
101,400
1,200
28,300
760
2,177,660
Figure 1
6. The following statements are correct about the data inserted in cell D10, EXCEPT a. it represents accrued rent for the period
b. it will be transferred to the balance sheet under current asset c. it will be...