Skip to main content
    Accounting Technician Qualification

    ATQ for Students

    Short Khmer lessons that follow the KICPAA study texts page by page, with the English accounting terms you will meet in the exam. Each lesson asks one question, answers it, works one example and ends with your turn.

    • TQ1 first
    • 2–5 minute lessons
    • Khmer voice · Khmer or English subtitles
    • Riels as printed in the textbook

    These lessons add to your formal studies; they don't replace them. Keep going to class, reading your textbook, doing the practice exercises and taking notes.

    Not an official KICPAA course: check KICPAA for current exam rules. Read KICPAA’s subject specifications ↗

    Four steps

    How each lesson works

    1. 1. Watch · 2–5 min

      One question, one rule from the textbook, one worked example.

    2. 2. Your turn

      One fact changes. You answer first, then check the practice card.

    3. 3. Check yourself

      Try the exam-style questions where available and read the reason for each answer.

    4. 4. Review

      Questions you miss come back: next lesson, chapter set, mixed reviews.

    First subject

    TQ1 · Bookkeeping, controls and accounting

    Study text: Emile Woolf, December 2019 · 10 chapters

    Start here · 7 lessons on how the course works, your study plan and the textbook0 of 7 done
    Start here
    LessonStatus
    1 · Study the chapters in textbook orderWelcome to ATQ for Students. Before Chapter 1, one question: in what order should you study the chapters?Continue
    2 · Try first, then checkEvery lesson stops at a pause called Your turn. What should you do in that pause?About 2 min
    3 · Make a weekly study planTQ1 has ten chapters and twelve short revision lessons. How do you plan your study?About 2 min
    4 · Keep a practice logAfter each practice set, what should you write in your practice log?About 2 min
    5 · Write your workingsWhen you answer a calculation, is the final number enough?About 2 min
    6 · Khmer explanations, English termsThe lessons speak Khmer, but the screen shows English words such as Receivables. Which should you learn?About 2 min
    7 · Working papers and the evidence trailWhen you record a transaction in a practice case, what should your working paper show?About 3 min

    Chapter 1 · An introduction to business and accounting

    11 lessons · about 22 minutes · recap card · 20-question practice set · printed pp 1–15

    0 of 11 done
    TQ1 Chapter 1
    LessonQuizStatus
    1 · Bookkeeping and accountingWhat is bookkeeping, and how does it fit into accounting?–About 2 min
    1b · What a bookkeeper doesA shop hires its first bookkeeper. What does this person actually do?–About 2 min
    2 · Complete and accurate recordsWhy must the records be complete and accurate, even when an error is small?–About 2 min
    3 · ConfidentialityAs a bookkeeper, you see private information daily. Who are you allowed to tell?–About 2 min
    4 · What is a business transaction?What is a business transaction, and when should you record it?–About 2 min
    5 · Capital or revenue expenditureWhen a business spends money, how do you tell capital expenditure from revenue expenditure?–About 2 min
    6 · Revenue income or capital receiptMoney comes into the business. Is every receipt income?–About 2 min
    7 · Two financial statementsWhich financial statement shows what a business owns and owes on a particular day?–About 2 min
    8 · Current and non-currentHow do you decide whether an asset or liability is current or non-current?–About 2 min
    9 · Gross profit and net profitHow do you work out gross profit, and how does net profit differ?–About 2 min
    10 · The accounting equationWhat is the accounting equation, and why must it always balance?–About 2 min
    Recap cardThe company’s statement shows KHRm 5,000 cash. This textbook exercise isolates the equation effect of a cash purchase. Set aside how the company would fund the KHRm 65,000 payment for new equipment. What does the purchase itself do to the equation?–Card
    Practice set20 exam-style questions · answers after you submit · target 80%–After lesson 10

    Chapter 2 · Double entry bookkeeping

    14 lessons · about 28 minutes · recap card · 2 worked exam questions · 20-question practice set · printed pp 17–50

    0 of 16 done
    TQ1 Chapter 2
    LessonQuizStatus
    1 · Two accounts for every transactionA trader pays five million riels for a market stall. Which accounts change?–About 2 min
    2 · Debit on the left, credit on the rightThe entry is debit Bank, credit Capital, thirty million riels. Where does each go?–About 2 min
    3 · Which side increases?An unpaid electricity bill arrives. Which account do you debit, and why?–About 2 min
    4 · Business bank account · debit receipts, credit paymentsA credit customer pays eight million riels into the bank. Which side of Bank?–About 2 min
    4b · Goods for resale go to purchasesThe trader buys goods for resale on credit. Which account is debited?–About 2 min
    5 · Drawings are not an expenseThe owner takes four million riels for personal use. Is it an expense?–About 2 min
    6 · Closing off an accountBank debits total ninety million riels; credits, seventy-five million. What is the balance?–About 2 min
    7 · The trial balanceThe trader's ten accounts are closed off. How do they become a trial balance?–About 2 min
    8 · Writing a journal entryThe trader borrows forty million riels for a van. What does the journal show?–About 2 min
    9 · The chart of accountsThe business buys another warehouse. Which account code does the bookkeeper use?–About 2 min
    10 · The year-end cycleAt the year end, does the sales account's balance carry into next year?–About 2 min
    11 · Loan repayments and interestA loan payment includes interest. Is the whole payment an expense?–About 2 min
    12 · Issuing sharesA company issues new shares above their nominal value. How is the issue recorded?–About 2 min
    13 · Informal financeA relative lends two million riels, repayable in a year. Capital or loan?–About 2 min
    Recap cardUse the periodic Purchases-account method from this chapter. Goods for resale costing KHR 18 million are bought on credit. What is the double entry?–Card
    Worked exam question 1 · Finding a balancing figureAn exam-style question worked step by step, then a twin question for you–About 4 min
    Worked exam question 2 · Choosing the right journal entryAn exam-style question worked step by step, then a twin question for you–About 4 min
    Practice set20 exam-style questions · answers after you submit · target 80%–Last step
    Mixed review 1 · Chapters 1–2 · 15 questions, your mistakes first · No mistakes waitingAfter Chapter 2

    Chapter 3 · Sales and purchases

    13 lessons · about 26 minutes · recap card · 20-question practice set · printed pp 51–81

    0 of 13 done
    TQ1 Chapter 3
    LessonQuizStatus
    1 · Post a batch from the sales day bookThree credit sales total seven hundred and fifty thousand riels. How are they posted?–About 2 min
    2 · Keep the customer detail beside the control totalReceivables control shows seven hundred and fifty thousand riels. Which customers owe it?–About 2 min
    3 · A credit note reduces what the customer owesCustomer A returns five million riels of goods bought on credit. What changes?–About 2 min
    4 · Record the price after a trade discountA customer buys twenty bags with a trade discount. What is the sale?–About 2 min
    5 · Estimate the amount expected after an early-payment discountThe seller expects three per cent off an eighty-thousand-riel invoice. What is recorded?–About 2 min
    6 · Restore a receivable when a cheque is dishonouredA customer's forty-million-riel cheque is refused by the bank. What do you record?–About 2 min
    7 · Analyse the supplier invoice before postingA supplier batch totals fourteen thousand six hundred million riels. How is it posted?–About 2 min
    8 · Debit payables for a return to a supplierThe business returns twenty thousand million riels of goods to a supplier. What changes?–About 2 min
    9 · Account for a discount received when you pay earlyA buyer pays early for three per cent off. How is the debt cleared?–About 2 min
    10 · Reconcile the payables control to supplier balancesCredit purchases are one hundred and eighty thousand million riels. What reduces Payables control?–About 2 min
    11 · Offset agreed amounts owed both waysA supplier also owes us fifty million riels. How are the debts offset?–About 2 min
    12 · Read the reason for each cash receiptOf one hundred and eighty-three thousand five hundred million received, what is sales?–About 2 min
    13 · Show the card sale and fee separatelyThe card company keeps one thousand riels of a one-hundred-thousand-riel sale. What is recorded?–About 2 min
    Recap cardUse the textbook's four-customer batch. Credit sales are KHRm 140, made up of A 40, B 50, C 30 and D 20. Customer A returns KHRm 5 of goods. Customers B and C pay KHRm 40 and 20. Identify the three prime-entry records and complete the general ledger and customer list.–Card
    Practice set20 exam-style questions · answers after you submit · target 80%–After lesson 13

    Chapter 4 · Inventory

    8 lessons · about 16 minutes · recap card · 20-question practice set · printed pp 83–101

    0 of 8 done
    TQ1 Chapter 4
    LessonQuizStatus
    1 · Work out the cost of goods soldTwelve million riels of goods are unsold at year-end. What is cost of sales?–About 2 min
    2 · Replace opening inventory with the closing assetAt year-end the count values closing inventory at twelve million riels. What entries follow?–About 2 min
    3 · Keep a running inventory account in the perpetual methodGoods costing thirty million riels arrive under the perpetual method. Where are they recorded?–About 2 min
    4 · Build the cost of inventoryDelivery to the warehouse costs five million riels. Is it part of inventory cost?–About 2 min
    5 · Compare cost and NRV for each inventory lineAn item costing eight thousand million riels sells for less. How is it valued?–About 2 min
    6 · Record goods taken by the owner at costGoods costing two million riels go home with the owner. Is that a sale?–About 2 min
    7 · Add profit to capital and deduct drawingsThe owner's drawings are six million riels this year. How does closing capital change?–About 2 min
    8 · Clear income and expense accounts at year-endSales shows twenty-three million riels at year-end. Where is it transferred?–About 2 min
    Recap cardUse the p 88 trader. Opening inventory is KHRm 10, purchases 30 and closing inventory at its assessed carrying amount 12. Work out cost of sales and write the periodic entries that leave the correct inventory asset.–Card
    Practice set20 exam-style questions · answers after you submit · target 80%–After lesson 8
    Mixed review 2 · Chapters 1–4 · 15 questions, your mistakes first · No mistakes waitingAfter Chapter 4

    Chapter 5 · Bad and doubtful debts

    8 lessons · about 16 minutes · recap card · 20-question practice set · printed pp 103–119

    0 of 8 done
    TQ1 Chapter 5
    LessonQuizStatus
    1 · Bad debts and doubtful debtsOne customer has cash-flow trouble but could still pay. Bad or doubtful debt?–About 2 min
    2 · Write off an irrecoverable debtFifteen million riels owed by a customer is confirmed irrecoverable. What entry removes it?–About 2 min
    3 · Recover a debt already written offFifteen million riels arrive for a debt already written off. How is it recorded?–About 2 min
    4 · Keep a doubtful debt and record an allowanceA fire makes a customer's seventy-five thousand riels doubtful. Do we remove the debt?–About 2 min
    5 · Charge the change in the allowanceAn allowance of twenty thousand riels must become twenty-four thousand. What is charged?–About 2 min
    6 · Combine specific and general allowancesOne customer's seventy-five thousand riels is doubtful. How is the total allowance built?–About 2 min
    7 · Collect a doubtful debt still in the ledgerA doubtful customer pays its two thousand riels in full. What is recorded?–About 2 min
    8 · Use an aged receivables analysisPart of a customer's balance is over ninety days. Which invoices need attention?–About 2 min
    Recap cardWhich figures belong in receivables, the allowance and the expense?–Card
    Practice set20 exam-style questions · answers after you submit · target 80%–After lesson 8

    Chapter 6 · Accruals and prepayments

    8 lessons · about 16 minutes · recap card · 20-question practice set · printed pp 121–137

    0 of 8 done
    TQ1 Chapter 6
    LessonQuizStatus
    1 · Recognise an expense in the period it relates toRent of two hundred and forty thousand riels spans two financial years. Which year?–About 2 min
    2 · Tell an accrual from a prepaymentSix million riels of telephone use is unbilled at year end. Accrual or prepayment?–About 2 min
    3 · Estimate the cost of a service already usedA nine-million-riel invoice is expected for November to January. What is accrued?–About 2 min
    4 · Reverse an accrual in the two-account methodUnder the two-account method, a six-million-riel accrual opens the year. What is recorded first?–About 2 min
    5 · Carry accruals through one expense accountPayments total thirty-nine million riels, with opening and closing accruals. What is the expense?–About 2 min
    6 · Calculate an insurance prepaymentInsurance of two point four million riels covers March to February. What is prepaid?–About 2 min
    7 · Record and reverse a prepaymentThe whole two point four million premium is expensed. What is the adjustment?–About 2 min
    8 · Carry prepayments through one expense accountWith four hundred thousand riels prepaid and three million paid, what is the expense?–About 2 min
    Recap cardHow do a closing accrual and a closing prepayment change unadjusted profit?–Card
    Practice set20 exam-style questions · answers after you submit · target 80%–After lesson 8
    Mixed review 3 · Chapters 1–6 · 15 questions, your mistakes first · No mistakes waitingAfter Chapter 6

    Chapter 7 · Depreciation

    6 lessons · about 12 minutes · recap card · 20-question practice set · printed pp 139–151

    0 of 6 done
    TQ1 Chapter 7
    LessonQuizStatus
    1 · When to depreciate a non-current assetEquipment costing three million riels will serve four years. Is it all expensed now?–About 2 min
    2 · Calculate the depreciable amountA three-million-riel asset will have five hundred thousand riels residual value. What is depreciated?–About 2 min
    3 · Record depreciation and find the carrying amountDepreciation of fifteen million riels is charged on a ninety-million-riel asset. What changes?–About 2 min
    4 · What depreciation tells youFifteen million riels of depreciation is recorded. Has cash been set aside?–About 2 min
    5 · Straight-line depreciation for a part yearA machine costing two million five hundred thousand riels starts in September. First-year charge?–About 2 min
    6 · Reducing-balance depreciationA one-hundred-million-riel machine uses thirty percent reducing balance. What is Year Two's charge?–About 2 min
    Recap cardEquipment costs KHR 1,260,000, has a residual value of KHR 240,000 and a useful life of six years. Using straight-line depreciation, what is the carrying amount after four full years?–Card
    Practice set20 exam-style questions · answers after you submit · target 80%–After lesson 6

    Chapter 8 · Control accounts and control account reconciliations

    4 lessons · about 8 minutes · recap card · 20-question practice set · printed pp 153–165

    0 of 4 done
    TQ1 Chapter 8
    LessonQuizStatus
    1 · Decide which receivables record to correctControl includes a one-million-seven-hundred-thousand-riel sale the customer account lacks. Which record changes?–About 2 min
    2 · Reconcile receivables control and the customer listThe customer list is fifty-two million riels, but control differs. How do we reconcile?–About 2 min
    3 · Correct and reconcile payables controlThe purchases day book total is sixty thousand riels too low. Which record changes?–About 2 min
    4 · Reconcile a supplier statement to our ledgerA supplier's statement shows five hundred and ninety thousand riels. Do we owe that?–About 2 min
    Recap cardThe original customer list totals KHR 3,362,000. It omits debit balances of KHR 103,000 and includes an invoice of KHR 250,000 twice. What is the corrected total and how do you correct each item?–Card
    Practice set20 exam-style questions · answers after you submit · target 80%–After lesson 4
    Mixed review 4 · Chapters 1–8 · 15 questions, your mistakes first · No mistakes waitingAfter Chapter 8

    Chapter 9 · Bank reconciliations

    5 lessons · about 10 minutes · recap card · 20-question practice set · printed pp 167–181

    0 of 5 done
    TQ1 Chapter 9
    LessonQuizStatus
    1 · Why the cash book and bank statement differTwo million riels banked is not on the statement yet. Why do balances differ?–About 2 min
    2 · Correcting the cash bookThe cash book lacks a seven-hundred-thousand-riel bank charge. Does it need a journal?–About 2 min
    3 · Reading debit and credit from the bank's sideThe statement shows Debit five million two hundred and fifty thousand. Who owes whom?–About 2 min
    4 · Bridging the balances in either directionTwo million riels of deposits await the bank. How do we bridge the balances?–About 2 min
    5 · Reconciling an overdraftWith a twenty-million-riel statement overdraft, how do we reconcile?–About 2 min
    Recap cardThe June cash book shows KHR 1,660,000. The receipts total is KHR 200,000 too low. A receipts total of KHR 2,475,000 was carried forward as KHR 4,275,000. A KHR 220,000 customer cheque was dishonoured, and KHR 184,000 of bank charges were omitted. The statement shows a KHR 450,000 overdraft. Outstanding deposits are KHR 626,000 and unpresented cheques are KHR 520,000. Correct the cash book, then reconcile from the statement.–Card
    Practice set20 exam-style questions · answers after you submit · target 80%–After lesson 5

    Chapter 10 · Correction of errors

    7 lessons · about 14 minutes · recap card · 20-question practice set · printed pp 183–199

    0 of 7 done
    TQ1 Chapter 10
    LessonQuizStatus
    1 · Recognising bookkeeping errorsTwo entries are misposted: telephone to Electricity, a machine to Repairs. Which errors?–About 2 min
    2 · Errors that make totals disagreeA credit is posted ninety thousand riels short. Will the trial balance agree?–About 2 min
    3 · Errors an agreed trial balance can missTwo errors leave two million riels on opposite sides. Will the trial balance agree?–About 2 min
    4 · Writing a correcting journalA one-million-eight-hundred-thousand-riel sales total was posted as one million eighty thousand. What corrects it?–About 2 min
    5 · Recalculating profit after a correctionA sixty-thousand-riel machine was charged to repairs. How does fixing it change profit?–About 2 min
    6 · Opening a suspense accountDebits are thirty-two thousand riels short of credits. Which side takes suspense?–About 2 min
    7 · Clearing suspense through correctionsRent was debited five hundred thousand riels short. How is suspense cleared?–About 2 min
    Recap cardDebits total KHR 459,100 and credits KHR 459,700. Sales returns of KHR 800 were correctly credited to Receivables and also credited to Purchase returns in error. Sales were credited KHR 25,420 instead of KHR 26,420. The receivables debit for the sale is correct. Open suspense and show the correcting entries.–Card
    Practice set20 exam-style questions · answers after you submit · target 80%–After lesson 7
    Mixed review 5 · Chapters 1–10 · 15 questions, your mistakes first · No mistakes waitingAfter Chapter 10

    The earlier TQ1 practice questions stay open while new questions replace them, chapter by chapter. Open the earlier practice questions

    TQ2

    IT skills and software

    Chapter 1 · The accounting environment and information technology

    9 lessons · about 18 minutes · recap card · 20-question practice set · printed pp 3–12

    0 of 9 done
    TQ2 Chapter 1
    LessonQuizStatus
    1 · Check automated postings against evidenceA balanced payment of three hundred thousand riels debits Repairs; is that proof?–Continue
    2 · Trace one sale through linked recordsA shop sells four units at twenty-five thousand riels; which linked records change?–About 2 min
    3 · Keep customer and supplier history usefulA repair costs three hundred thousand riels; how does its linked history help staff?–About 2 min
    4 · Check accuracy, completeness and consistency togetherEleven of twelve invoices appear, all correct. Is the report reliable?–About 2 min
    5 · Trace the damage from a changed valueFive hundred thousand riels was entered as fifty thousand; why trace the consequences?–About 2 min
    6 · Split the steps so no one person acts aloneOne clerk adds a supplier and approves its payment; what safeguard is missing?–About 2 min
    7 · Check the authorised purpose before using personal dataStaff can open two hundred student emails; can they use them in an advertisement?–About 2 min
    8 · Check the permission to reuse digital materialCopying ten pages of an online guide into a report: what must staff check?–About 2 min
    9 · Limit access according to the taskTwenty staff can open a client folder that three need; what should change?–About 2 min
    Recap cardSix quick checks, one for each chapter objective on p 12.–Card
    Practice set20 exam-style questions · answers after you submit · target 80%–After lesson 9

    Chapter 2 · Accounting software

    29 lessons · about 58 minutes · recap card · 20-question practice set · printed pp 13–80

    0 of 29 done
    TQ2 Chapter 2
    LessonQuizStatus
    1 · Open the records behind the dashboardA dashboard shows two million four hundred thousand riels; which invoices explain it?–About 2 min
    2 · Find the form in the Create menuWhere in the Create menu is the form for a nine-million-riel credit sale?–About 2 min
    3 · Distinguish company settings from report filtersA year starts in January and has twelve months; which setting controls it?–About 2 min
    4 · Identify the record before opening an editSix invoices each show two hundred fifty thousand riels; which matches the source?–About 2 min
    5 · Create the asset account and record the purchase separatelyA van cost forty million riels paid from Bank; does account creation record it?–About 2 min
    5b · Code every account so staff post to the same placeTwo staff use different rent codes; how do they agree?–About 2 min
    6 · Import the supplier list into the correct recordsA file has fifty supplier rows; how do they import correctly?–About 2 min
    7 · Check the posting accounts behind imported itemsA business imports thirty items for invoices; why check their income accounts first?–About 2 min
    8 · Count invoices separately from spreadsheet linesFour invoices span seven rows; how do you check the import?–About 2 min
    9 · Record the owner's contribution as capitalOwner deposits thirty million riels in Bank as non-repayable funding; which account is credited?–About 2 min
    10 · Separate loan funding from the asset purchaseA loan of forty million riels pays for the van; one entry or two?–About 2 min
    11 · Use a bill for goods purchased on creditGoods worth eighteen million riels arrive on thirty-day credit; which form records them?–About 2 min
    12 · Distinguish sales receipts and credit invoicesTwelve million riels of cash sales and nine million on credit: which forms?–About 2 min
    13 · Apply a payment to the existing supplier billThe trader pays ten million riels of an eighteen-million bill; how is it recorded?–About 2 min
    14 · Apply a receipt to the customer invoiceThe customer pays eight million riels of a nine-million invoice; how is it recorded?–About 2 min
    15 · Keep owner withdrawals in DrawingsPeriodic: owner takes four million riels from Bank, goods costing two million; which accounts?–About 2 min
    16 · Support and date a period-end journalMarch depreciation is one hundred thousand riels; what must its journal contain?–About 2 min
    17 · Explain every reconciliation differenceA statement ends at fifteen million riels; how do you reconcile it?–About 2 min
    18 · Explain a balance left in payroll clearingPayroll clearing holds fifty thousand riels after payment; what do you investigate?–About 2 min
    19 · Use a trial balance as one check of the ledgerThe trial balance agrees at eighty-three million riels; is every entry right?–About 2 min
    20 · Read a period report and a position reportProfit is five million riels; how does its report differ from the balance sheet?–About 2 min
    21 · Distinguish sales activity from amounts still owedThe customer still owes one million riels; which report shows it?–About 2 min
    22 · Build a report pack for the question askedProfit fell from five million to three million riels; what belongs in the pack?–About 2 min
    23 · Reconcile stock movements to a physical countRecords show three units and the count finds two; which report helps investigate?–About 2 min
    24 · Explain the movement in cash separately from profitProfit is five million riels, yet Bank rose fifteen million; why the difference?–About 2 min
    25 · Use the audit log to investigate a changeA log identifies a user changing bank details at four twenty; what is proven?–About 2 min
    26 · Distinguish Desktop Verify and Rebuild from accounting reviewVerify Data says one file lost integrity; what should you run next?–About 2 min
    27 · Set up the reporting year and conversion date separatelyA file converts on first January; which other reporting date matters?–About 2 min
    28 · Compare software using the same accounting taskBoth packages post the nine-million-riel sale; how do you compare them fairly?–About 2 min
    Recap cardUse the textbook's KHRm 9 credit invoice and KHRm 8 customer payment. Compare a correctly applied receipt with recording the same receipt as another sale.–Card
    Practice set20 exam-style questions · answers after you submit · target 80%–After lesson 28

    Chapter 3 · Spreadsheet software

    20 lessons · about 40 minutes · recap card · 20-question practice set · printed pp 81–108

    0 of 20 done
    TQ2 Chapter 3
    LessonQuizStatus
    1 · Plan a spreadsheet for the taskHow should forty April travel claims be laid out?–About 2 min
    2 · Workbooks, worksheets and cell addressesA file has two sheets; how many workbooks and worksheets?–About 2 min
    3 · Start a new workbook, blank or from a templateWhich three steps create an invoice workbook from a template?–About 2 min
    4 · Save a new version deliberatelyHow do we revise version one without changing the original?–About 2 min
    4b · Name files so they sort and can be foundWhich task-date-department filename fits DeptX’s thirty April twenty twenty-six budget variance?–About 2 min
    5 · Choose relevant and complete dataWhich of forty April and three March claims belong in April?–About 2 min
    6 · Check inputs against a control totalTwenty claims total two million riels; how do we reconcile Excel?–About 2 min
    7 · Enter the right data typeThree claims include eighty-five thousand riels as text; what does SUM omit?–About 2 min
    7b · Enter the same data on several sheets at onceCan one heading be entered on three monthly sheets at once?–About 2 min
    8 · Clear contents or remove a whole recordA wrong amount is in D five of forty claims; what now?–About 2 min
    9 · Import a text file as a linked copyHow can ten tab-separated employee records be imported without editing the source?–About 2 min
    10 · Format headings without losing contentA one, B one contain text; merge A one through D one: what survives?–About 2 min
    11 · Review Find and Replace matchesPartial match: nine Car hire, three Card fee; is replacing Car safe?–About 2 min
    12 · Hide a row without losing its dataDoes hiding row twelve delete its three-hundred-thousand-riel claim?–About 2 min
    12b · Freeze headings while you scrollTo keep row one and column A visible, which cell is selected?–About 2 min
    13 · Turn a column into a row with Paste SpecialCopy A one to A four; transpose at C one; which cells fill?–About 2 min
    14 · Display format and stored valueWhich value do formulas use when one hundred point three seven six displays rounded?–About 2 min
    15 · Highlight accounts past the credit periodHow do we highlight ageing values over thirty among fourteen accounts?–About 2 min
    15b · Highlight the top five with Top/Bottom RulesHow do we highlight the top five of fourteen ageing values?–About 2 min
    16 · Highlight duplicates before investigating themIn fifteen rows, how can Excel flag repeated client entries?–About 2 min
    Recap cardOur 3 source amounts are KHR 145,000, 85,000 and 170,000. The imported identifiers include 0017. Excel shows 17 and a total of 315,000. What should be checked?–Card
    Practice set20 exam-style questions · answers after you submit · target 80%–After lesson 16

    Chapter 4 · Application of Microsoft Excel

    35 lessons · about 70 minutes · recap card · 20-question practice set · printed pp 109–168

    0 of 35 done
    TQ2 Chapter 4
    LessonQuizStatus
    1 · Enter a formula using cell referencesA one holds ten; what does two times A one return?–About 2 min
    2 · Check the function's rangeFive sales total two hundred fifty million riels; what is their average?–About 2 min
    3 · Put one function inside anotherIs sixty above a five-day average of fifty million riels?–About 2 min
    4 · Keep a shared rate fixed when copyingOne twenty-percent rate covers twenty thousand and forty-eight thousand riels; how?–About 2 min
    5 · Distinguish a range from subtractionDo five amounts totalling three hundred thousand riels work with SUM subtraction?–About 2 min
    6 · Keep a result with Paste ValuesThree items cost twelve thousand riels each; how can we preserve today's result?–About 2 min
    7 · Find a function for the taskFive values are three, two, seven, eleven and five; which function finds the middle?–About 2 min
    8 · Rank and percentile answer different questionsAmong one to one thousand, what is fifty's descending rank?–About 2 min
    9 · Straight-line depreciation with SLNEquipment eight point four million riels; residual one point four million; five-year charge?–About 2 min
    10 · Keep the initial cash flow outside NPVTen-percent NPV: half-million riels today returns six hundred sixty thousand next year?–About 2 min
    11 · Check contents with information functionsA cell stores eighty-five as text; will ISNUMBER return true?–About 2 min
    12 · Return a result with IFA student scores seventy and the pass mark is seventy; what does IF return?–About 2 min
    13 · Combine conditions with AND and ORWorksheet: five times five is twenty-five; thirty-two over eight is four; AND?–About 2 min
    14 · Handle an error without hiding the problemWorksheet: IFERROR wraps twenty-five divided by zero; what appears?–About 2 min
    15 · Look up an exact codeWhat monthly pay matches employee code X Y Z two five three eight?–About 2 min
    16 · Round, truncate or take the lower integerWorksheet: thirteen point seven five eight nine rounded to two decimal places?–About 2 min
    17 · Sum values meeting a conditionFifteen employee records include six Manufacturing salaries; what is their combined pay?–About 2 min
    18 · Total rows using SUBTOTALFifteen salaries total six hundred eighty-seven thousand; which SUBTOTAL function sums them?–About 2 min
    19 · Count numbers, filled cells or matchesTwenty cells include three numbers; COUNT also receives ten, eleven and twelve: result?–About 2 min
    20 · Sort complete records togetherSeven products are sorted by selling price, smallest first; which appears first?–About 2 min
    21 · Combine column filtersProducts: five hundred thousand riels minimum, ordered before fifteen November twenty nineteen; how many?–About 2 min
    22 · Summarise a table with a PivotTableSeven records contain twenty-four units; how summarise units by individual order date?–About 2 min
    23 · Compare categories with a bar chartSales: Monday forty, Tuesday sixty, Wednesday eighty, Thursday fifty, Friday twenty million riels; highest?–About 2 min
    24 · Show an ordered trend with a line chartMonthly sales: January nine hundred, February eight hundred forty million riels; which direction?–About 2 min
    25 · Show parts of one whole with a pie chartFive regions’ sales: sixteen thousand one hundred twenty-two million riels; pie shows what?–About 2 min
    26 · Show totals and components with stacked columnsJanuary breakdowns: Factory A zero, B four, C two; stacked total?–About 2 min
    27 · Put small trends in cells with sparklinesFactory A has twelve months; which source creates its sparkline in N three?–About 2 min
    28 · Pair numerical values in a scatter chartMonth one, sales nine hundred million riels: what scatter point represents it?–About 2 min
    29 · Check a chart's source range after updatesJanuary sales: nine hundred eighty-nine million riels outside fixed chart; what now?–About 2 min
    30 · Chart a PivotTable summarySeven distinct order dates, shown individually: how many PivotChart categories?–About 2 min
    31 · Prepare a checked spreadsheet reportThree regions’ sales total five hundred thousand riels; what belongs in the report?–About 2 min
    32 · Restrict typed inputs with validationA Stop alert is set for whole numbers one through ten; typing twenty?–About 2 min
    33 · Trace formula inputs and check errorsB nine divides sixteen thousand one hundred twenty-two by empty B ten; issue?–About 2 min
    34 · Protect formula cells and understand the limitTwo input cells need editing; how can one formula cell stay protected?–About 2 min
    35 · Choose sharing permissions for the taskOne reviewer needs to read a budget only; which permission fits?–About 2 min
    Recap card3 amounts total KHR 110,000 at 4%; what is the charge?–Card
    Practice set20 exam-style questions · answers after you submit · target 80%–After lesson 35

    Chapter 5 · Application of Microsoft Word

    20 lessons · about 40 minutes · recap card · 20-question practice set · printed pp 169–198

    0 of 20 done
    TQ2 Chapter 5
    LessonQuizStatus
    1 · Plan the document around the readerStock: thirty-seven expected, thirty-four counted; what should the supervisor see?–About 2 min
    2 · Find commands by their purposeA reviewer queries one phrase in paragraph two; which Word tab helps?–About 2 min
    3 · Check every template fieldA report template has six sample fields; what should we check?–About 2 min
    4 · Save a clearly named versionHow should the July twenty twenty-six version-two stock review be saved?–About 2 min
    5 · Compare versions before deciding on a changeThirty-seven expected, thirty-four counted; how do we compare yesterday’s online memo?–About 2 min
    6 · Use a field for page numbersA twelve-page report grows; how do page numbers update?–About 2 min
    7 · Use a break to start a new pageFifteen blank paragraphs move a heading; how can it start a page?–About 2 min
    8 · Measure indents from the marginA margin is two point five four centimetres; where does the indent start?–About 2 min
    9 · Give a wide table its own landscape sectionA four-page portrait report needs page three landscape; what should we do?–About 2 min
    10 · Show draft status with a watermarkFive reviewers receive a draft memo; how can each page show its status?–About 2 min
    11 · Build a real heading structureTwo major headings and one subsection: how should a memo be structured?–About 2 min
    12 · Format paragraphs consistentlyThree fonts appear in a memo; how can its paragraphs look consistent?–About 2 min
    13 · Resize a picture without distortionA four-to-three picture is fifteen centimetres wide; what height preserves proportions?–About 2 min
    14 · Draw the relationship between process stepsThree process steps need a diagram; how should they connect?–About 2 min
    15 · Check chart data and labels togetherA May sales chart totals five hundred thousand riels; what else needs checking?–About 2 min
    16 · Use a text box for a short findingA three-unit stock shortfall needs a callout; how should it be placed?–About 2 min
    17 · Plan a table before inserting itThree stock counts need checking; how should we lay out a table?–About 2 min
    18 · Update a Word table formulaA table totals thirty-four; how do we update it after a correction?–About 2 min
    19 · Clear table contents or remove the gridHow do we clear a four-column five-row table without removing its grid?–About 2 min
    20 · Use the shortcut for the intended editIn paragraph two, which shortcut starts the next heading on a new page?–About 2 min
    Recap cardThe memo concerns 37 expected units and 34 counted. Its draft version two needs a clear structure and a checked findings table. Describe the document checks before review.–Card
    Practice set20 exam-style questions · answers after you submit · target 80%–After lesson 20

    Chapter 6 · Application of Microsoft Outlook

    15 lessons · about 30 minutes · recap card · 20-question practice set · printed pp 199–220

    0 of 15 done
    TQ2 Chapter 6
    LessonQuizStatus
    1 · Outlook as a personal information managerThree jobs need email, a calendar and contacts; which programme combines them?–About 2 min
    2 · Address a message by who needs to actOne reviewer acts and one supervisor needs information; how do we address them?–About 2 min
    3 · Understand what Bcc hidesThirty clients need one email; what does Bcc hide?–About 2 min
    4 · Read beyond the message previewA three-line preview requests five hundred thousand riels; what should we read?–About 2 min
    5 · Choose Reply or Reply All deliberatelyTwo managers are copied but only the sender needs an answer; which reply?–About 2 min
    6 · Check a message before resendingA one million two hundred thousand riel quote needs resending; what first?–About 2 min
    7 · Attach the right file and check itA July stock review version two must be attached; what should we check?–About 2 min
    7b · Open and save a received attachment safelyOne expected invoice arrives as an attachment; how do we save a copy?–About 2 min
    8 · Organise mail without losing required recordsFour hundred old messages need sorting; how do we preserve required records?–About 2 min
    9 · Set the appointment time and reminderAn appointment runs eight to eight thirty; how should its timing be checked?–About 2 min
    10 · Check imported holiday datesPlanning Cambodia holidays for twenty twenty-six; how do we check imported dates?–About 2 min
    11 · Share only the calendar access neededOne colleague needs availability from twenty-seven January to two February; which permission?–About 2 min
    12 · Build a meeting invitation around its purposeThree staff must attend and one is optional; how do we invite them?–About 2 min
    13 · Respond to the invitation you actually receivedA nine-to-ten-thirty webinar appears tentative; have we accepted it?–About 2 min
    14 · Update or cancel through the organiserAn eleven o’clock meeting must stop for everyone; who cancels it?–About 2 min
    Recap cardA stock-review email and review invitation are prepared. The email is for the reviewer, with the supervisor copied, and includes July version two. The meeting is 3 November 2026, 09:15–10:00, UTC+7, with three required attendees and a fifteen-minute reminder. List the checks before sending.–Card
    Practice set20 exam-style questions · answers after you submit · target 80%–After lesson 14
    TQ3

    Introduction to costing

    Chapter 1 · Costing, costs and cost behaviour

    16 lessons · about 31 minutes · recap card · 20-question practice set · printed pp 1–28

    0 of 16 done
    TQ3 Chapter 1
    LessonQuizStatus
    1 · Turn recorded facts into useful cost informationTime sheets log 20 hours on 2 ships. What does the manager need?–Continue
    2 · Measure costs for the question being askedA factory makes KHR 4,000,000 profit from 2 products. Can one lose money?–About 2 min
    2b · Match costs to the type of businessDoes a shop's KHR 1,000,000 rent belong in the cost of its goods?–About 1 min
    3 · Build a cost code from its partsNorth 01, luxury 03, electronics 02. What numeric code?–About 2 min
    4 · Define the cost unit before dividing20 buses cost KHR 60,000,000 monthly. What is the cost per bus?–About 2 min
    5 · Classify one cost in several waysA worker earns KHR 10,000 per chair. How is the cost classified?–About 2 min
    6 · Share a common cost on a supported basisProduction uses 700 m², office 300 m². Share KHR 1,000,000 rent?–About 2 min
    7 · Measure materials consumed before adding production costsClosing materials are KHRm 20,000. How is consumption calculated?–About 2 min
    8 · Move costs through work in progress and finished goodsManufacturing cost is KHRm 417,000. Which inventory adjustments determine cost of sales?–About 2 min
    9 · Separate total behaviour from cost per unitFrom 1,000 to 2,000 litres, how do rent and materials behave?–About 2 min
    10 · Calculate a mixed cost from its two partsAt 15,000 copies, how is a mixed monthly copier bill calculated?–About 2 min
    11 · Apply the correct activity band to a stepped cost1 supervisor covers 2,000 hours. How many cover 2,001 hours?–About 2 min
    12 · Trace a cost in full to its cost unitMixer hire for 1 house costs KHR 600,000. Is it direct?–About 2 min
    13 · Build prime cost and full production costDoes a cabinet's KHR 30,000 production overhead belong in its prime cost?–About 2 min
    14 · Match product costs with the goods soldA shop sells 30 of 40 items. How do their costs become expenses?–About 2 min
    15 · Cost an unfinished service jobHow is 10 hours' work on an unfinished 20-hour tax job recorded?–About 2 min
    Recap cardIn a course factory, monthly production rent is KHR 1,200,000. The month's 400 units are made at normal output, and the rent is shared equally over them. Three hundred units are sold. Classify the cost by type, function, behaviour and traceability, then split its product-cost amount between sales and closing inventory.–Card
    Practice set20 exam-style questions · answers after you submit · target 80%–After lesson 15
    After TQ1

    Later subjects

    • TQ4 Introduction to business
    • TQ5 Financial statement preparation
    • TQ6 Management accounting
    • TQ7–TQ8 when their study texts arrive

    Cookies on this site

    Essential cookies only, unless you allow analytics or advertising.