graphic1

 

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 good 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 Microsoft Excel.
When the Welcome screen appears, open a new, blank workbook.

What Do You See from the top of the screen?

Is there a Home Ribbon? And the Insert, Page Layout, Formulas, Data. Review and View Ribbons as well? Yes.

Then you are ready to go.