Past Semester Ais 280
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 :
i) Answer PART A in the Objective Answer Sheet. 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
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 :
i) Answer PART A in the Objective Answer Sheet. 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