# Lesson 26 — Activity 3: Advanced Formulas

#### Now that you have learned how to enter simple formulas into an Excel spreadsheet, you will learn about more advanced formulas in this activity. #### Let's take a look at some other ways of calculating answers to questions using spreadsheets. Typing formulas into cells can be a lot of work, especially if there are a lot of numbers. Another way is to combine typing and using your mouse to enter a formula into a cell. This formula is called =SUM. Let's say you need to add the numbers in column A and put the answer in B3. #### Place the cursor in cell B3, and you will see a box opens up. Click on this symbol Σ at the top right-hand side of the toolbar. Click on cell B4 and this is what should appear =SUM(). In between the brackets, type in the first cell number, then a colon, and then type in the last cell name. You should now have an equation that looks like this: =SUM(A1:A4). Hit enter and the sum of all of the numbers in cells A1 to A3 automatically appear!  #### Another formula that you could use is called =AVERAGE. This formula lets you figure out the average of a group of numbers. If you wanted the average of the numbers in column A of the spreadsheet above, you would simple move to the cell you want the answer in and create your formula. You must choose a different cell to B3. The steps to use in this formula are exactly the same as for =SUM except for Step 2. This is the new Step 2: scroll down on the arrow beside this symbol Σ and click on the word Average. Then follow Steps 3, 4, and 5. You should end up with this formula: =AVERAGE(A1:A3) (NOTE: Ignore any moving lines, etc. that may appear. If you enter the formula correctly, these will disappear when you hit enter.) What good is a formula like this? You could use it to figure out an average temperature, the average amount of calories you are eating, or your mark in a class! 