Practice Test Geeks(CAT) Certified Accounting Technician Practice Test
← All CAT Flashcard Decks

Accounting Technician Software & Technology Flashcards

7 cards from real CAT practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.

Read the first 7 Accounting Technician Software & Technology flashcards as text

  1. Which Excel function calculates the total of all cells in a range that meet a single specified condition?

    Answer: =SUMIF()

    =SUMIF(range, criteria, sum_range) adds only those values in the sum_range where the corresponding cell in range meets the criteria.

  2. A company uses integrated accounting software. Which of the following BEST describes integration between the sales module and the general ledger?

    Answer: Posting a sales invoice automatically creates corresponding general ledger entries

    In integrated software, posting a sales invoice automatically generates the debit to Accounts Receivable and credit to Revenue in the general ledger without manual re-entry.

  3. What is the MAIN risk of using unlicensed (pirated) accounting software in a business?

    Answer: Lack of security patches and vendor support exposes data to vulnerabilities

    Unlicensed software does not receive official security updates or support, leaving financial data exposed to malware, data breaches, and compliance violations.

  4. In accounts payable software automation, what does 'three-way matching' verify?

    Answer: The purchase order, goods receipt note, and supplier invoice all agree before payment

    Three-way matching compares the PO (what was ordered), the GRN (what was received), and the invoice (what the supplier is charging) to prevent overpayment or fraud.

  5. An accounting technician needs to analyze which expense categories exceeded budget. Which Excel feature is MOST efficient for this?

    Answer: PivotTable with variance calculations

    A PivotTable can quickly summarize actual vs. budget figures by category and calculate variances, enabling fast identification of overspent areas.

  6. What is a 'chart of accounts' in accounting software?

    Answer: A structured list of all account codes used to categorize financial transactions

    The chart of accounts is the foundational numbered list of all accounts (assets, liabilities, equity, income, expenses) used to classify every transaction in the system.

  7. Which of the following BEST describes Software as a Service (SaaS) in the context of accounting software?

    Answer: Accounting software hosted by a vendor and accessed via a web browser on a subscription basis

    SaaS accounting software (e.g., QuickBooks Online, Xero) is hosted in the cloud by the vendor and accessed through a browser, with the vendor managing updates and infrastructure.