Excel Instructions for Project 5 - The order of operations...

Info icon This preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon
The order of operations Excel calculates formulas based on the following order of operations : 1. Operations enclosed in parentheses 2. Exponential calculations (to the power of) 3. Multiplication and division , whichever comes first 4. Addition and subtraction , whichever comes first A mnemonic that can help you remember the order is P lease E xcuse M y D ear A unt S ally. Example 1 The following example demonstrates how to use the order of operations to calculate a formula: Example 2
Image of page 1

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

View Full Document Right Arrow Icon
In this example, we'll review how Excel will calculate a complex formula using the order of operations. The selected cell will display the percent of total Pete Lily seeds sold that were white. 1. First, Excel will calculate the amount sold in parentheses: (19*1.99)=37.81 White Pete Lily seeds and (33*1.99)=65.67 Total Pete Lily seeds. 2. Second, it will divide the White Pete Lily seeds amount by the Total Pete Lily seeds amount: 37.81/65.67=.5758 . 3. Last, it will multiply the result by 100 to obtain the value as a percent: .5758*100=57.58 . Based on this complex formula, the result will show that 57.58% of the total Pete Lily seeds sold were white. You can see from this example that it is important to enter complex formulas with the correct order of operations. Otherwise, Excel will not calculate the results accurately. To create a basic function in Excel: 1. Select the cell where the answer will appear ( F15, for example). 2. Type the equals sign (=) , then enter the function name ( SUM , for example).
Image of page 2
3. Enter the cells for the argument inside the parentheses. 4. Press Enter , and the result will appear. Excel will not always tell you if your function contains an error, so it's up to you to check all of your functions. To learn how to do this, read the Double-Check Your Formulas lesson from our Excel Formulas tutorial. Using AutoSum to select common functions The AutoSum command allows you to automatically return the results for a range of cells for common functions like SUM and AVERAGE. 1. Select the cell where the answer will appear ( E24 , for example). 2. Click the Home tab. 3. In the Editing group, click the AutoSum drop-down arrow and select the function you want ( Average , for example).
Image of page 3

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

View Full Document Right Arrow Icon
4. A formula will appear in E24 , the selected cell. If logically placed, AutoSum will select your cells for you. Otherwise, you will need to click the cells to choose the argument you want.
Image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern