Using Reference Cells

The next task is to calculate the daily sales. In this example, we will make one Cell Reference in the formula Relative and the other Absolute.

 

Before You Begin: Edit the Data

In Cell B2 type: 100

In Cell B3 type: 5

 

Thoughts to Consider

Cell D6 is the initial quantity sold.

Cell D7 should be whatever we sold on the first day, plus the quantity we are forecasting for each day’s sales increment.

 

6. Try it: Create the Formulas

Select Cell D6 and enter this equation:

 =B2

Select Cell D7, and enter this equation:

 =D6 +B3

 

Try This, Too: AutoFill the Formula
Select Cell D7 and double click the AutoFill handle to fill down the formula. Keep going...

 

Exam 77-882: Microsoft Excel 2010 Core

5. Applying Formulas and Functions

5.3. Apply cell references in formulas: Using Relative and Absolute Cell References