Learning path · Level 5 · Tutorial 2

Requesting and Checking Spreadsheet Formulas

Use a small table entered in your own spreadsheet to request and inspect AI-suggested formulas. Check results against simple calculations and assess whether an accompanying trend explanation matches the spreadsheet data.

  • Level: Intermediate
  • Duration: 22 min
  • 8 steps
Start tutorial Back to the path
Requesting and Checking Spreadsheet Formulas

What you will go through

  1. Set Up a Small, Checkable Table Set up a small spreadsheet table, distinguish its inputs from its output locations, and establish a manual check for the first week before asking an AI for a formula. 2 min
  2. Request a Formula with Exact Context Create a precise AI request for the practice spreadsheet so that suggested formulas can be checked against known values. 3 min
  3. Read the Formula Before Using It Inspect arithmetic and SUM formulas before using them, including the references, operations, range endpoints, and locale-sensitive syntax. 3 min
  4. Test One Row, Then Check the Copy Verify the first weekly revenue formula, then confirm that filling it down preserves the intended row-by-row logic. 3 min
  5. Check What the Total Includes Validate spreadsheet totals by checking range coverage, selected columns, and an independent addition. 2 min
  6. Find Missing Values and Text Numbers Diagnose blank inputs and numeric-looking text entries without confusing them with an incorrect SUM range. 3 min
  7. Check the Trend Explanation Check an AI-generated trend explanation against comparable periods, consistent units, and the verified values in the Practice worksheet. 3 min
  8. Complete a Formula and Explanation Check Update a small spreadsheet table, verify formula suggestions against independent checks, and write an evidence-supported trend explanation. 4 min

What you will learn

  • Describe a spreadsheet task with exact columns, sample values, application details, and an expected result.
  • Identify the cells, ranges, and operations used by a suggested arithmetic or SUM formula.
  • Check a formula on a small example and inspect its references after copying it to another row.
  • Recognize incorrect ranges, missing values, and data-format problems that can distort results.
  • Check an AI-generated trend explanation against comparable periods, units, and spreadsheet totals.

Before you start

  • Building and Refining a Task Prompt
  • Checking AI Analysis of Text and Tables

Step 1 of 8

Set Up a Small, Checkable Table

Set up a small spreadsheet table, distinguish its inputs from its output locations, and establish a manual check for the first week before asking an AI for a formula.

Map the sheet before entering values

Start with the worksheet and cell map

Create or rename a worksheet to Practice. You will enter and check everything in your own spreadsheet; an AI assistant cannot see or edit it unless you explicitly share content.

A cell address combines its column letter and row number. For example, B2 is column B, row 2. In this task, columns B and C hold source inputs, while column D is reserved for weekly revenue outputs.

Each data row is one complete, consecutive seven-day period for the same product. Revenue excludes discounts, taxes, and returns.

Inputs, weekly outputs, and summary outputs

A spreadsheet grid with columns A to D and rows 1 to 6, visually separating input columns, weekly revenue output cells, and the total row.

Use the column letters and row numbers to locate a cell precisely. Columns B and C are inputs; D2:D5 will hold weekly revenue outputs later.

Build the small checkable table

Enter the practice data

Enter the headers and source values below exactly as shown. Enter source values as plain numbers: do not type currency symbols into the cells.

Type Total in A6. Leave D2:D5 empty for now: they are reserved for weekly revenue calculations. Also leave B6, C6, and D6 empty for now; the summary outputs will be calculated later.

The data is synthetic and intentionally small, so every later result can be checked independently.

Practice sheet entries

Use this as your entry map for the worksheet named Practice.

Column D and the summary output cells are intentionally blank at this stage.
RowABCD
1WeekUnits soldUnit price (USD)Revenue (USD)
2Week 1105
3Week 2125
4Week 3810
5Week 41010
6Total

Separate inputs from outputs

Identify what each location holds

Match each cell location to its role in the practice sheet.

Tap an item and then its matching pair.

Check the first row manually

Make an independent Week 1 check

Without using AI or a spreadsheet formula, use the Week 1 row to write:

  1. the cell address for units sold,
  2. the cell address for unit price,
  3. the cell address reserved for that week's revenue, and
  4. the manual calculation and expected revenue in USD.

