Week 5: Clear

             The concept that was most clear to me this week was creating formulas in Excel. The key to putting in formulas is they must begin with an equal sign. PEMDAS is important for formulas because it is the order of operations. It stands for Parenthesis, Exponentiation, Multiplication, Division, Addition, and Subtraction. A good way to remember this acronym is Please Excuse My Dear Aunt Sally. Multiplication and division are done from left to right, whichever comes first, and addition and subtraction are done together in this same manner. Excel uses + for addition, - for subtraction, * for multiplication, and / for division.
          Excel is very important in the business environment because it makes the process of performing math problems very easy. You can type in a formula that you need for an entire column based off of other columns and simply drag the bottom right corner down and the relative relationship remains the same. This saves alot of time, making Excel a helpful tool in any line of business that requires many computations.
         This website relates to the concept of creating formulas in Excel and even has a table showing the different formulas that can be entered using some sample data. This website goes a step further and shows formulas for exponentiation, square roots, cube roots, increasing/decreasing by a percentage, calculating percentages, and averages. It shows the exact formula that would be typed into Excel, beginning with an equal sign. This is an additional website that is basically a "how to" for creating Excel formulas and uses a basic addition and subtraction equation as an example. Here is an an example of how a formula is created and used in Excel:

Works Cited

http://www.cob.sjsu.edu/splane_m/excelformulas.htm

http://www.ehow.com/how_9699_create-excel-formula.html

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiZa5oHig35Ol_MosDScXI2B4awz6NSKaM2fPZCn4tfhWZapCWjYkPPQ5j0OO4Aqz6qW9lFj6YvbLWMXYuuGkbHs203I3XRdnOkhSmBjFkNXQMzqEu5vsxd9t4ODTLw36tAFB8MW0cSay8o/s400/WMA+Weights+Excel+Formula.jpg