AX-100 · Lesson 11 of 12 · Module 4: AI in Your Day · 2:54
Numbers and spreadsheets
Assistants explain data and write formulas well, but in plain chat they write numbers as likely text, so a total can be wrong while sounding exact. Describe the table (columns, units, period, question), ask for the formula, let the spreadsheet calculate, and use a rough estimate to catch a number that is clearly off. Analysis tools that run real calculations still get a check, and confidential figures go only into approved tools. Worked example: an April sales gap between the two shops given as £4,450 that is really £1,450.

What you will learn
- Ask for a formula instead of a typed total
- Sanity-check any number an assistant gives
- Describe a table so the assistant reads it right
The one thing to remember
Let the spreadsheet do the sums.
Common mistake: Copying an AI total straight into a report
In plain chat the assistant writes digits as likely text, so a total can be off while sounding exact.
The fix: Ask for the formula, let the spreadsheet calculate, and compare with a rough estimate.
Key terms
- Formula
- A spreadsheet instruction that does the sum for you.
- Sanity check
- A quick rough estimate that catches a number that’s off.
- Analysis tool
- A feature that runs real calculations on your file.
Part of AI Fundamentals (AX-100)
For anyone at work new to AI: how assistants answer, how to ask well, how to check the answer and keep data safe.
12 lessons, practice quizzes, a final exam and the Sophyx Certified AI Fundamentals certificate. Regular price USD 49.99. Your first certification is free. Free with any paid Sophyx plan.
Start the course free