{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

HB473_1-1_FORMULA_SEP7

# HB473_1-1_FORMULA_SEP7 - Formulas BasicFormulas...

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

Formulas Basic Formulas Copying and Pasting Formulas Complex Formulas Auditing Formulas

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

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

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

View Full Document
Operation Addition Subtraction Division ( ÷ ) Multiplication ( × ) Power/ Exponent
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.

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

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

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

View Full Document
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:
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

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

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

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

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