Free demo · Google Sheets · Lesson 4 · Basics · Ask Gemini

Ask Gemini for a formula, then check it

Describe what you need in plain words and Gemini writes the formula. Your job is the important one: make sure the number is right.

Course | Children | Fees Art | 24 | 36,000 Sport | 31 | 37,200 Computers | 18 | 32,400 Music | 12 | 14,400
  1. 1Click Ask Gemini at the top right
  2. 2Say what you want and which column
  3. 3Gemini reads your request and the sheet
  4. 4A formula with an explanation
  5. 5Choose the cell, then Insert
  6. ✓Check it: the quick sum shows the same total
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. Enrol

Tip: press → or Space to step through, ← to go back, R to replay.

About this lesson

Gemini is Google's AI assistant, built into Google Sheets on eligible Google Workspace and Google AI plans. The Ask Gemini button at the top right opens a side panel where you describe what you need: a formula, a table, a chart, a pivot table, conditional formatting or a summary of the data. For a formula, Gemini answers with the formula and a short explanation, and Insert places it in the selected cell. AI can be confidently wrong, so the course teaches one rule from the first level: never trust a number you did not check. Test an AI formula against the quick sum or against two rows you can work out by hand, and keep private data such as phone numbers out of your prompts. The full course goes on to the AI function, =AI("prompt", range), Fill with Gemini, analysis and charts on demand. Without a Gemini plan you can ask the free Gemini app for the formula and paste it into Sheets.

Key points

  • Ask in plain words: what you want and which column
  • Read the explanation, then Insert
  • Never trust a total you did not check