CAT Accounting Technician Software & Technology 3

Question 1

A company migrates from a desktop accounting package to a cloud ERP. What is the MOST important step before going live?

Accepted Answer

Run parallel processing to verify outputs match between old and new systems

Answer

Parallel processing runs both systems simultaneously so outputs can be compared, catching data errors or mapping issues before the old system is decommissioned.

Question 2

In a spreadsheet, the formula =VLOOKUP(A2, Customers!$A:$C, 3, FALSE) returns an error #N/A. What is the MOST likely cause?

Accepted Answer

The value in A2 does not exist in the first column of the lookup range

Answer

#N/A in VLOOKUP means the lookup value was not found in the first column of the specified range, indicating a missing or mismatched entry.

Question 3

What does the term 'drill-down' mean in the context of accounting software dashboards?

Accepted Answer

Clicking on a summary figure to see the underlying detailed transactions

Answer

Drill-down lets users click on a summarized figure (e.g., total sales) to navigate to the individual transactions that make up that total.

Question 4

Which module in an ERP system would an accounting technician use to record the purchase of raw materials from a supplier?

Accepted Answer

Accounts Payable / Purchase Order module

Answer

The Accounts Payable or Purchase Order module handles supplier invoices, purchase orders, and payments for goods and services received.

Question 5

An accounting technician exports a report to PDF and notices figures differ from the on-screen view. What should be checked FIRST?

Accepted Answer

Verify the report date range and filter settings used for the export

Answer

Discrepancies between on-screen and exported reports are most commonly caused by different date ranges or filters being applied at export time.

(CAT) Certified Accounting Technician Practice Test

(CAT) Certified Accounting Technician Practice Test

CAT Accounting Technician Software & Technology 3