Menu

Tech

English

Recap: First Formulas

Part of the Fundamentals section of Coddy's Excel journey. Lesson 16 of 42.

Challenge

Medium

The rectangle's Width is in B1 and its Height is in B2.

In B4 (next to the Area label): a formula for width times height
In B5 (next to the Perimeter label): a formula for width plus height, all multiplied by 2, you'll need parentheses

Use cell references so the formulas survive a change of rectangle.

Try it yourself

Sheet1

	A	B	C	D	E	F	G
1	Width	5
2	Height	3
3
4	Area
5	Perimeter
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 A10 Recap: 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 OperationsRecap: First Formulas

6Working with Text

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