Excel Instructions for Project 5

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

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

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

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

View Full Document
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).
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).

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

View Full Document
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.
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### What students are saying

• 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.

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

• 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.

Dana University of Pennsylvania ‘17, Course Hero Intern

• 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.

Jill Tulane University ‘16, Course Hero Intern