Relative and absolute


show more Relative and absolute provides you with in-depth training on Business. Taught by Mark Swift as part of the Excel 2003 Essential Training show less
please wait ...

Relative and absolute

Well now with BEDMAS behind us and a look at the operators, let's enter some formulas. The first formula that we have here already totals up the first quarter. The value in that cell is 115, 860 but the formula that created it is seen up here in the Formula bar. Very, very simple. We can do the same thing for the second quarter by entering equals, that's the indicator to Excel that we're entering a formula and I'm going to open up a parenthesis here. This is not necessary for this simple of a formula, but it is good practice, so I encourage you to do that. And we're going enter C2 plus C3 plus C4 plus C5, and we'll close that off with a closing parenthesis. You'll notice for each cell reference that I entered into this simple formula the cell was highlighted and it changed color so that you can match up exactly what cells you're referring to in what part of the formula. It's a very handy intuitive feature in Excel.

When I hit Enter, then I get a total...

Relative and absolute
Video duration: 6m 1s 4h 8m Beginner

Viewers:

Relative and absolute provides you with in-depth training on Business. Taught by Mark Swift as part of the Excel 2003 Essential Training

Subject:
Business
Software:
Excel
Author:
please wait ...