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.

Frame from lesson 11 of Sophyx Certified AI Fundamentals, "Numbers and spreadsheets"

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
Book a Demo