computer application question? excel question?

Question

How do you write a formula?

How do you troubleshoot a formula?

both of the question are excel question so do you know any good information on the website or know good answer or example.

Answer 1

A formula always begins with the = sign. When you enter the = sign in a cell, Excel knows you are asking a question. Excel will attempt to evaluate the formula you have put in the cell, and produce the answer. The formula could be a simple piece of math like

=1+1

or it could be a bunch of references to other cells

=A1+A2

or it could use one or more of Excel's many inbuilt FUNCTIONS. Excel has nearly 200 different functions covering math, dates, statistical data, text, logical data etc. You can even design your own functions (if you know how to use Excel's programming language, Visual basic).



You must enter your formulas in the correct way, otherwise you will get an error message. Excel has several ways of troubleshooting formulas. It will ask you for input at each stage of entering the formula. It will try to correct your formula if you make a mistake - like not putting enough brackets, or not putting in the = sign at the beginning.. You can ask for help on each function by pressing F1. There is also an evaluation tool which examines your formula in more detail.

Answer 2

http://www.mrexcel.com/articles.shtml Scroll down to Formulas in Excel.

Answer 3

I took Algorithm Development last semester, it was fun! Any programming or Computer classes, you never really said if you were in High School or College.

Answer 4

if you have office 2007 or excel 2007 its pretty much self explanatory. it even got a formula for dummies button

Answer 5

There's an interesting invention that exists on the internet named "Google".

I suggest using it.