This independent check is the result you will use to evaluate a later formula suggestion.

Write at least 35 characters (0/35).

Step 2 of 8

Request a Formula with Exact Context

Create a precise AI request for the practice spreadsheet so that suggested formulas can be checked against known values.

Turn the sheet into a clear request

Give the assistant the sheet context

An AI assistant cannot see or edit your spreadsheet unless you explicitly provide the information. Treat your request as a compact specification: identify the spreadsheet application and locale, name the worksheet and headers, give the relevant values and cell locations, state the intended calculations, and provide a checkable expected result.

This lets you evaluate a suggestion instead of trusting a formula simply because it looks plausible.

A diagram shows selected spreadsheet inputs and output locations being turned into a structured request for an AI assistant.

A useful request connects the sheet's actual structure to a specific calculation and a result you can check.

Specify scope and checks

Request checklist

Include these details before asking for formulas.

Each detail removes a different kind of ambiguity.
DetailWhat to state
Application and localeGoogle Sheets on the web; English (United States) locale
StructureWorksheet Practice; exact headers in A1:D1
Source dataRepresentative typed values in A2:C5, as plain numbers
Output locationsWeekly revenue starts in D2; totals go in B6 and D6
Calculation scopeWeekly revenue for rows 2–5, then fill down; separate units and revenue totals
Expected checkA known result, such as D2 = USD 50.00, plus requested explanation

Tip

Keep the task bounded

Ask for separate calculations: weekly revenue, total units, and total revenue. Unit price is an input to weekly revenue; it is not a total you need to request.

State that the values are typed synthetic data. Do not imply that the assistant can inspect your workbook or make changes in it.

See a complete, checkable request

Example

Worked request

This example gives enough context for a formula suggestion that can later be checked:

“I am using Google Sheets on the web with the English (United States) locale. In worksheet Practice, headers A1:D1 are Week, Units sold, Unit price (USD), and Revenue (USD).

I typed these source values in A2:C5: Week 1 | 10 | 5; Week 2 | 12 | 5; Week 3 | 8 | 10; Week 4 | 10 | 10.

Suggest separate formulas for weekly revenue beginning in D2, total units in B6, and total revenue in D6. The weekly revenue formula must work for rows 2–5 when copied down. Do not total the unit-price column. Explain briefly which cell references and operation each formula uses.

For checks, D2 should display USD 50.00; the four weekly revenues should be 50, 60, 80, and 100; total units should be 40; and total revenue should be USD 290.00. I will enter and verify the formulas myself.”

The expected results do not tell the assistant what to invent. They give you an independent test: a response must match the stated task and produce results consistent with the small table.

Practice: write the request

Draft a precise formula request

Write your own request for the Practice worksheet. Address an AI assistant and include the actual application and locale, the exact headers and relevant cells, the four rows of source data, the three separate calculations, where each output belongs, and that weekly revenue must be copied through the data rows. Include a checkable expected result and ask for a brief explanation of the cell references and operation used. Make clear that you will enter and verify the suggestion yourself.

Write at least 450 characters (0/450).

Step 3 of 8

Read the Formula Before Using It

Inspect arithmetic and SUM formulas before using them, including the references, operations, range endpoints, and locale-sensitive syntax.

Read an arithmetic formula

Formula versus result

A formula is an instruction that begins with an equals sign (=). Its displayed result is a value, not the instruction itself.

For the Week 1 revenue cell, B2 refers to units sold and C2 refers to unit price. The * operator tells the spreadsheet to multiply those two inputs. When the formula is in D2, the displayed value is 50, or USD 50.00.

Read a suggested formula before entering it: identify its input cell references, its operation, and the output cell where it belongs.

Trace the inputs to the output

A diagram showing B2 and C2 feeding into D2 through multiplication.

The formula in D2 uses two source cells and one arithmetic operation.

Read the Week 1 formula

This is the formula stored in D2, not the value displayed after calculation.

spreadsheet formula
=B2*C2

Separate range syntax from locale syntax

Read a SUM range

