Formulas

In the previous lesson, the focus was on naming the cells that are included in a formula. We looked at the difference between Relative and Absolute Cell References. This lesson will use formulas to calculate, compare and format Text. We will also use formulas to summarize the data.

 

I know, I know: the mere thought of formulas sends folks out the door. I believe that math is taught very poorly and that most people do NOT have a comfortable understanding of the rules and options. This lesson will include a discussion of the math as well as what the spreadsheet software can do.

Start -> All Programs ->Microsoft Office -> Excel

 

   

What Do You See? Is there a Title Bar that says Book 1-Microsoft Excel? Yes.

Is there a Home Ribbon with the Clipboard, Font and Alignment Groups? Yes.

If your screen looks similar to the example on this page, then you are ready to get started.