Create the Reference Cells

Before You Begin: Go to the Pigs sheet. Please select Row 1 and Insert four more Rows. This will give us room to work.

 

1. Try This: Enter the Labels and Data

In Cell A1 type: Price

In Cell A2 type: Start

In Cell A3 type: Increment

 

In Cell B1 type: 3.25.

Format Cell B1 for Accounting.
Keep going, please..

 

Memo to Self: This lesson continues with the Legs Eggs and Pigs spreadsheet:

Legs Eggs and Pigs.xlsx

Home->Cells ->Insert

 

Exam 77-882: Microsoft Excel 2010 Core

5. Applying Formulas and Functions

5.3. Apply cell references in formulas