A range names every cell from its first endpoint through its last endpoint. In D2:D5, the colon means “through,” so the range includes D2, D3, D4, and D5.

In English-language Google Sheets on the web, use =SUM(D2:D5) for total revenue in D6. It adds the numeric weekly revenue values in that one inclusive range. The same baseline formula also works in English-language Excel.

Keep syntax questions separate from calculation questions. In English-US conventions, decimal values use a decimal point. Function names and separators can vary by application language or locale, so check those settings if an otherwise sensible formula is rejected.

Ranges and separators

A colon defines a range. A comma or semicolon separates separate function arguments; it does not replace the colon in a range.

Formula notation depends on what is being listed.
Formula formWhat it usesSyntax check
=SUM(D2:D5)One inclusive rangeNo argument separator is needed
=SUM(D2,D3)Two individual cellsComma in English-US
=SUM(D2;D3)Two individual cellsLocale-dependent separator variant

Check the parts before trusting the result

Identify formula parts

Match each formula part to its role in the Practice worksheet.

Tap an item and then its matching pair.

Apply the formula-reading check

Complete and check the two formulas

For English-language Google Sheets on the web using English-US conventions, complete the weekly revenue formula for D2 and the total-revenue formula for D6.

spreadsheet formula
D2: B2C2
D6: =(D2D5)

Step 4 of 8

Test One Row, Then Check the Copy

Verify the first weekly revenue formula, then confirm that filling it down preserves the intended row-by-row logic.

Verify one row first

Enter and check the first formula

In your own English-language Google Sheets spreadsheet on the web, open the Practice worksheet. Click D2, type the formula below, and press Enter.

Then compare the displayed result with your independent Week 1 check: 10 units at USD 5 each should produce USD 50.00. The formula is a suggestion to verify, not a result to trust automatically.

Week 1 revenue formula

Enter this in cell D2.

Spreadsheet formula
=B2*C2
Expected output
50

The unformatted numeric result is 50. If the cell is formatted as currency, it may display as USD 50.00.

Inputs flow into the revenue cell

A spreadsheet diagram shows B2 with 10 and C2 with 5 feeding a multiplication calculation in D2, which displays 50.

Check that D2 uses the Week 1 inputs, not just that it displays a plausible number.

Check the copied references

Fill down, then inspect the formula

A cell reference without dollar signs is a relative reference. When you fill a formula down one row, each reference shifts down one row too.

Select D2 and drag its fill handle down to D5. If needed, copy D2 and paste into D3:D5; the copied formulas should still shift relative references. Next, select D3 and inspect the formula bar or equivalent formula view—not only the number in the cell.

Week 2 has different inputs: 12 units and USD 5. Its result should be USD 60.00. This second-row check can reveal a formula that was correct in D2 but failed to shift after copying.

Relative references move with the copy

A spreadsheet comparison shows D2 using B2 and C2, then D3 using B3 and C3 after a downward copy.

The formula text must change to the new row's inputs when it is filled down.

Tip

Two checks, not one

Displayed values alone are not enough. For example, a value can look reasonable by coincidence or because it still uses an earlier row. Inspect at least one copied cell in the formula bar and check both its references and its displayed result.

Practice the reference shift

Predict the copied formula

The formula in D2 was filled down exactly one row. Complete the formula that should appear in D3.

Spreadsheet formula
=*

Apply the full check

Document your formula check

In your own Practice sheet, complete the fill-down check before responding. Record:

  1. The formula you entered in D2 and the displayed result you checked.
  2. The formula you predicted for D3 before filling down.
  3. One copied cell (D3, D4, or D5), its formula-bar text, and its displayed result.
  4. A short conclusion: did both the first-row check and the copied-formula check pass? Explain why.

Write at least 120 characters (0/120).

Step 5 of 8

Check What the Total Includes

Validate spreadsheet totals by checking range coverage, selected columns, and an independent addition.

Locate the intended values

Read the total row as a checkable claim

In Practice, rows 2–5 are the complete weekly records. Row 6 is the summary row: B6 totals units sold, while D6 totals revenue. C6 stays blank because unit price is an input, not a total for this task.

