{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

HB473_1-1_FORMULA_SEP7 - Formulas BasicFormulas...

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

View Full Document Right Arrow Icon
Formulas Basic Formulas Copying and Pasting Formulas Complex Formulas Auditing Formulas
Image of page 1

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

View Full Document Right Arrow Icon
Image of page 2
Basic Formulas Most basic method of  performing calculations Basic formulas are defined  as any equations that consist  of two variables separated by  a mathematical operator. Figure 3.1 shows  Mathematical operator  symbols used in Excel. Symbol O + A - S / D * M ^ P
Image of page 3

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

View Full Document Right Arrow Icon
Operation Addition Subtraction Division ( ÷ ) Multiplication ( × ) Power/ Exponent
Image of page 4
Gross Sales Returns Net Sales Cost of Goods S Gross Profits Gross Sales - Re How to Produce Formula:Net  Must begin with equal (=)  sign If = sign is omitted, I10 – I11 will be  displayed in I12. By using cell references Any value typed into cell I11 will be  subtracted from any value typed in  cell I10. Common mistakes : U sing a calculator and typing the result into a sprea - Typing computed results into a spreadsheet com eliminates Excel’s cell referencing capabilities.
Image of page 5

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

View Full Document Right Arrow Icon
Financial Plan 2008 2009 2010 $100,000,000 $110,000,000 $115,000,000 $4,000,000 $550,000 $600,000 $410,000,000 $451,000,000 $430,000,000 $54,000,000 $59,400,000 $59,900,000 eturns = Net Sales  Sales  eadsheet. pletely
Image of page 6
Copying & Pasting Form Relative Reference Relative referencing will  adjust cell references. Without relative referencing, you  would have to retype every formula  in a worksheet even though it may  be performing the same  mathematical function.  Notice changes in row numbers  for the cell references. 
Image of page 7

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

View Full Document Right Arrow Icon
Hotel Global Performance in July 2010 Region Occ % ADR RevPAR Americas 67.9% 100.93 Asia Pacific 67.3% 124.69 Europe 70.9% 131.39 Middle East/Africa 61.3% 145.00 RevPAR = Occ * ADR mulas:
Image of page 8
Monday Tuesday Wednesday Thursday Friday Paste Specials Contains a few commonly  used commands from the  Paste Special dialog box  Key Options Formats All except borders Formulas Transpose
Image of page 9

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

View Full Document Right Arrow Icon
Image of page 10
Item Cell Phone 2.75 Fuel Cost per Gallon Complex Formulas Any equations that consist  of more than two variables  and requires two or more  mathematical operators are  complex. Order of mathematical  operations will impact  calculations.  - Excel executes each  division operation in order it  appears in the formula from  left and right.
Image of page 11

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

View Full Document Right Arrow Icon
Image of page 12
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