WorksheetsSPECTRUM THEORY QUIZ-3
Total questions: 20
Worksheet time: 10mins
The document issued when a sale occurred is______
Sales invoice
Voucher
Receipt
A source document is
The origin of the information that is recorded in to the accounting books
The origin of the information that is not recorded in to the accounting books
None of these
The only long term asset that does not depreciate is
Building
Land
Trademark
Credit note issued when _______
The seller delivers the goods to the purchaser
Goods are returned to the seller by the purchaser
None of these
Cost that are incurred during the period and are both unpaid and unrecorded are called
Prepaid expenses
Deferred expenses
Accrued expenses
Which of these is not an accounting document
Cashbook
Invoice
Deposit slip
Gross Profit=
Sales-Cost of Goods Sold
Cost of Goods Sold-Sales
Sales-Purchase
As per Income Tax Act accounting period is
1st Jan- 31st Dec
1st Apr- 31st March
1st July - 30th June
According to Principles of Conservatism
Depreciation is charged on assets
Provision is made for bad and doubtful debts
All of the above
Which principle states qualitative transactions are not recorded in the books of accounts
Business entity concept
Money measurement
Dual aspect
The order in which current assets should be shown in Balance sheet is
Stock, Bank, Cash, Sundry debtors
Cash, Bank, Sundry debtors, Stock
Bank, Cash, Stock, Sundry debtors
Rate of Depreciation on Computer accessories
10%
40%
30%
Gross profit ratio=
Gross profit/Sales*100
Sales/Gross profit*100
Gross profit/Cost of goods sold*100
Working Capital= Current Assets-Current Liabilities
True
False
Managerial commission will be treated as an outstanding expenses and should be shown in
Asset side of Balance sheet
Liability side of Balance sheet
Credit side of P&L
Which of the following is a text function in MS Excel
SUM
Hyperlink
CONCATENATE
In MS Excel we can secure a worksheet by_____ option
Security control
Vault password
Protect Sheet
Which one is not a function in MS Excel
SUM
AVG
MAX
Which function is used for counting alpha numeric except blank cells in excel
COUNT
COUNT A
COUNT N
HOW WILL YOU HIGHLIGHT DUPLICATE VALUES IN A COLUMN IN MS EXCEL
VIEW-> DUPLICATE VALUES
FORMAT -> DUPLICATE VALUES
CONDITIONAL FORMATING-> DUPLICATE VALUES
