Excel Chapter Two v2 - Click to edit Master subtitle style...

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

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

Unformatted text preview: Click to edit Master subtitle style Updated: Excel in Business Chapter Two –Formulas, Functions, Sorting Data, Relative Cell References & Formatting Updated: Learning Objectives: • Basic Data Entry • Formulas & Basic Functions • Sorting Data • Relative / Mixed / Fixed Cell References • Formatting Data 22 Updated: Updated: 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 Updated: 33 Updated: 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 Updated: Updated: 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 Updated: 55 Updated: Complex Formulas • You can make formulas long and as a result, very confusing. Normally when working with any confusing....
View Full Document

This note was uploaded on 09/15/2008 for the course BUS K201 taught by Professor Zandi during the Fall '08 term at Indiana University South Bend.

Page1 / 17

Excel Chapter Two v2 - Click to edit Master subtitle style...

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

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