Loading to worksheet or data model in Excel - Cell-by-Cell Formula Trace

Sample Data

This table shows product names and their sales figures.

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

Formula Trace

=SUM(B2:B4)

Step 1: B2:B4

Step 2: SUM(100, 150, 200)

Cell Reference Map

    A       B
1 Product  Sales
2 Apples   100
3 Bananas  150
4 Cherries 200

Formula references cells B2, B3, and B4 for sales data.

The formula sums the sales values from cells B2 to B4.

Result

    A       B
1 Product  Sales
2 Apples   100
3 Bananas  150
4 Cherries 200
5 Total    450

The sum of sales (450) is shown in cell B5 labeled as Total.

Sheet Trace Quiz - 3 Questions

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

A The average sales of all products

B The total sales of all products

C The sales of the first product only

D The difference between highest and lowest sales

Key Result

SUM(range) adds all numeric values in the specified cell range.