Unit 14 Computerised Accounting
Practice questions
Made-up data: for two days' sales in B2 = 450 and C2 = 380, which formula returns TRUE?
- =AND(B2>=400,C2>=400)
- =OR(B2>=500,C2>=500)
- =AND(B2>=500,C2>=300)
- =OR(B2>=400,C2>=400)
Answer and explanation
Answer: D
OR is TRUE if any condition holds: B2 = 450 is at least 400. The AND formulas fail because one value is below its limit, and the first OR fails because neither reaches 500.
Made-up data: a computer costs ₹60,000 plus ₹4,000 installation; salvage ₹4,000; life 4 years. Annual depreciation by SLN is:
- ₹14,000
- ₹16,000
- ₹15,000
- ₹15,500
Answer and explanation
Answer: C
Total cost = 64,000. SLN = (64,000 − 4,000) ÷ 4 = 60,000 ÷ 4 = ₹15,000.
Made-up data: B2:B5 hold 300, 750, 1,200, 450. What does =COUNTIF(B2:B5,">400") return?
- 2
- 3
- 4
- 1
Answer and explanation
Answer: B
Values above 400 are 750, 1,200 and 450: three cells.
Abbreviations such as 'CB' for cash book, which remind the user of their meaning, are:
- block codes
- sequential codes
- access codes
- mnemonic codes
Answer and explanation
Answer: D
Mnemonic codes use letters or abbreviations as memory aids.
Which accounting equation does the textbook use to group accounts?
- Assets = Liabilities + Capital + (Revenues − Expenses)
- Assets = Capital − Liabilities
- Capital = Assets + Liabilities
- Revenues = Assets − Expenses
Answer and explanation
Answer: A
The grouping follows Assets = Liabilities + Capital + (Revenues − Expenses), giving four major heads.
Which type of software has the highest training requirement, according to the textbook's comparison?
- Readymade
- Tailormade
- Customised
- All are the same
Answer and explanation
Answer: B
Training is low for readymade, medium for customised and high for tailormade software.
Made-up case: an entry of ₹3,600 is keyed in as ₹6,300. Which statement is correct?
- The trial balance will fail to agree by ₹2,700
- A CAS always catches such errors
- Both accounts show ₹6,300 and the trial balance still agrees
- The error is one of carrying forward
Answer and explanation
Answer: C
The software posts the wrong amount to both sides, so the trial balance agrees. A CAS removes copying and totalling errors, not input errors.
A computer cannot judge or detect errors that no one anticipated. In the textbook this is a:
- limitation of CAS
- feature of CAS
- component of CAS
- type of code
Answer and explanation
Answer: A
'Unanticipated errors not known' is listed among the limitations: unlike people, computers cannot use judgement.
Which is an advantage, not a limitation, of CAS?
- Fear of unemployment
- Health dangers
- Disruption of work
- Up-to-date information
Answer and explanation
Answer: D
Balances are updated automatically as entries are made, so information is always up to date. The others are limitations.
Which component of CAS allows two branches to share one printer and one set of files?
- Procedure
- Connectivity
- Data
- Software
Answer and explanation
Answer: B
Connectivity is the linking of computers so they can share files, printers and facilities like the internet.
The textbook calls the users of a computer system its:
- hardware
- connectivity
- live-ware
- firmware
Answer and explanation
Answer: C
People are the most important element; the textbook calls them the live-ware of the computer system.
Windows is an example of:
- an operating system
- application software
- utility software
- programming software
Answer and explanation
Answer: A
The textbook lists DOS, Windows and Ubuntu as operating systems, a kind of system software.
A business's head office wants to see branch accounts from another city as they are entered. Which feature of CAS does this use?
- Scalability
- Reliability
- Versatility
- On-line facility
Answer and explanation
Answer: D
On-line facility lets data be stored and processed so that reports can be viewed from any part of the world.
Which of these is NOT a report that a computerised accounting system generates from the entries?
- Trial balance
- Ledger
- The proprietor's personal diary
- Balance sheet
Answer and explanation
Answer: C
A CAS produces day books, ledger, trial balance and final accounts from accounting entries; a personal diary is not an accounting report.
Processed and useful data that can be used for decisions are called:
- programs
- information
- procedures
- hardware
Answer and explanation
Answer: B
Data are raw facts; once processed into a useful form they become information.
For a loan repaid in monthly instalments at 9% a year, the rate argument in PMT should be:
- 9%
- 9%×12
- 9%/12
- 12/9%
Answer and explanation
Answer: C
The rate must match the payment period. Monthly payments need the monthly rate, 9% ÷ 12 = 0.75%.
A cell holds 46. What does =IF(A1>=50,"Pass","Fail") show?
- Pass
- Fail
- TRUE
- 46
Answer and explanation
Answer: B
46 is not greater than or equal to 50, so the test is false and IF returns the second value, Fail.
Made-up data: a machine costs ₹1,20,000, salvage value ₹20,000, life 8 years. =SLN(120000,20000,8) returns:
- ₹15,000
- ₹17,500
- ₹10,000
- ₹12,500
Answer and explanation
Answer: D
SLN = (cost − salvage) ÷ life = (1,20,000 − 20,000) ÷ 8 = 1,00,000 ÷ 8 = ₹12,500.
Made-up data: cells A1:A6 hold 120, 450, 'Cash', 980, blank, 1,250. What do =COUNT(A1:A6) and =COUNTA(A1:A6) return?
- 5 and 5
- 4 and 6
- 4 and 5
- 3 and 5
Answer and explanation
Answer: C
COUNT counts cells with numbers: 120, 450, 980, 1,250 = 4. COUNTA counts non-empty cells: those four plus 'Cash' = 5; the blank cell is not counted.
In MS Word, the shortcut to justify a paragraph is:
- Ctrl+J
- Ctrl+E
- Ctrl+L
- Ctrl+5
Answer and explanation
Answer: A
Ctrl+J justifies, Ctrl+E centres, Ctrl+L aligns left, and Ctrl+5 sets 1.5 line spacing.