Treat a suggested total formula as a claim about two things: which column it uses and which first and last rows it includes. A displayed total alone cannot prove either one.

Keep the columns separate

A worksheet diagram shows units values in column B flowing to B6 and revenue values in column D flowing to D6, while C6 remains blank.

Check the selected column as well as both endpoints of a total range.

Check with simple addition

Reconcile each total

Use independent addition to check a spreadsheet total. The weekly revenue values are USD 50.00, USD 60.00, USD 80.00, and USD 100.00. A correct revenue total must agree with that addition, while the units total must be calculated from the separate units column.

Baseline totals

The source cells and a manual check should point to the same result.

Baseline totals in the `Practice` worksheet
Summary cellIntended source cellsIndependent checkExpected result
B6B2:B510 + 12 + 8 + 1040 units
D6D2:D550 + 60 + 80 + 100USD 290.00
C6NoneDo not add pricesBlank

Example

Formula targets

In English-language Google Sheets on the web, enter each formula separately in its named summary cell. The same formulas work in English-language Excel.

Enter the two summary formulas

Enter the first formula in B6, then enter the second formula separately in D6.

Spreadsheet formula
Cell B6
=SUM(B2:B5)

Cell D6
=SUM(D2:D5)
Expected output
B6: 40
D6: 290

If D6 uses a currency display format, its numeric result may display as USD 290.00.

Spot an omitted row

Diagnose the Short range case

A total can be plausible but incomplete. In the separate Short range case, D6 contains =SUM(D2:D4). It adds USD 50.00 + USD 60.00 + USD 80.00, so it displays USD 190.00.

The formula is syntactically valid; its problem is coverage. Its ending reference stops before the Week 4 revenue row. Check the first endpoint, last endpoint, and column letter—not just whether the result looks believable.

Compare the two range selections

Two revenue-column selections are compared: the faulty selection covers only the first three weekly cells, while the correct selection covers all four.

The faulty selection ends before the fourth weekly revenue cell; the correct selection includes every weekly row.

Tip

Controlled checks matter

Keep diagnostic cases separate. The Short range case changes only the range in D6; the four weekly revenue values remain the baseline values. Restore the baseline before testing another kind of data problem.

Apply the range check

Repair and verify the totals

Complete this diagnostic and repair check for the baseline Practice worksheet. Identify the omitted revenue cell, then complete the units and revenue ranges so each total covers all four weekly rows in the appropriate column.

Spreadsheet formula
Short range omitted: 
B6: =SUM()
D6: =SUM()

Step 6 of 8

Find Missing Values and Text Numbers

Diagnose blank inputs and numeric-looking text entries without confusing them with an incorrect SUM range.

One total, different problems

Use controlled checks

A surprising total is not always a range error. Start each diagnosis from the verified baseline in the Practice worksheet: D2:D5 contains revenue formulas and D6 totals that range.

Change only one thing at a time. After each check, restore the baseline before trying the next case. That makes the changed result traceable to one specific cause.

Two different routes to the same total

A side-by-side spreadsheet diagram contrasts a blank price that makes revenue zero with a displayed revenue value stored as text that SUM ignores.

Both controlled cases can show USD 210.00, but the cells being excluded and the appropriate fixes differ.

Warning

Interpret the two cases

Missing price is not evidence that the price was USD 0.00. In this case, clear C4 while keeping the formula in D4. The multiplication can display zero because a blank input participates in the calculation. Find the verified source price; do not invent a replacement.

Text revenue is different: restore the baseline, then replace the formula in D4 with the text entry '80. It may look like 80, but it is no longer a numeric formula result. SUM ignores text in referenced cells.

Inspect, then correct

Inspect contents before fixing

Check the cell itself, not just its appearance. In English-language Google Sheets on the web, select the suspicious cell and inspect the formula bar or cell contents. Also notice any application warning. A displayed value can hide a blank source input or a number stored as text.

For each controlled case below, restore the verified baseline before starting the next one. Keep D6 as =SUM(D2:D5) unless the case explicitly changes it.

Diagnostic cases

Use these checks in your own Practice sheet. They separate an incomplete range from an input problem and from a displaced formula.

