6th Grade Math Textbook, Fundamentals

Step 1 Enter these headings in row 1.

Cell A1: Length (in.)

Cell B1: Width (in.)

Cell C1: Perimeter (in.)

Cell D1: Area (in.^2 )

Step 2 Enter the length in inches in cell A2 and the

width in inches in cell B2.

Step 3 Enter the formula for perimeter in cell C2.

To enter the formula for perimeter,

type 2*A22*B2. The symbol * is used

for multiplication. This instructs the program

to multiply the value in cell A2 by 2, to

multiply the value in cell B2 by 2, and to

add the results. The spreadsheet calculates

the perimeter as 38 inches.

Step 4 Enter the formula for area in cell D2. To

enter the formula for area, type A2 * B2.

This instructs the program to multiply the

value in cell A2 by the value in cell B2.

After you type in the formula for area, the

spreadsheet automatically calculates the

value for cell D2, the area of the rectangle,

as 78 square inches.

 &KDSWHU

Technology:

Relate Perimeter and Area

Objective To use spreadsheets to calculate perimeter and area of rectangles• To explore the

effect of changing dimensions on perimeter and area of rectangles

You can use a spreadsheet program to find the

perimeter and area of a rectangle. A spreadsheet

program can also help you explore how changing

one or more dimensions affects the area or

perimeter of a rectangle.

Use a spreadsheet program to find the area and

perimeter of a rectangle with a length of 13 inches

and a width of 6 inches.

To enter text into a cell, place the cursor on the cell,

type the information, and press ENTER. Use the arrow

keys (←, ↑, →, ↓) to move from one cell to the next.

The name of the cell your cursor is in appears at the

top left corner of the spreadsheet, above the letter A.

10-12