Menu

Tech

English

Recap: Cell References

Part of the Fundamentals section of Coddy's Excel journey — lesson 21 of 42.

Challenge

Medium

The invoice lists two items in rows 2-3, with Price in column B and Qty in column C.

In D2: the subtotal for Pens, price times quantity
In D3: the subtotal for Paper, same pattern, row 3
In D5 (next to the Total label): the two subtotals added together, reference D2 and D3, not the prices

Prices and quantities will change during testing, so reference the cells everywhere.

Try it yourself

Sheet1

	A	B	C	D	E	F	G
1	Item	Price	Qty	Subtotal
2	Pens	3	4
3	Paper	5	2
4
5	Total
6
7
8
9
10
11
12
13
14

All lessons in Fundamentals

1Meet the Spreadsheet

What Is a Spreadsheet?Cells and References Your First Cells Rows, Columns and the Grid Recap: Meet the Grid

4Cell References

Referencing Other Cells Formulas That Update Chained Formulas Ranges from A1 to A10Recap: Cell References

7Decisions with IF

The IF Function Writing an IF Comparison Operators Nested IFs Recap: Decisions with IF

2Entering Data

Text and Numbers Building a Small Table Editing and Clearing Cells Numbers That Mean Something Recap: Entering Data

5Basic Functions

What Is a Function The SUM Function The AVERAGE Function MIN and MAX COUNT and COUNTA Combining Functions Recap: Basic Functions

8Project: Grade Book

Grade Book Setup Totals and Averages Pass or Fail with IF Finishing the Grade Book

3Your First Formula

What Is a Formula?Writing a Formula Formulas with Cells Arithmetic Operators Order of Operations Recap: First Formulas

6Working with Text

Joining Text UPPER and LOWER Measuring Text with LEN LEFT, RIGHT and MID Recap: Working with Text