HB473_1-1_FORMULA_SEP7

HB473_1-1_FORMULA_SEP7 - Formulas BasicFormulas...

Info iconThis 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
Background image of page 1

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

View Full DocumentRight Arrow Icon
Background 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
Background image of page 3

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

View Full DocumentRight Arrow Icon
Operation Addition Subtraction Division ( ÷ ) Multiplication ( × ) Power/ Exponent
Background 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 spre - Typing computed results into a spreadsheet com eliminates Excel’s cell referencing capabilities.
Background image of page 5

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

View Full DocumentRight 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 t Sales  adsheet. pletely
Background image of page 6
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. 
Background image of page 7

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

View Full DocumentRight 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:
Background 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
Background image of page 9

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

View Full DocumentRight Arrow Icon
Background 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 
Background image of page 11

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

View Full DocumentRight Arrow Icon
Image of page 12
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 09/10/2010 for the course IAH 001 taught by Professor Wang during the Spring '10 term at Michigan State University.

Page1 / 35

HB473_1-1_FORMULA_SEP7 - Formulas BasicFormulas...

This preview shows document pages 1 - 12. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online