Each row is a separate departure from the baseline.
CaseSingle changeWhat to inspectAppropriate next action
Short rangeD6 uses `=SUM(D2:D4)`Range endpoint and selected columnRestore the intended range through row 5
Missing priceLeave `C4` blankContents of C4; formula remains in D4Seek the missing source price, then enter the verified value
Text revenueReplace D4 with `'80`Formula bar or cell contents; numeric statusRestore the formula in D4, then recalculate

Practice the distinction

Diagnose the departure

Match each controlled case to its cause and the appropriate correction.

Tap an item and then its matching pair.

Apply the controlled checks

Create your diagnostic record

In your own Practice worksheet, perform each controlled case separately and restore the baseline between them. Then write a compact check record:

  1. For Short range, Missing price, and Text revenue, give: case → cause → appropriate correction.
  2. Explain why Missing price and Text revenue can both produce a total of USD 210.00 even though they are different problems.
  3. Report one observation you made by inspecting your sheet, such as a cell's contents, its formula bar, or its range.

Write at least 180 characters (0/180).

Step 7 of 8

Check the Trend Explanation

Check an AI-generated trend explanation against comparable periods, consistent units, and the verified values in the Practice worksheet.

Make a fair comparison

Compare equivalent periods and measures

Before accepting a trend statement, compare like with like. In Practice, each row is one complete, consecutive seven-day period for the same product, so Week 1 through Week 4 can be compared as weekly periods.

Keep the measures separate:

  • Units sold: 10, 12, 8, 10
  • Unit price: 5, 5, 10, 10
  • Revenue: USD 50.00, USD 60.00, USD 80.00, USD 100.00

Revenue rises in every consecutive weekly comparison. That observation does not by itself describe the pattern of units sold or explain why revenue changed.

Read each measure on its own scale

Two separate charts: revenue rises across four weeks, while units rise, fall, and rise again.

Use separate scales for revenue and units. Compare values within the same chart; do not infer that similarly shaped or sized bars across different measures mean the same thing.

Turn values into precise claims

Trace each claim to the sheet

A useful explanation says exactly what is being compared. A total answers a different question from a weekly value, even when both are revenue amounts.

Evidence map

Use the indicated cells as evidence before accepting a statement from an AI assistant.

A range includes both endpoints: `D2:D5` contains all four weekly revenue values.
Type of statementEvidence in PracticeSupported wording
Four-week revenue totalD6 = USD 290.00Revenue across all four weeks was USD 290.00.
First-to-last revenueD2 and D5: USD 50.00, USD 100.00Week 4 revenue was USD 50.00 higher than Week 1.
Every weekly revenue changeD2:D5: 50, 60, 80, 100Revenue increased in each consecutive week.
Units patternB2:B5: 10, 12, 8, 10Units did not increase steadily.

Example

Example: qualify an overclaim

AI draft: “Revenue rose every week, and units sold rose steadily. The change from USD 290.00 to USD 100.00 confirms the weekly trend.”

Checked version: Revenue did rise each week, from USD 50.00 to USD 60.00 to USD 80.00 to USD 100.00. Units did not rise steadily: they were 10, 12, 8, and 10. USD 290.00 is a four-week total, while USD 100.00 is one week, so they are not comparable as a single weekly change.

The table supports observations about values; it does not establish outside causes for the changes.

Practice: separate revenue from units

Check the measure behind the claim

True or false: Because revenue increased in every week, units sold also increased in every week.

Final evidence check

Correct the explanation with evidence

Review this AI draft about the baseline Practice table:

“Revenue improved because the four-week total changed from USD 290.00 to Week 4 revenue of USD 100.00. Units sold increased steadily along with revenue.”

Write a corrected explanation in 2–3 sentences. Include: (1) whether weekly revenue rose in every comparable period, with specific values; (2) the actual units pattern, with specific values; and (3) why the USD 290.00 and USD 100.00 comparison is invalid. State only what the table supports.

Write at least 120 characters (0/120).

Step 8 of 8

Complete a Formula and Explanation Check

Update a small spreadsheet table, verify formula suggestions against independent checks, and write an evidence-supported trend explanation.

