Microsoft excel?

Question

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?

Answer 1

The best place to start is by clicking th Fx (function) button in the upper left...

Answer 2

Formulas are equations that perform calculations on values in your worksheet. A formula starts with an equal sign (=). For example, the following formula multiplies 2 by 3 and then adds 5 to the result:

=5+2*3

That was straight from the help menu in excell.

Also when you type [=] and look in the upper left corner above the A1 cell there is a pull down menu - usually "sum" is the default, but there are other options, like average, if, hyperlinking and so on, additionally there is also an option for more functions - this will take you to more formula options.

I also use the click the cell for creating formulas instead of typing them - more automated and less likely for a type o'.

One other thing to mention when creating formulas - if you need to copy and paste the results of a formula - sometimes you like have an "error" come up because you have moved the outcome from the original place - if you are copying and pasting - use the "paste special" and paste as values - this will paste the value instead of the formula.

Hope this helps!

Answer 3

The easiest way to enter a formula is by clicking on a cell and typing an equal-sign (=).

A list of formulas is available by using the f(X) button. Most have short descriptions and the help button is pretty well structured.

I wouldn't recommend using a mouse to enter formulas as this takes a longer time and after a couple of repetitions it can get tiring. It's easier on your wrist to move around with the arrows on the keyboard and to type directly into the cell. This applies not only to formulas, but also to text or values.

Your best bet it by starting with short formulas such as =2+2.

The next step is to start adding cells.

=A1+A2

Finally, you can start with simple formulas:

=sum(A1,A2)

You can also define a range by using the colon (:)

=sum(A1:A3)

Remember you should keep cells from refering to themselves to avoid causing circular references.

Hope this refreshes your memory.

Answer 4

Lemme wager, you are in a Computer Literacy elegance... perhaps with the Art Institute??? Because whats humorous is that is the EXACT query of this weeks first challenge. bizarre. "Week three: Week three - W3: Assignment a million Discussion Discussion Question three Compare Microsoft Word, Microsoft Excel, and Microsoft PowerPoint. When will have to you employ each and every of those packages? When are you able to use those packages interchangeably? Give examples and causes to help your reply."

Answer 5

Always start a formula with = (the equal sign). If you want the formula to add 20 + 30, for instance, your formula would look like this:

=sum(20+30)

The result will appear in the same cell that you enter the formula.

If you have "20" in cell no. B4, for instance, and "30" in cell B5, and you want to add them up, your formula for the same result will look like this:

=SUM(B4:B5)

This is just for adding up. Use the * sign for multiplying, the - sign for subtraction, and the / sign for division. Otherwise look in the "Help" for more complex formulas.

Hope this helps.

Answer 6

There are many ways to do this. I usually enter them myself. For example @sum(a1.c5)

Answer 7

if you have colums you wish to add you would do =sum(a1:a20) and place this in column a21 would give you the answer