Connected Sheets (BigQuery) in Google Sheets - Cell-by-Cell Formula Trace

Sample Data

This sheet shows sales data for different fruits imported from BigQuery using Connected Sheets.

Cell	Value
A1	Product
B1	Sales
A2	Apples
B2	150
A3	Oranges
B3	200
A4	Bananas
B4	120

Formula Trace

=SUM(B2:B4)

Step 1: B2:B4

Step 2: SUM(150, 200, 120)

Cell Reference Map

    A       B
1 |Product |Sales |
2 |Apples  | 150  |
3 |Oranges | 200  |
4 |Bananas | 120  |

Arrows: B2 -> SUM, B3 -> SUM, B4 -> SUM

The formula SUM(B2:B4) uses the sales values from cells B2, B3, and B4.

Result

    A       B
1 |Product |Sales |
2 |Apples  | 150  |
3 |Oranges | 200  |
4 |Bananas | 120  |
5 |Total   | 470  |

The total sales value 470 is shown in cell B5, calculated by summing B2 to B4.

Sheet Trace Quiz - 3 Questions

What does the formula =SUM(B2:B4) calculate?

A The total sales of all fruits

B The average sales of all fruits

C The sales of Apples only

D The number of fruits listed

Key Result

SUM(range) adds all numbers in the specified range.