Exceltutorial

Exceltutorial - FBE 391: Excel Tutorial Professor Seslen...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
FBE 391: Excel Tutorial Professor Seslen September 8, 2004 Inputting formulas: Go to cell of interest, and type “=” (an equal sign) OR click the “fx” button next to the input bar above the column headers to get Excel into formula mode. If you want to type in formula of pure numbers that are not already contained in your worksheet, type them in as you would into a calculator. Use “*” for multiplication, “/” for division, “^” for exponents, and “( )” to group expressions. For example: typing =5*5 will put 25 into the cell =5*5+5 will put 30 into the cell =5*(5+5) will put 50 into the cell =5^3 will put 125 into the cell and =5/(5^2-5) will put .25 into the cell Be careful using the arrow keys once you have typed the equal sign into your cell. If you make a mistake typing your formula, you should use the Backspace key to make changes from the end of the formula, or use the mouse to reposition the cursor. Using the arrow keys will activate a pointer that will automatically input the location of that pointer into your formula. To see how this works, type the number 5 into cell A1 and the number 2 into A2. Now move to cell B1. To multiply cell A1 by cell A2, and put the answer in B1, type “=” in B1, and hit the left arrow key once. There will be a flashing dotted border around A1. Hit “*”, which will indicate multiplication and at the same time reset the pointer. A solid colored border will appear around the selected cell. Then hit the left arrow key once, followed by the down arrow key once. Cell A2 should be highlighted. Then hit Enter. The value 10 should appear. Some helpful tricks/shortcuts: To generate a long list of numbers, each some constant value or constant multiple larger/smaller than the one before, we can do the following: 1. Put the first value in the first cell 2. Put the second value in the second cell, using a formula based on the value in the first cell. i.e. If you want to generate a list of 1,2,3,….,98,99,100, put 1 in cell A1, and =A1+1 in cell A2. Reposition the cursor over cell A2 so that there is a heavy black border around cell A2, with a little square in the lower right-hand corner. Click on the square and drag it downward, so that cells A2-A100 have a gray border and release the mouse. Cells A3-A100 will automatically fill with the implied formula of “cell n = cell n-1 + 1.” You can use this same technique to fill horizontally, or m-by-n blocks of cells at a time.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
“Freezing” a cell in a formula: Say you use the above technique to create two lists of numbers, multiples of 5 in column A and multiples of 6 in column B and want to add them together in column C. In column C1, you would type =A1+B1, and then use the same drag-and-fill technique used to
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 5

Exceltutorial - FBE 391: Excel Tutorial Professor Seslen...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online