Update one input and establish expected results

Update the source, then set your checks

Change only B5 in your local Practice worksheet from 10 to 14. Keep every other source value and every header unchanged.

Before asking an AI for anything, calculate the new checks independently. Week 4 revenue uses the updated units value and the existing Week 4 price. Then reconcile the two totals from all four weekly rows.

This order matters: an AI suggestion is only a candidate. It becomes a checked result after its references, coverage, and displayed values agree with your independent checks.

Updated expected checks

Use these values as independent checks after changing only B5. Monetary amounts are shown in USD for readability; numeric spreadsheet cells should remain numeric.

Independent results for the revised Week 4 input
CheckCellExpected valueReason
Updated inputB514Week 4 units sold
Week 4 revenueD5USD 140.0014 × 10
Total unitsB64410 + 12 + 8 + 14
Total revenueD6USD 330.0050 + 60 + 80 + 140

Trace the revised value through the sheet

A diagram shows B5 changing to 14, producing D5 equal to 140, with all four weekly rows contributing to B6 equal to 44 and D6 equal to 330.

One source change should be traceable to its row calculation and both relevant totals.

Request precisely and inspect the candidate

Revise the request with the new input

Use a revised request that supplies enough context to test the response. For example:

“Using English-language Google Sheets on the web with an English-US formula locale, my worksheet is named Practice. Headers A1:D1 are Week, Units sold, Unit price (USD), and Revenue (USD). The values in A2:C5 are Week 1 | 10 | 5; Week 2 | 12 | 5; Week 3 | 8 | 10; Week 4 | 14 | 10. Give a formula for D2 that I can fill down through D5, a units-total formula for B6, and a revenue-total formula for D6. Use A1-style references. Explain the cells and operations used. I expect D5 to be 140, B6 to be 44, and D6 to be 330.”

The assistant cannot see or edit your sheet. Treat its answer as a suggestion to inspect in your own worksheet.

A candidate response

Candidate AI response to inspect

Google Sheets formula
Enter in D2 and fill down through D5:
=B2*C2

Enter in B6:
=SUM(B2:B5)

Enter in D6:
=SUM(D2:D4)

Warning

Candidate interpretation to inspect

The candidate also says: “Revenue rose every week because units sold increased every week. Total revenue is USD 330.00.”

Do not accept this statement because it sounds confident. Inspect the formula references and compare each trend claim with the updated weekly rows.

Summary

Reusable review sequence

  • Update the independent expected values before reviewing a revised AI response.
  • Check the copied row formula, the units-total column, and both endpoints of the revenue-total range.
  • A formula suggestion and a verified spreadsheet result are different states.
  • Support trend statements with comparable weekly values, and keep units sold separate from revenue.

Test range coverage

Repair the total range

Repair the candidate’s total-revenue formula so its inclusive range covers every weekly revenue cell in D2:D5.

Google Sheets formula
=SUM(D2:D)

Final application and completion

Submit your request-and-check record

Create a concise completion record from your own updated Practice sheet. Include all four parts:

  1. A revised AI request that identifies Google Sheets on the web, the English-US locale, the Practice worksheet, the changed B5 value, the formula destinations, and expected checks.
  2. The range error and the interpretation error in the supplied candidate response.
  3. The values you verified in D5, B6, and D6.
  4. One trend statement supported by the updated values and one claim that the data do not support.

Use values and cell references as evidence, not a general statement that the answer “looks right.”

Write at least 300 characters (0/300).

Tutorial complete

Congratulations! You completed: Requesting and Checking Spreadsheet Formulas

You completed a full request, inspect, test, and explain workflow for an AI-suggested spreadsheet calculation.

Download the App now to have access to + 5000 free courses, exercises, certificates and lots of content without paying anything!

  • 100% free online courses from start to finish

    Thousands of online courses in video, ebooks and audiobooks.

  • More than 60 thousand free exercises

    To test your knowledge during online courses

  • Valid free Digital Certificate with QR Code

    Generated directly from your cell phone's photo gallery and sent to your email

Cursa app on the ebook screen, the video course screen and the course exercises screen, plus the course completion certificate