Practical Tool Exercises and Review
These practical tool exercises connect Excel, QuickBooks, HubSpot, Power BI, Power Query, and Python to real business decisions. Write your reasoning first, then expand the worked answer and check the assumptions.
How to use this practice page
Work through 18 original scenarios across six tools. Use a calculator or a small workbook where helpful. For each answer, explain the result, the relevant control, and what the result does not prove. These are self-study exercises, not a certification exam or an automatic assessment.
Answers stay hidden until you open them. This page does not store your answers or track a score. For a simple self-review, award yourself one point for a correct conclusion and one for a sound explanation of the check or limitation, for up to 36 points. Revisit weak topics rather than treating a total score as proof of proficiency.
1. Excel: summarize, count, and look up
Review PivotTables → · Review the formulas lesson →
1. Reconcile a PivotTable
January revenue is 1,000 for Bookkeeping and 1,500 for Advisory. February is 500 and 2,000 respectively. What are the total revenue and each service’s total?
Reveal worked answer 1
Revenue is 5,000. Bookkeeping is 1,500 and Advisory is 3,500. Both month totals are 2,500. Check the PivotTable grand total against a separate source total and verify that no filters hide records.
2. Choose sum or count
In a Sales table, you need both Advisory revenue and the number of Advisory invoice rows. Which formulas answer these questions?
Reveal worked answer 2
Use =SUMIFS(Sales[Revenue],Sales[Service],"Advisory") for the amount, and =COUNTIFS(Sales[Service],"Advisory") for the row count. The first sums qualifying values; the second counts qualifying rows. A row count is not necessarily a distinct-customer count.
3. Investigate an ambiguous lookup
An exact-match XLOOKUP for invoice 003 returns Alpha. COUNTIFS finds two rows for 003. Can you accept Alpha as the invoice’s customer?
Reveal worked answer 3
Not without investigating the key and record grain. Default XLOOKUP returns the first matching position, so another row may disagree. Confirm whether there should be one invoice header, multiple valid lines, or a company-plus-invoice key. An exact match does not establish uniqueness.
2. QuickBooks: reconcile and review
4. Reconcile cash
The statement balance is 12,400. A 900 deposit is in transit and 1,100 of checks are outstanding. The ledger is 12,250 before an unrecorded 50 bank fee. What is the reconciled balance?
Reveal worked answer 4
Bank side: 12,400 + 900 − 1,100 = 12,200. Book side: 12,250 − 50 = 12,200 after recording the supported fee. Do not record outstanding checks or the deposit again; they are already in the books.
5. Avoid duplicate income
You recorded a 1,500 receipt against a customer invoice. The same receipt downloads in the bank feed. Should you add another income transaction?
Reveal worked answer 5
No. Review and match the downloaded activity to the existing recorded transaction when it represents the same event. Adding new income again can duplicate revenue and cash. Verify the date, amount, account, and underlying payment.
6. Resolve a control-account difference
Same-date receivable detail is 8,200, while the balance sheet shows 8,700. A colleague suggests writing off 500 to make them agree. What should you do first?
Reveal worked answer 6
Investigate the unexplained 500. Check report basis, filters, cutoff, unapplied items, and postings to the receivable control account. A write-off needs evidence about a real balance and appropriate approval; the mismatch itself does not justify one.
3. HubSpot: keep opportunities meaningful
7. Decide whether to create a deal
Your form receives a newsletter signup, a job inquiry, and a qualified request for a bookkeeping proposal. Which should become a sales deal under a rule requiring a genuine service opportunity?
Reveal worked answer 7
The qualified service opportunity is the candidate. The other records can exist as contacts or be handled through another process. Turning every submission into a deal inflates the board and makes pipeline totals less meaningful.
8. Define the amount basis
One proposed service is 500 per month. Another deal is entered as 6,000 for a 12-month illustration. Can you add 500 and 6,000 as a comparable pipeline total?
Reveal worked answer 8
Not until both amounts use a consistent definition. Decide whether Amount represents monthly recurring revenue, committed contract value, or another measure. A 12-month illustration is 500 × 12 = 6,000, but that is not automatically the committed value of a cancellable monthly engagement.
9. Set a useful next step
A proposal has been sent. The deal’s next action says “follow up” with no owner or date. What would make this actionable?
Reveal worked answer 9
Assign an owner, a specific action, and a due date—for example, confirm the buyer’s scope questions and decision timeline at the agreed review. Move stages based on evidence, and record uncertainty instead of inventing a close date.
4. Power BI: verify the metric
10. Calculate aggregate margin
Three rows have revenue of 1,000, 500, and 1,500, with direct cost of 600, 400, and 600. What is total gross margin?
Reveal worked answer 10
Revenue is 3,000 and direct cost is 1,600, giving gross profit of 1,400. Gross margin is 1,400 ÷ 3,000 = 46.67%. The simple average of the row margins, 40%, 20%, and 60%, is 40%; that is a different statistic.
11. Check the join grain
A 900 invoice-header total is repeated after joining to its three lines. Your visual sums 2,700. Is this growth in revenue?
Reveal worked answer 11
No. The join repeated a header-level amount at line grain. Use the correct fact grain and a suitable measure or separate header table, then reconcile to the original 900. A chart cannot correct duplicated source meaning.
12. Test a service filter
A service slicer changes revenue but leaves a supposedly related cost visual unchanged. What should you inspect?
Reveal worked answer 12
Inspect relationships, keys, visual interactions, filter context, and measure definitions. Confirm that both figures have comparable scope. Compare a known service manually before treating the displayed margin as reliable.
5. Power Query: control file scope
13. Detect a repeated file
January and February each contain two invoice rows totaling 2,500. A second eligible copy of January is added. What could the combined result become?
Reveal worked answer 13
Six rows totaling 7,500, instead of four rows totaling 5,000. The transformation may succeed even though the selected inputs are wrong. Check the file set and row counts by source file before accepting a refresh.
14. Choose append or merge
You need to stack monthly transaction exports, then add each customer’s region from a reference table. Which operations fit?
Reveal worked answer 14
Append stacks the monthly records. Merge joins the customer attributes by an appropriate key. Check uniqueness on the reference side before expanding a merge, then verify row counts and totals afterward.
15. Handle a failed file
One monthly export has a changed header and fails. The skip-files-with-errors option produces a clean-looking report. Is it ready?
Reveal worked answer 15
Not until the failed file is accounted for. The result may omit an entire month. Identify the schema change, correct or deliberately handle it, and reconcile expected periods, files, rows, and amounts. A successful load is not proof of completeness.
6. Python: specify and test the rule
16. Preserve identifiers
A CSV has invoice IDs 001, 002, 001, and a blank. What should a text-based duplicate check report?
Reveal worked answer 16
Four rows, one blank ID, and repeated nonblank ID 001. Keep IDs as text to preserve leading zeros. A repeated ID is an exception for investigation, not automatic proof of a duplicate accounting transaction.
17. Test beyond the happy path
Your script prints the expected result for one sample. Name three useful additional tests.
Reveal worked answer 17
Test missing required headers, malformed row shape, and a file with no repeated IDs. Also test blank IDs, unexpected types, and the actual key/grain rules. Check that failure behavior is visible instead of silently returning a plausible result.
18. Estimate net time released
Manual review takes 30 minutes weekly. Running a script takes 5 minutes plus 10 minutes of review. Over 40 runs, with 6 hours of development and maintenance, what is the net time released?
Reveal worked answer 18
Each run releases 30 − 5 − 10 = 15 minutes. Forty runs release 600 minutes, or 10 hours, before development and maintenance. Subtract 6 hours for an illustrative net benefit of 4 hours. This is capacity released, not automatically a cash saving.
Use the result to choose your next lesson
If calculation answers were weak, rebuild the small examples and tie totals back to source rows. If control answers were weak, focus on scope, keys, evidence, and exception handling. If the tool choice was weak, write the question in plain English before choosing a formula, report, or automation. Useful software skills combine correct outputs with an explanation someone else can verify.
Frequently asked questions
Do these exercises change any connected account?
No. They are fictional scenarios for self-study; the page does not operate QuickBooks, HubSpot, or any other account.
Do I need all six tools installed?
No. You can reason through the scenarios on paper. Using a workbook or script can provide additional practice.
How should I check an answer?
Compare the conclusion, calculation, assumptions, and control steps with the worked explanation. There can be more than one sensible workflow.
Is my progress saved?
No. Keep your own notes if you want to track topics for another review.
Sources and further learning
Official documentation reviewed November 3, 2026. Worked examples, learning sequences, and practice answers are original teaching illustrations. Product interfaces and availability can vary by version, platform, plan, and region.
- Microsoft: PivotTables
- Microsoft: XLOOKUP
- Microsoft: folder imports
- Intuit: reconciliation
- HubSpot: pipelines
- Microsoft: Power BI measures
- Python: CSV reader