TEST 1 - 16 JAN 2021 (AIS 160) PDF

Preview

Summary

Download TEST 1 - 16 JAN 2021 (AIS 160) PDF

Description

TEST AIS205 16 JANUARY 2021 (SATURDAY) 2.30PM- 4.00PM SECTION A 1. These aren’t the roles of accountants in Accounting Information System EXCEPT a. b. c. d.

System Engineers System Software System Auditors System Planners

2. Which statement about the accounting records used in computer-based transaction processing is CORRECT a. Transaction file as a temporary file holding transaction records that will be used to update in a master file b. Archive file contains records of current transactions that are retained for future references c. Master file contains data that are used as standards for processing transactions d. Reference file contains all account data that had been needed by the users 3. Components of Accounting Information system (AIS) and steps in accounting cycle are stated below i) ii) iii) iv)

Processes - Analyse transaction Processes - Transactions Processes – Journalise transactions Processes – Post journal to ledger

Which is CORRECT a. b. c. d.

I, ii and iii I, ii and iv I, iii and iv All of the above

4. An Excel file is called a ___________ a. b. c. d.

Cell reference Workbook Worksheet File Sheet

5. What is the CORRECT formula to record the date January 16 2021 in cell D4 using the DATE function? a. b. c. d.

=DATE(16,1,2021) =DATE(2021,1,16) =DATE(2021+1+16) =DATE(2021;1;16)

6. Identify the logical function to calculate the inventory valuation based on FIFO method. a. b. c. d.

NOT OR AVERAGE IF

7. Which of the following are CORRECT about AND function? a. b. c. d.

It can be test up to maximum of 20 conditions If all the conditions are not met, the outcome is false If any one or more of the conditions is/are met, the outcome is false If any one or more of the conditions is/are met, the outcome is true

8. A function inside another function is called a __________ a. b. c. d.

NESTED ROUND TEXT AVERAGE

Questions 9 and 10 based on the information in Table 1 A 1 2 3 4 5 6 7 8 9

B Selling price/unit Variable cost/unit Total Fixed Cost

No of units 1,000 2,000 3,000

Fixed Cost 60,000 60,000 60,000

C RM 70 30 60,000

D

E

F

Variable cost 30,000 60,000 90,000 Table 1

Total costs 90,000 120,000 150,000

Total sales 70,000 140,000 210,000

Profit/Loss 20,000 20,000 60,000

9. Identify the CORRECT formula in cell A9. a. b. c. d.

=A8+1000 =A8-1000 =A7*1000 =A7+1000

10. Identify the CORRECT formula in cell C7 and F8 a. b. c. d.

=A7*C3 =A7*C2 =A7*C3 =A7+C3

=E8-D8 =D8-E8 =D8-E8 =E8-D8

SECTION B This section consists of TRUE/FALSE questions. State (T) if the answer is true and (F) is the answer is false in the answer booklet. 1. Any formula that contains cells in specific cell address should be assigned with the relative cell referencing. 2. A spreadsheet is a large accounting ledger page with many columns and rows that shows various quantitative information useful for managing a business. 3. The highlighted or selected cell is called an interactive cell. 4. Data can be either text or values. Once you enter a text in a cell, it will be left-aligned. 5. =IF function is used to checks whether all arguments are TRUE, and written TRUE if all arguments are TRUE.

SECTION C 1. Apek Sdn Bhd needs your assistance as an accounting technician to make a decision whether he should continue to trade with these two customers.

1 2

A Name of Customers

B Duration (months)

C Average Procurement (RM)

D Outcome (Yes/No)

QuratulAini Batrisya

12 8

10,000 6,000

YES NO

Conditions: i) ii)

The customer must have traded with the company for more than six (6) months and The customer must procure goods for more than RM9,000 on average

a) Briefly explain an appropriate function used in cell D1 b) Briefly explain to Apek Sdn Bhd, why the answers in cell D1 and D2 differ c) Stated the formula using EXCEL software in cell D1 (5 marks) 2. Apek Sdn Bhd decided to use UBS software in expediting his business transactions process. As an accounting technician, please assists him due to the errors occurred while using the system. i)

A cash sales transaction of RM550 keyed twice in batch number 2. (3 marks)

ii)

Purchase of office equipment transaction of RM1,520 in batch number 5 was wrongly keyed in as RM1,250 both debit and credit side (3 marks)

3. Please assists Apek Sdn Bhd in assigning the account number, account type and special account for each of the accounts stated in order to generate the report as shown below. i) ii) iii) iv)

Telephone expenses Aminah Sdn Bhd as customer to Apek Sdn Bhd Raniya Sdn Bhd as supplier to Apek Sdn Bhd Purchase Raw Materials (4 marks)

END OF QUESTION...