Wednesday, August 18, 2010

Microsoft excel (confused_?

Microsoft excel?



I use to be a pro at Microsft excel,.. but i have not worked in a while and i cant remember jack,.. can someone talk me on how to enter a simple formula, maybe this will help me get my memory back,.. i use to use my mouse to enter formula's as oppose to typing them in,.. ? does that make sence?



Microsoft excel (confused_?virus scan



.



I understand. Am in the same boat...just getting back to work after many years.



1. Open Excel



2. Enter data in cells



3. You must highlight all cells you want totaled.



4. To highlight click the first cell you want added %26gt; then hold down keyboard SHIFT key %26gt;



then click below last cell, in an empty cell where total will appear.



You may total several columns at the same time.



To total a row, drag across the row.



In above tool bar click the ''sum'' button



(it looks Greek like a backwards E



5. To see the formula Click in cell where the answer appears and look above



6. You will see the ''sum formula'' in the long white text box for ''Insert Function''



In that text box you can type in and can change your formula for the area you want it to cover by changing the formula to



one column



[example] =SUM(A1:G1)



one row



[example] =SUM(A1:A8)



several columns



[example] =SUM(A1:G8)

No comments:

Post a Comment