Featured
- Get link
- X
- Other Apps
Introduction to excel functions
Introduction to functions
Functions give you the ability to do a variety of things, like perform mathematical operations, lookup values, or even calculate dates and times. Let's try a few ways to add up values with the SUM function.
1.Under the Amount column for Fruit (cell D7), enter =SUM(D3:D6), or type =SUMC then select that range with the mouse and press Enter. This will sum the values in cells D3, D4, D5. and D6. Your answer should be 170.
2.Now let's try AutoSum. Select the yellow cell under the column for Meat (cell G7), then go to Formulas AutoSum select SUM. You'll see Excel automatically enter the formula for you. Press Enter to confirm it. The AutoSum feature has all of the most common functions.
3.Here's a neat keyboard shortcut. Select cell D15, then press alt & = then, Enter. This automatically enters SUM for you.
Comments
Post a Comment