{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Excel07_L1_Ch2 - EXCEL 2007 Chapter 2 LINKSTO OBJECTIVES...

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

View Full Document Right Arrow Icon
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
Image of page 1

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

View Full Document Right Arrow Icon
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
Image of page 2
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
Image of page 3

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

View Full Document Right Arrow Icon
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
Image of page 4
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
Image of page 5

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

View Full Document Right Arrow Icon
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  paste copied cells  into 2. Click Copy button or press  Ctrl + C 4. Click Paste  button or press  Ctrl + V
Image of page 6
Copyright 2007, Paradigm Publishing Inc.
Image of page 7

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

View Full Document Right Arrow Icon
Image of page 8
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    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.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    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.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    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.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern