1 / 30

Your Guide to learning about Excel formulas.

Your Guide to learning about Excel formulas. Choose Your Learning Channel!. Lesson. Guided Practice. Quiz. Jessica Potter Binko. Excel Formulas Lesson. What are formulas? Excel’s version of mathematical equations Performs all sorts of problems Particularly useful in business math

sarai
Download Presentation

Your Guide to learning about Excel formulas.

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Your Guide to learning about Excel formulas. Choose Your Learning Channel! Lesson Guided Practice Quiz Jessica Potter Binko

  2. Excel Formulas Lesson • What are formulas? • Excel’s version of mathematical equations • Performs all sorts of problems • Particularly useful in business math • Cumulative sales totals • Inventory orders • Client management Next Slide

  3. Excel Formulas Lesson Formula Structure Regular Math Problem Set-Up Excel Math Problem Set-Up 2+2= =2+2 • All Excel formulas begin with an equal sign. Otherwise, the software will have no way of knowing you want to do math. Next Slide Next Slide

  4. Excel Formulas Lesson Cell Reference • Cells have unique names. They are referenced by their column letter and row number. cell A1 Next Slide

  5. Excel Formulas Lesson Cell Ranges • Excel identifies a range by the cells in the upper left and lower right corners of the range. • You use a colon to signify a range in a formula. • For example, range A1:B3 includes cells A1, A2, A3, B1, B2, and B3. Next Slide

  6. Excel Formulas Lesson Mathematical & Reference Operators • You can use mathematical and reference operators in Excel to build formulas. Basic operators include the following: Next Slide

  7. Excel Formulas Lesson Please Excuse My Dear Aunt Sally… When you are creating equations, the order of operations determines the results. For example, suppose you want to determine the average of values in cells A2, B2, and C2. =A2 + B2 + C2/3 = WRONG RESULTS =(A2 + B2 +C2)/3 = CORRECT RESULTS Next Slide

  8. Excel Formulas Lesson Common Functions • Tells Excel what type of math problem you want to solve. • Goes right after the = sign. • Example: =FUNCTION(Math Problem) Next Slide

  9. Excel Formulas Lesson More Common Functions • Goes right after the = sign. • Example: =FUNCTION(Math Problem) Next Slide

  10. Excel Formulas Lesson How to Apply a Function to Create a Formula Manually • You can just type the type of function that you want into the cell of a formula and get the desired results. Next Slide

  11. Excel Formulas Lesson How to Apply a Function to Create a Formula “Insert Function” Dialog Box • Click the “Formulas” tab. • Select the type of math problem you are performing out of the function library. • Choose the proper function. Next Slide

  12. Excel Formulas Lesson Worksheet Errors • Several times when you attempt formulas, you will receive an error message.

  13. Guided Practice Proper Formula Syntax =SUM(A4:A8) Parentheses: Signifies the order of operations. An Equal Sign always starts out an Excel equation. Range Operator: This formula includes cells A4, A5, A6, A7, and A8 Cell Reference Name: The column letter corresponds with the row number. The Function: Tells Excel what kind of math problem you want to do. Next Slide

  14. Guided Practice Fill in the missing function Answer each question on a blank sheet of paper. Click your mouse to discover the correct function. • =_____(2+2) • =_____(2-2) • =_____(2*2) • = _____(2/2) • SUM • SUM • PRODUCT • QUOTIENT Next Slide

  15. Guided Practice Fill in the Blank Answer each question on a blank sheet of paper. Click your mouse to discover the correct answer. • The first thing you put in a cell to tell Excel you want to do a math problem. • Signifies that you want to include a range of cells. • Tells the name of the cell. • = • : • Cell Reference Next Slide

  16. Guided Practice Set it up What is the proper syntax for calculating the average of cells A1, A2, A3, A4, and B3? =AVERAGE(A1:A4, B3) Next Slide

  17. Guided Practice Cell Reference Give the number for each cell reference name. A3 A6 B2 B5 • 21 • 45 • 12 • 19

  18. Quiz Excel Formulas Quiz • Directions: Get out a blank sheet of paper and pencil. Write the letter that corresponds with the best answer to complete each question. Do not go back over the lesson portion of the PowerPoint. You may not use any notes on the quiz. Questions are worth 2 points each for a grand total of 20 points. • Begin when you’re ready. Begin

  19. Quiz 1. What is the first thing you place into a cell when creating a formula? A.) A Number B.) An Operator (Ex: +,-,/,*) C.) An Equal Sign D.) A Function (Ex: SUM) Next Slide

  20. Quiz 2. What is the proper syntax for adding cells A1, A2, A3, A4, and A5? A.) A1:A5= B.) SUM=A1:A5 C.) =SUM(A1:A5) D.) PRODUCT(A1:A5) Next Slide

  21. Quiz 3. What cells are included in B2: B5? A.) B2, B3, B4, B5 B.) B2, B5 C.)B1, B2, B3, B4, B5 D.)B4, B5 Next Slide

  22. Quiz 4. What is the first order of operations? A.) Exponents B.) Division C.) Multiplication D.) Parentheses Next Slide

  23. Quiz 5. What is the proper function for calculating averages? A.)AVERAGE B.)AVGE C.)SUM D.)QUOTIENT Next Slide

  24. Quiz 6. If the ‘#####’ error message reads in a cell where you inserted a formula, what should you do to correct the problem? A.)Check the function for an unacceptable argument. B.) Check to make sure the formula referenced is the correct value. C.) Double-check arguments and operands. D.) Increase column width. Next Slide

  25. Quiz 7. Which function is most appropriate for a subtraction problem? A.) PMT B.) DIFFERENCE C.) RATE D.) SUM Next Slide

  26. Quiz 8. Which function is most appropriate in figuring out your monthly car payment? A.) AVERAGE B.) PMT C.) RATE D.) SUM Next Slide

  27. Quiz 9. In formulas, what is the comma’s ( , ) role? A.) Range Operator. It evaluates the entire range of cells. B.) It signifies to Excel that you want to perform a problem. C.) Union Operator. It evaluates noncontiguous cells. D.) Financial Operator. It evaluates loans, interest, and principle. Next Slide

  28. Quiz 10. Why are parentheses used in formulas? A.) To differentiate from the function and formula. B.) To show Excel which part of the formula to complete first. C.) To separate different cell references. D.) To let Excel know exactly what type of calculation you’re performing. Next Slide

  29. Quiz Friendly Reminders • Make sure your name is on your quiz. • Make sure the quiz is labeled with the date. • Make sure all problems are labeled 1-10. • Turn in your quiz and return to your seat. • Remain quiet until all classmates are finished with the quiz. Find out where I got my information

  30. Citations 1. Harville, Lindsey. Lindsey Harville’s EDM 310 Class Blog. 11 Dec. 2011. Web. 15 Sept. 2012. 2. Isard, Debbie Wohl. Attention Debbie Dear. 3 April 2011. Web. 15 Sept. 2012. 3. Shoup, Kate. Microsoft Office 2010 Simplified. Ed. Jody Lefevere. Indianapolis, Indiana: Wiley Publishing, Inc, 2010. Print. 4. ThinkQuest. Oracle Education Foundation. 2000. Web. 15 Sept. 2012.

More Related