{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Excel Chapter Two v2 - Excel in Business Chapter Two...

Info iconThis preview shows pages 1–7. Sign up to view the full content.

View Full Document Right Arrow Icon
Click to edit Master subtitle style   5/12/09  Updated:  30-Dec- Excel in Business Chapter Two –Formulas, Functions,  Sorting Data, Relative Cell  References & Formatting
Background image of page 1

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

View Full Document Right Arrow Icon
  5/12/09  Updated:  30-Dec- Learning Objectives: Basic Data Entry Formulas & Basic Functions Sorting Data Relative / Mixed / Fixed Cell References Formatting Data 22
Background image of page 2
  5/12/09  Updated:  30-Dec- Basic Data Entry Basic Data Entry is straightforward Position the cursor on the cell you wish to enter  data in Type in the data – remembering the rules about  what is numeric and what is alphanumeric! Hit the enter key, or move the cursor to a new cell AutoFill – a fast and effective way to fill in  patterns 33
Background image of page 3

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

View Full Document Right Arrow Icon
  5/12/09  Updated:  30-Dec- Basic Formulas All formulas begin with the “=“ sign. Formulas can combine specific numbers entered  in the formula with cell references. Formulas always follow the precedence order =(a7+b7)*c7 may not be the same thing as  =a7+b7*c7 Do not confuse formulas with functions! 44
Background image of page 4
  5/12/09  Updated:  30-Dec- What is “Precedence Order”? All math, in all computers, is done in algebraic  order.  You must remember this order to ensure  formulas work correctly Anything inside parenthesis is done first Exponentiation is second  Multiplication is third, division is fourth Addition is fifth and subtraction last 55
Background image of page 5

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

View Full Document Right Arrow Icon
  5/12/09  Updated:  30-Dec- Complex Formulas You can make formulas long and as a result, very  confusing.  Normally when working with any  kind of analysis, simple is better than complex!
Background image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}