Excel07_L1_Ch2

Excel07_L1_Ch2 - EXCEL 2007 Chapter 2 LINKSTO OBJECTIVES FormulaBar CopyaFormula Microsoft Excel 2007 Level 1 FeaturesSummary BACK NEXT EN D 2-1

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

Copyright 2007, Paradigm Publishing Inc. EXCEL 2007 Chapter 2 BACK NEXT EN 2-1    LINKS TO  OBJECTIVES Mathematical Oper Formula Bar Copy a Formula Insert Function Fea Write Formulas with Absolute and Mixed Features Summary Microsoft Excel 2007 – Level 1 INSERTING FORMULAS  IN A WORKSHEET

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

View Full Document
Copyright 2007, Paradigm Publishing Inc. EXCEL 2007 Chapter 2 BACK NEXT EN 2-2    LINKS TO  OBJECTIVES Mathematical Oper Formula Bar Copy a Formula Insert Function Fea Write Formulas with Absolute and Mixed Features Summary Performance Objectives Performance Objectives Write formulas with mathematical operators Type a formula in the Formula bar Copy a formula Use the Insert Function feature to insert a formula in a cell Write formulas with the AVERAGE, MAX, MIN, COUNT, PMT, FV, DATE, NOW, and IF functions Create an absolute and mixed cell reference
Copyright 2007, Paradigm Publishing Inc. EXCEL 2007 Chapter 2 BACK NEXT EN 2-3    LINKS TO  OBJECTIVES Mathematical Oper Formula Bar Copy a Formula Insert Function Fea Financial Functions Absolute and Mixed Features Summary Mathematical Operators Mathematical Operators + Addition - Subtraction * Multiplication / Division % Percent ^ Exponentiation Order of Operations Negation Percent Exponentiation Multiplication, Division, left to right Addition, Subtraction , left to right Use parentheses to override the  Order of Operations

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

View Full Document
Copyright 2007, Paradigm Publishing Inc. EXCEL 2007 Chapter 2 BACK NEXT EN 2-4    LINKS TO  OBJECTIVES Mathematical Oper Formula Bar Copy a Formula Insert Function Fea Financial Functions Absolute and Mixed Features Summary Writing Formulas Writing Formulas Begin with the equal (=) sign Then type remainder  of formula Select cell that is to contain a formula
Copyright 2007, Paradigm Publishing Inc. EXCEL 2007 Chapter 2 BACK NEXT EN 2-5    LINKS TO  OBJECTIVES Mathematical Oper Formula Bar Copy a Formula Insert Function Fea Financial Functions Absolute and Mixed Features Summary Typing in the Formula Bar Typing in the Formula Bar Formulas can also be entered directly in the Formula bar Formula bar always displays formula, while active cell displays the formatted result of the  formula

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

View Full Document
Copyright 2007, Paradigm Publishing Inc. EXCEL 2007 Chapter 2 BACK NEXT EN 2-6    LINKS TO  OBJECTIVES Mathematical Oper Formula Bar Copy a Formula Insert Function Fea Write Formulas with Absolute and Mixed Features Summary Copying Cells or a Formula Copying Cells or a Formula 1. Select cells to copy from 3. Select area to  into 2. Click Copy button or press  Ctrl + C 4. Click Paste  button or press  Ctrl + V

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.

This note was uploaded on 09/22/2010 for the course FIN FIN310 taught by Professor Allen during the Spring '10 term at NC Wesleyan.

Page1 / 32

Excel07_L1_Ch2 - EXCEL 2007 Chapter 2 LINKSTO OBJECTIVES FormulaBar CopyaFormula Microsoft Excel 2007 Level 1 FeaturesSummary BACK NEXT EN D 2-1

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

View Full Document
Ask a homework question - tutors are online