Guide-linked quiz · Easy Level

How to Categorize Your Bank Transactions With AI Quiz

Tests preparing and redacting a bank CSV, reading cryptic merchant descriptors, excluding transfers, and checking row counts and totals.

Question 1 of 8

Which columns does the guide recommend keeping before you upload a bank export to a chatbot?

Preview every question8 questions

Answers and explanations appear as you take the quiz.

  1. Which columns does the guide recommend keeping before you upload a bank export to a chatbot?
    • Date, description and amount
    • Account number, balance and amount
    • Name, address and description
    • Every column the bank provides
  2. Why choose a fixed category list before asking the AI to sort transactions?
    • It makes the file smaller
    • The bank requires it
    • Otherwise the model may invent near-duplicates like Food, Restaurants and Dining
    • Chatbots cannot read category names
  3. A transaction reads 'SQ *BLUE DOOR'. What does the 'SQ *' prefix most likely tell you?
    • That the charge is a subscription
    • That the payment processor was Square, not what kind of business it is
    • That it is a charge based on square footage
    • That the line is a refund
  4. Why should a credit card payment from your checking account usually be left out of spending totals?
    • It is always a fee
    • Banks hide it from exports
    • It counts as income
    • The purchases on the card are already counted, so including the payment counts them twice
  5. How should the AI handle an unclear Amazon charge?
    • Label it Groceries
    • Delete the row
    • Mark it Needs review so you can decide
    • Split it evenly across all categories
  6. Which check confirms that the AI did not drop or merge any rows?
    • The row count and category totals match the original file
    • The categories are in alphabetical order
    • The file opens without errors
    • The file has a Category column
  7. For a file with thousands of transactions, why is a code-running data analysis tool more reliable than pasting text into a chat?
    • It connects directly to your bank
    • It removes account numbers automatically
    • It guarantees correct categories
    • It applies logic to every row instead of rewriting long text that can skip lines
  8. What is the advantage of asking the AI for keyword rules instead of only categories?
    • Rules hide merchant names
    • Rules can be reapplied to next month's export for consistent results
    • Rules make the bank categorize for you
    • Rules remove the need to check totals

Keep testing yourself

More quizzes picked for your level.

View all quizzes