English Deutsch Français Italiano Español Português 繁體中文 Bahasa Indonesia Tiếng Việt ภาษาไทย
All categories

General rules for entering formulas into a cell:
1.The = sign must precede any formula in Excel.
2.Do not put spaces after the = or between other parts of the formula.
3.The symbol for multiplication is * and for division is /
4.Exponents are written using the ^. For example, c4 becomes c^4.
5.Instead of using an algebraic variable, replace the variable with the name of the cell containing the number to be used. For example, in the formula in cell B3, replace the x with A3.
6.If you do not want the cell name to change as you use Quick Copy, you must “anchor” the cell name. F4 anchored becomes $F$4.
7.After finishing the formula, hit Enter. The calculated value will appear in the cell and the formula will appear in the Formula bar at the top.

Example
You do not have to include this example on your worksheet. The formula for the example is y =3x +5. In cell A2, type x for the column heading, then in cells A3 and A4 put 2 and 4, respectively. Highlight cells A3 and A4, then move the cursor to the lower right-hand corner of A4. When the black + appears, drag down until the small number to the right is 20. You have just used Quick Copy to generate a list of even numbers from 2 to 20 in column A.

In B2, type the column heading y = 3x-5. You are now ready to insert a formula to calculate the corresponding y values for each value in column A.

Enter the formula “y=3x-5” in Excel format into B3, using the rules above. Calculate, by hand, the correct y value for x =2 and check it against the value that appears in B3. [Cell B3 should contain the formula “=3*A3-5” and the output value 1.] Use Quick Copy to drag your formula down to obtain the y values that correspond with the x values in column A.

2007-01-22 03:05:16 · 2 answers · asked by Brandy 1 in Science & Mathematics Mathematics

2 answers

You've given all the instructions for doing this in Excel, but you haven't completed your question. It can't be answered as posted.

"A chef has determined that the cost of preparing a certain menu item is calculated by multiplying the number o..."

2007-01-22 03:55:27 · answer #1 · answered by Puzzling 7 · 0 0

a million. Date one in each and every of them for an hour, i might relatively spend an hour with them, then purely a million kiss. 2. e mail handle, so i can shop up a correspondence with them. 3. it relatively is a annoying one, yet i think of i might relatively have Nick say i'm enormously. 4. Meet them and get hugged, that must be stunning! 5. Haha, i admire this question and the obtrusive answer is marry a Jonas. . . the two Nick or Joe will do, i'm no longer that choosy lol! stable job, I enjoyed it! Cool Survey! i might like to work out yet another! Peace Love Jonas! =]

2016-10-31 23:57:17 · answer #2 · answered by Anonymous · 0 0

fedest.com, questions and answers